Search results for query: *

I am running the following code which exports several files to Excel, then opens a master file with links to the exported excel files. The code works great, but I can only get the master file to open in read-only condition even though it is not a read-only file. Any suggestions on how to...

thanks gol...I forgot that column starts at 0 instead of 1

I need some quick VBA assistance in Access 2000...I am trying to take Column #3 (not the bound column) from a combo box called Manager and store it in a textbox called mgrparent after I have updated my selection in the Manager combo box. Does anyone have a quick piece of code that will help me...

Thanks for the help...I actually spoke with some of the tech staff this afternoon and it looks like this is a Netware related problem. If you are running the procedure on an NT server it will work just fine, but when you move it to Netware it hangs. I guess I have to wait a few months until...

I have a macro that involves several delete and append queries. It runs fine on my C drive, but when I copy the .MDB file to the network drive and attempt to run it there, Access just hangs. Could this be a permissions issue or is there some other solution?? Thanks in advance. Coopsman

I would like to create a field in a Microsoft Access query that does the following: If Right([Manager],5)="Funds", then remove "Funds", If Right ([Manager]),3)="Fds", then remove "Fds". Is there a way to easily remove x number of characters when a...

I am trying to set up a script that will run a report, then pause 30 seconds, and then enter "Y". Is there a basic command to make the script wait or pause for a specified period of time? Thanks in advance. Coopsman

Thanks for your comment, zorro. However, I'd like this to be VBA code because it will be a part of a periodic import procedure. Any other ideas??

Does anyone know of a VBA procedure that will replace periods in a table with a blank. I can't get an update query to work (tried updating "*.*" to "" but it wiped the field out completely) because the periods are within names and not at the same positions. For example, I...