Search results

Have you tried using the seek command? If I understand what you are trying to do correctly it sounds like the seek command may help you tremendously. Let me know if that helps good luck John

Franki I am just a beginner with Access but I am very interested in your dilemna. Could you please keep me posted on this project. I think it could be done because one of the great virtues of VBA is that it can connect almost any of the MSOffice products together. Have you checked the MSWord...

I am not exactly sure what you are attempting but have you tried to make a data access page in access database maybe then you could link it to the database using hyperlinks goodluck JOHN

On a report in Access you can set the reports data source property to a query perhaps you could create a parameter query that will prompt the user for a field for the indiviual student and create the report based on that student I would suggest a student ID number because student ids are unique...

Have you tried (after apppending the new data to the table of course) to open the table as a recordset then use the sort proerty on that recordset. for example: 'you must first create the recordset dim mydb as CurrentDB dim myrs as Recordset 'after the declarations you must define the '...

I am not sure but could you scan the document as a text file then use the transfertext import command on a forms command button click properties and read the document into the table using the import fixed width specs. This process may seem longer but if the document you wish to read to the...

I know that it is strange for someone to reply to his own posting but I thought that maybe somebody with the same problem could read my posting and my reply Well in answer to my posting the correct way to reference a variable as a tables field in VBA for Access is like this: [TABLE NAME] (ITEM)...

Could some one help me with a variable problem I am having. I declared and defined a variable in a module and made that variable public I can pass that variable from form to form and function to function no prob but I am having trouble using the variable to reference a tables field the variable...