FishVal,
Your code produced the same error as mine. From what I'm able to see is the refresh code is where the problem is. My code originally takes the queried result from the following worksheet (GNSHRStaff Report.xlt) to (Staffing1)...
ewarts
Last Activity: Aug 27 '07, 01:27 PM
Joined: Jul 24 '07
Location: NY
-
Not necessaryly the header section but within the same form, precisely the combobox above.Leave a comment:
-
The code takes the the info from access to excel by way of vbaLeave a comment:
-
The problem lies with the line below, the debugger goes to this line when I step through the code
Workbooks(nn).S heets(1).QueryT ables(1).Refres hLeave a comment:
-
...Code:Private Sub Workbook_Open() Dim strsql As String Dim strTW As String Dim strHdr1 As String Dim STRHDR2 As String Dim xcnt As Integer Dim ycnt As Integer Dim rgend As String Dim dd As Integer Dim nn As String strHdr1 = "" STRHDR2 = "" strTW = ThisWorkbook.Name strsql = "SELECT * FROM Q" & Environ("username") &Leave a comment:
-
Did you have to setup a template first? there and already existing macro that export to excel by means of taking the queried result exporting it to one template then copying to the formatted sheet but it keeps aborting when moving from the first sheet to the second. I can send you the code.Leave a comment:
-
How to create a macro in access
How can I create a macro that will take the results from a query and export to a formatted excel sheet? -
I will look into that shortlyLeave a comment:
-
Access DB Does not open
[IMG]
Hi all,
I have a DB that a few access however one of my colleague cannot access the DB which give the following error.
"MS cannot open this file. This file is located outsideyour intranet or on an untrusted site. MS will not open the file due to potential security problems.
Have anyone gotten this before and what was the solution?
Thx -
I sure did, that was my first thoughtLeave a comment:
-
ewarts replied to error "database engine could not lock table because it is already in use by other"in AccessI will try that suggestion, BTW I got a snapshot of the past 30 days backup and from first glance noticed that several days were opened, this might be the cause/root of my problem. I will give catalog my findings and report.
Thx allLeave a comment:
-
ewarts replied to error "database engine could not lock table because it is already in use by other"in AccessThey backup on a nightly basis however I may have left the db running over night....Leave a comment:
-
Adding combo box to an existing form
Hello all,
I'm having an issue adding more combo box to an existing form, please correct me if I'm wrong in my method but i'm copying the combo box above and pasting it below so to have the same format as the others and to minimize my efforts. The form has a subform so i'm creating the same for that form also but after all is said and done it doen not display on the main form. What am I doing wrong.
ED -
ewarts replied to error "database engine could not lock table because it is already in use by other"in AccessScott,
I think what's happening here is, when the firm runs a daily back while the file is being updated then that backup file will still be open even though I may close the original. I'm hoping this is the case, can you or anyone confirm this?...Leave a comment:
-
ewarts replied to error "database engine could not lock table because it is already in use by other"in AccessNo codes just the access standard procedures.Leave a comment:
-
ewarts replied to error "database engine could not lock table because it is already in use by other"in AccessWhile trying to add the combo box to the form? No I don't think so.Leave a comment:
-
ewarts started a topic error "database engine could not lock table because it is already in use by other"in Accesserror "database engine could not lock table because it is already in use by other"
Hey Guys,
I have an access database with a few tables and forms. I was trying to add a new combo box to one of my forms and to do so i needed to add the referenced data to my reference data table. simple or so I thought, but while attempting to do so I got the following error ""database engine could not lock table because it is already in use by other " . I am currently the only user with access to this database so i'm... -
Application-defined or object-defined error
Hello all,
I keep getting the following error whenever i execute a access program. The program is supposed to retrieve data from the source database and then put it into an excel spreadsheet then replace it into a new excel spreadsheet which is a formatted sheet. Can anyone assist.
Here is the error below in bold, the second line is the line that the error is trying to debug:
Application-defined or object-defined... -
Application-defined or object-defined error
Hello all,
I keep getting the following error whenever i execute my script. The script is supposed to retrieve data from the source database and then replace from one excel spreadsheet to a formatted sheet. Can anyone assist.
Application-defined or object-defined error
Workbooks(nn).S heets(1).QueryT ables(1).Refres h
No activity results to display
Leave a comment: