Search results

That idea worked very well. Here is my code in the Form_Load() procedure: DoCmd.SetWarnings False strSQL = "DELETE * FROM Database_Copy" DoCmd.RunSQL strSQL strSQL = "INSERT INTO Database_Copy SELECT * FROM Database" DoCmd.RunSQL strSQL DoCmd.SetWarnings True...

Ok, thanks.

Interesting issue I can't seem to solve - The copyobject command is saving the copied table from the BE database to the BE database instead of the FE even if I specify the destination. I can't seem to find a solution to this. FE location: C:\Users\user.name\Desktop\ BE location: J:\Database\...

Ok. I can do that. My concern is how to get updates to the users, but that appears to be another question and I'm seeing several solutions in the forum. Thanks pbaldy

Sounds like some good ideas. The current process is that the user enters data in a textbox, the data is posted to a table in the BE database on the server, and then the table is refreshed with data from a query. When it's all on my computer, it's instant. When the BE is on the server, the...

I'm hoping that there are some potential solutions to a slow network that I have no control over. Currently I have a vba program in Access that draws information from a BE database. Sometimes, though, the network is excruciatingly slow - as in 3 second wait times to refresh the listbox after a...

Both suggestions above were done prior to the post without success. But, I found the issue. I was curious as to why there were 2 blank spaces in the string CITY-02332 ;Admin ;True; ("2 ;" and "n ;") even after using the TRIM() command and it turns out they were null characters - ASC(0). I...

I am trying to populate a multicolumn listbox with listbox.additem and cannot see my data in the other columns. So, I know your first thought - separate the items by semicolon inside of a single string, make sure the column count is more than 1, choose value list, ensure the columns are wide...

Oh Ok. Didn't know that. Thank you very much.

I guess I'm not understanding. How/Why would a subform allow me to show more than 32K of data in a list box or see the size of the list box?

Some divisions have over 320 lines of general ledger accounts that they need to enter a budget for. Most divisions see a complete list of accounts, but it's being cut off for a few that exceed the 32K data limit. My idea of listbox.size would be to return the amount of data in bytes that the...

Does your subform already contain a complete list of suppliers that you'd like to filter or are you filling an empty listbox? And, I'm assuming your subform contains a listbox for the list?

Is there a way to easily determine if a listbox is full. Ideally, it would be great if there was a listbox.size property that I could check after each listbox.additem, but there isn't. My problem is that I'm using a 10 column listbox that fills up right around 320 lines of data (32K) - plus or...