Search results

Appreciate the input. Myself I never had an issue, but should the need arise again will use your method going forward.

You are welcome. Though I would suggest you go with ChrisO's usage if you use it.

Better late than never :P You are welcome.

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 =...

To get to the "visual table designer" simply Right click the table in question and select Design View.

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...

Welcome to my profile.

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...

Certainly. We shall see.

I will look at it when I get to work again tomorrow.

raskew I am not re-inventing anything; I simply made suggestion in Post#2 which pre-ceded Post #5 and I even said in Post #2 it would probably break if used past splitting on the comma in different wording of course. Given the later suggestions, such as Post #5, I certainly do not suggest that...

No argument there. My thoughts in my original post with the split function were to avoid such traps in the names. Thus I thought splitting on the comma would alleviate any issues with the Last Name and leave the hard work for where it can not be avoided.

Yes, I tried to stay true to the original function you posted.

You mean the textbox I set to the WorkOrderID's last value? It was simply easier for me to set its value while unbound and was personal preference, be that right or wrong. If you can bind it and get it to display the value you wish, when you wish, then by all means go ahead and do so. That may...