Browse by Tags

Problem: Query finds records in Access interface, but not in VB6 or VBA.

I have one particular query that works OK in Access from the design interface, returning 13 records, but returns no records when run from code. Other queries work. It isn't particularly complex. This is the stored query SELECT Volume.label, Path.name, Thumbnail.name FROM Volume INNER JOIN (Path INNER...

Posted to Access Coding/Macros (Forum) by microsoft on 05-27-2009
Problem: VBA for access - include separate form data in outlook task

I have an access 2000 form called EditMaintenance that includes a subform called Assets_subform. On a click event I run some vb code that does some stuff and ends with an outlook task that keeps blowing up. I'm pulling information from my form to include in the task subject, which works fine but...

Posted to Access Coding/Macros (Forum) by microsoft on 05-27-2009
Problem: Insert word of excel document in access table via VBA

I want to insert an excel or word file into my table. I'm working with a form, which contains a textbox (and a browse button) that is the whole path of a document. Now on the save action, I want to import this document into my table. Can anyone tell me how I can do this? When anyone else opens this...

Posted to Access Coding/Macros (Forum) by microsoft on 05-27-2009
Problem: How to modify Access VBA code so that the contents of 1 Access table are transferred to 2 worksheets within 1 Excel file ?

I am creating an Access Application using Access as the front end and SQL Server as the back end database. I realize that if I used Excel 2007, that I could transfer up to 100K records to Excel from an Acess tabole. I will get to do that in a couple of months. For now, I was wondering if you could show...

Posted to Access Coding/Macros (Forum) by microsoft on 05-27-2009
Problem: Append incremental numeric data based on occurence of concatenated string in query.

I am using MS Office 2003, and I have an auto-increment question. I have a select query that concatenates information from several fields in a table to form an ID for this person based on the year and month of entry, the name of the user and an alphabetic code they enter in a textbox. This will return...

Posted to Access Coding/Macros (Forum) by microsoft on 05-27-2009
Problem: Linked Tables in Access cannot be opened

Hi Experts, I'm struggling with this problem for long. I have one database (say dbA) that has linked tables to another database (dbB) on the network. When some user is using dbB, my program in dbA that make use of the linked tables cannot work. At that time, when I tried to open the linked tables...

Posted to Access Architecture/Design (Forum) by microsoft on 05-27-2009
Problem: Lookup date in combo box

I have a combo box with a row source of CaseNotesID 'key to the table Date: Format([CaseNotesDate],"mm/dd/yy") 'date field seen by the user ClientFileNo 'numeric field foreign key If I use the first line of code below it finds the record when the user selects from the list. However...

Posted to Access Forms (Forum) by microsoft on 05-27-2009

Page 298 of 298 (2977 items) « First ... < Previous 294 295 296 297 298

Browse by Tags

Problem: Query finds records in Access interface, but not in VB6 or VBA.

Problem: VBA for access - include separate form data in outlook task

Problem: Insert word of excel document in access table via VBA

Problem: How to modify Access VBA code so that the contents of 1 Access table are transferred to 2 worksheets within 1 Excel file ?

Problem: Append incremental numeric data based on occurence of concatenated string in query.

Problem: Linked Tables in Access cannot be opened

Problem: Lookup date in combo box