Search results for query: *

I am getting an "ODBC - called failed" error when trying to run a complicated query using ODBC linked tables. I found that if I change the property of the ODBC Timeout to 0, the query will run. However, I have code which runs each query rather than manually running each query. Is...

When I do this: wBook.Worksheets("CC5_Graph").Copy before:=wBook.sheets(6) it gives me the following error: "Subscript out of range" err.num = "9" The funny thing is that wBook.Sheets.Count = 10. I tried the following code also and got the same error...

I am trying to copy a worksheet in an excel workbook and paste it within the same workbook using VBA. For example, I want to copy "Sheet 1" before "Sheet 8" using VBA code. Does anyone know how to do this? I am using MS Access 97. The following code is where I am at right...

I am running windows NT. Any thoughts on a possible problem?

This is a bit more of my code. 'open and show Microsoft Excel and the FPG Template file Segment_Xls = "Fpg" + ".xls" WPath = "K:\SFS\Nackers\Gunnar_Reports\Templates\" + Segment_Xls Set WBook = GetObject(WPath, "Excel.Sheet")...

I am getting a run-time error '458' which reads: "Variable uses an automation type not supported in visual basic." I do not know why i am getting this error... This is the line of code where it is occuring... Set WBook = GetObject(WPath, "Excel.Sheet") I have the...

I discovered how to have one application point to one workgroup (Thanks for all your help - much appreciated). One other missing piece of information I need is, how to find who is currently using the application. I want to be able to show a message box telling the user "Joe Black is...

I did your shortcut suggestion. But, I am still unable to limit this workgroup to only one application. How do I.... "...make sure that your users are members of the default workgroup, not your workgroup." - I think this is my problem. Thanks, Mike

I am not using this for security reasons. I simply want to have a message telling a user the name and phone number of the person currently using the tables (if two people were trying to access the same query). Your help so far is really benifitting me. One more question: How do I limit the...

I set up myself as the admin, and another employee for testing. It works well on my computer. When I had the other employee log onto the database, he wasn't prompted for the password, and was automatically called the admin. I also have a password for the admin, so at least he should have been...

Thanks for this information. I got the "READ ACCESS ONLY" message to dissappear. How do I find who is logged into the database? When a two people are running the same query, the second person gets an error message saying... "Couldn't lock table 'TABLE'; currently in use by...

Is there a way to permit multiple users within one access application over a LAN? Right now, my program only allows one user to actively use it. If another person enters the application, they have read-only rights (which makes sense because a table could be in use by the first person). Is...

HTH - Thanks for your help. I am getting the files to import. One more question...........When I import the text files, I am always losing the first record from the text file. Why is this, and how can I fix it?? Thanks, Mike

One more thing......... This code works fine (at least it links to the file). But, all the data is in one field. The problem is the fixed format. Thanks, Mike

I need some help.... I want to import a text file using VBA code. The text file is a fixed format (each field I want to allocate a specfic number of characters). How is this possible? This is some of the code I have already written...

I am having a difficult time automating Microsoft Excel via Microsoft Access code. I dumped my Access data into specified Microsoft Excel worksheets and want to create charts from that data. My problem is that Access doesn't allow me to manipulate any chart series other than the first. Here...