Search results for query: *

I recently made some unrelated changes to my db and some code I had to update counts in a table worked perfectly but now doesn't work. Err.description tells me it's a syntax error and it occurs right after the SQL for counting distinct employee IDs. I have tried everything I know to figure out...

I have a db which does most of its work in VBA. On a button click, it imports a table, modifies it, and then users can run queries to see different data. Everything works perfectly until the user tries to click the button again to do a second import. Then it works erratically or not at all...

We recently migrated from Impromptu 6.0 to Cognos 8.4, using Report Studio and Query Studio. Under Impromptu, I was able to automate many MS Access tools using VBA to call Impromptu, run imrs and import tables into the Access tool. Now that we are web-based, I have lost all my automation. Is...

Employee ID Job Title Effective Date ------------------------------------------ 12345 Mgr III 2/15/2006 12345 Mgr II 3/1/2005 12345 Engineer III 2/28/2004 22741 Admin III 2/7/2006 22741...

My data looks like this: John Doe is currently a Mgr IV Name Job Title Effective Date ------------------------------------------ John Doe Mgr III 2/15/2006 John Doe Mgr II 3/1/2005 John Doe Mgr I 2/28/2004 I want to have one row in a...

I have been calling Impromptu 6.0 from MS Access, running reports and importing the results into Access with no problem. I now have a situation where I need to pass two dates from an Access form as prompts for an Impromptu report. I have tried everything I've been able to find in this forum...

I have an application which requires users to submit data they fill in on a form. The form is linked to a SQL database. Some users think it is enough to fill out the form and exit the page/browser without clicking the Submit button. The result is that some user data gets lost because they...

I have an application which requires users to submit data they fill in on a form. The form is linked to a SQL database. Some users think it is enough to fill out the form and exit the page/browser without clicking the Submit button. The result is that some user data gets lost because they...

I have an aggregate query which brings together results from six separate queries.The six sub-queries are based on a table which changes every month. They calculate a % based on categories. The categories may come and go throughout the year, with the result being that one or more of the...

I have an aggregate query which pulls together calculation results from 4 different queries (each query provides a percentage). These four queries run off a table which changes monthly. Because of the nature of the data, one or more of the four queries may come up null in a particular month...

I am automating a process in an Access 2000 db. I have some code which runs a Oracle server front end (Cognos Impromptu), runs five queries, and exports them as Excel spreadsheets. The problem is that Impromptu will only export as Excel 3.0 sheets. The code then imports them into Access...

I am trying to autofill a subform with interviewer info from a table based on who logged in. Interviewers fill in the form with the results of their interviews.The code below works but only two fields are appearing initially(FName, LName). This seems strange that only two would appear.(The...

I have a subreport which contains several fields all of which are set as 'memo' in the table and all contain between 5 and 10 lines of text. When viewing the report containing my subreport, the subreport cuts off the data and only shows 2 or 3 lines of the text contained in the field/table...

Does anyone know of a way to prevent someone from linking to a database and gaining access to its tables? Neither db has any security set up. I just want to prevent the linking.

Here is the code I have in the Nodata event of my report: MsgBox "No data matched your criteria" Cancel = True There is no error handling in it now because I have tried every error trapping procedure I could find and nothing stops the VBA msgbox from popping up with the 'End' and...

I have a query that pulls demographic information about various locations of our company around the country. I want the user to be able to select multiple locations from a list/combo box and the After Update event will pass those values to the query in order to provide a "combined&quot...

I have a query that pulls demographic information about various locations of our company around the country. I want the user to be able to select multiple locations from a list/combo box and the After Update event will pass those values to the query in order to provide a "combined&quot...

Based on some other threads I read, I tried the following code to trap error 2501, OpenReport Event Cancelled. This is from the NoData event of my report. It also resets the form controls to Null. No matter what code I try, the runtime error msgbox appears with the 'End' and 'Debug' buttons...

I tried to open a much-used database this morning and received the following message after entering the db password: "The database (full path) needs to be repaired or isn't a database file. You or another user may have unexpectedly quit MS Access while a MS Access database was open. Do...

Can anyone tell me why the code hangs at the "set rstAdmin = OpenRecordset, etc. line with a Type Mismatch error? I have looked at examples and can't find the problem. Here is the code: Private Sub Command2_Click() Dim db As Database Dim rstAdmin As Recordset Dim PSID As...