Well if you have access open you could import and Append via a query to your table like so:
INSERT INTO ExistingTable
SELECT YourTable.*
FROM YourTable IN 'C:\SomePath\DB1.mdb'[MS ACCESS;];
One step further and using VBA you could loop through several DBs making the Table names, file names...
Sure.
If you are using vba you could change this:
"SELECT TOP 10 TABLE1.* INTO 1SAMPLE FROM TABLE1 ORDER BY TABLE1.ZIP;"
To this:
"SELECT TOP " & VariableHere & " TABLE1.* INTO 1SAMPLE FROM TABLE1 ORDER BY TABLE1.ZIP;"
"VariableHere" would be your dynamic number from your textbox.
I do not believe there is a way to prevent the "Trimming". You may be able work around it though. For instance you could use the Change event and encapsulate the text in brackets thereby keeping the trailing space. To make this appear seamless to the user you could use Text1.SelStart =...
As I understand it you are not able to Sum a calculated field like yours in the way you want. http://support.microsoft.com/kb/207763
If this is in error then please let a more experienced member correct me.
This gives you a few choices:
You can repeat the calculations for the calculated...
Aren't you able to right click on the Tab of an open table in Access 2007 and close it that way?
I could be wrong of course but I think it is possible. I do not have it here at home to test out...
I am glad I was able to help.
A calculated field calculated on the fly? For example adding and subtracting individual transactions based on a customer?
If so my suggestion would be to make an update to a new field or perhaps a new table and field that includes a customers Record number and...
You will need to insert code to carry over the details to the subforms. In the ShowIdentity function you can re-use some of the code for this purpose or not.
If you do not want to adapt a new function you should be able to use the LstID variable prety much anywhere the WorkOrderID is needed...
Yes, because when you append to the WorkOrder table it creates the new WorkorderID at that time. You would have to move the code that grabs the new WorkorderID up before the second and third Appends to be able to have the new WorkorderID for use with them. I did not make the Second two appends...
I have added your two appends and a brief timed disable Button code to the new version. Essentially the button is disabled after it is clicked, then after a short period in a do loop it re-enables itself thus preventing un-intentional dblClicks. It may not be the slickest code but it seems...