Recent content by KF

Go to thread701-245983 Tranman just helped me with this same thing. KF,

Build your query to incude two of the ID number fields and alias the names like...(ID1) AND (ID2) then enter into the criteria row of ID1 [Enter ID1], then on the second criteria row of ID2 [Enter ID2]. Providing both of your entries have made a purchase you will see them listed in your query...

Have you tried using the HasData property. Search Access help on this property. I think it will do what you want. KF,

If it is possible you should use update and append queries for this operation, if your going from Access to Access. Then adding an updated and Exported field to your tables you can control what information is transfered. Good Luck,

You could try and add the field and if it is there then the following code will not add it as Access will only let you add a field to a table once. Dim MyWorkspace As Workspace Dim MyDatabase As DATABASE Dim MyField As Field Dim MyTableDef As TableDef Set MyWorkspace = DBEngine.Workspaces(0)...

I would like to know this two if anyone can help?

If you have a custom login screen you could just use a global variable like gstrUserName and set the name of the user to this variable long enough to put it where you want it then empty it?

Have you tried decompiling you mdb file? For example: select Start | Run and enter your information inplace of this; "C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\MSACCESS.EXE" /decompile "c:\YourFolder\YourDatabaseFile.MBD Good Luck,

Yes, try this in the control source of a text box on your form. =Format(Sum([YOUR TIME FIELD NAME HERE]),"h:nn:ss") Good Luck, KF

Yes, here is a sample of code I used to change the size of a field that currenly had data in it. You can modifiy this code to work for you. You must first create a temp field and move your data into it. Then create the new field (new name)and move your data into it. Then drop the old field...

Use a sub form on on your main form and when a button is pressed on the main form in the on_click event of a button try me!yoursubformhere.recordsource = "yournewrecordsource" me!yoursubformhere.requery

Please explain this! (but I need to be able to add new ones without physically adding them into the DB.)

If your bored go home.

Use the on_exit event of the text box to set the row source of the list box. Or you could just requery the row source of the list box. Make sure you have added a parameter to your row source SQL statement or query based on the entry made by the user into the text box on your form. For example...

Put this under on the on_click event of a command button. On Error Resume Next Application.Run "ACWZMAIN.sbm_Entry" You will need to check and make sure the switchboard manager is installed on the PC's KF