Search results

Hi Everyone, Can someone please help me. I am trying to create an excel file through Access and i get run-time error 430 Class doesnt support Automation. I have attached my code: THANKS!!!!!!!!!! Private Sub cmdGetReport_Click() Dim adoConn As New ADODB.Connection Dim adoRec As New...

Hi everyone, Can someone let me know how I can tell if the access file I am using is the design master. Thanks! -mays

I didnt do it all at once b/c alot of times, when someone is doing the search, they only know the last name and state fields----if i narrow it down by last name, it is easier for the user----they wouldnt have to do the search as many times when i narrow down the fields for them.

Hi Everyone, I need help with my application speed. I have a form that first asks for last name, then goes thru 400,000 records to search all first names in the database with that last name. Then, i search again thru the 400,000 records to get all the states with that first and last name...

Hi, Is there a way for me to release my application to my users without them being able to see my code? To only give them access to the form I created and not the code behind it? Thanks!!! -mays

Can someone tell me what is wrong with this statement? db.execute (INSERT INTO LOOKUP_DATA (current_12_mon) values select sum(current_12_mon) from LOOKUP_DATA); The error I get is "Syntax Error in INSERT INTO statement" Thanks, -mays

Thanks for the reply. The problem with that is that I think it will be too messy b/c I have more than 1 criteria for the user to do the search. They must select last name, first name, city and state to get their needed data. Any suggestions on how i can make it cleaner? Thanks!

Hi All, I need some help. I have created a form in Access that queries on a persons last name and sends all the info on the last name to an Excel spreadsheet. I want to send multiple people's data to the worksheet---but when i try to do this, I only get 1 person's data at a time in the...

Hi, I am trying to format my report. I have a list of zip codes and I want all the zip codes to appear on 1 page, in columns. Right now, ti shows up like this: Zip Code List 12335 11111 22222 33333 44444 55555 66666 77777 88888 99999 and so on.. but I need it to show up like this: Zip...

Hi All, I am trying to generate a report from the click of a button on a form and I am stuck. Here is what I have: Function GetZipCodes(RepName As String) Dim db As Database Dim wrkJet As Workspace Dim SQL As String Dim qdfTemp As QueryDef Dim rstZipCodes As Recordset...

Hi All, I have a bunch of excel workbooks where the info repeats itself. I am trying to move all the info to Access. How do I extract the info from an excel spreadsheet and have a table created from that info? (for example: The columns on one of the spreadsheets are ProductName, Sales and...

I have 2 separate forms. When i try to update the database using the 2nd form, I get "The database has been placed in a state by user 'Admin' on machine 'MAYS' that prevents it from being opened or locked. Each form has the following VBA code: Set wrkJet = CreateWorkspace("NewJetWorkspace"...

Thanks!! That worked.

Can someone tell me what is wrong with this line: SQL = "update tblGroupAndMembers set group_id = '" & !group_id & "' where member_id = '" & memberId & "'" I keep getting 'Data type mismatch in criteria expression.' If i hard code memberId then I dont get the error. I dont understand what I...

Hi All, I am new to VBA and am workign on a small project. I want to retrieve a value from one table and insert that value in another table. As in: SELECT id from tblList where name = 'mays'; say the value is 5 and when i get this value, i want to insert it into another table called tblId...