Search results for query: *

Hi I am trying to write in a macro a vlookup condition. Basically i would like it to lookup a date match and paste a value. This is what I have now: Sheets("INV").Select Range("A4").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False...

Hi, I am trying to alter column type by using the following code: DoCmd.RunSQL "ALTER TABLE DATA-SP-09 COLUMN AIR MILES Collector #/ Numéro d’adhérent AIR MILES TEXT" It is giving me a syntax error, I believe it is because of the table name and column name which I can not modify is there any...

Hi, I am trying to save an excel file with access vb script code. The code I am using works the first time around but when I run it again it gives me an error: Run Time Error 91 Object variable or with block variable npt set. Here is the code: Set r1 = wbk.Sheets("CTAS Total...

Hi, I am importing data from excel to access table one of the field is in date/time format. Within excel the date type is consistent with mm/mm/yyyy hh:mm format. When I import this data into excel using the get exteranl data method from access. This data field changes the format: all dates...

Hi, I hope someone can help me with this. I have an access table with one single row data, I would like to transfer this to an existing excel worksheet, and then copy&move that worksheet to a new workbook break the link and then save it to a specific path folder naming as "Transit 0000.xls" I...

Hi, I am trying to get multiple query results in one record. I have five different queries the results of which does not have any relation to each other. I would like to have one record produced for all the queries with its original headings. Is it possible? Can anyone plaese assist me...

Hi, I have 4 queries each query sums up one specific criteria. I have another query that looks at each one of these query and captures the sum value and shows in one record with 4 fields. When one of these query does not have any value my final query does not return any result even if I have...

Hi, I am trying to sum fields with time (12:05:15 + 10:25:03). I know the total should add up to 22 Hours, 30 mins and 18secs but it adds up to a very diferent number. My guess is the format issue. Is there a way where i can get this done in a query where I just sum up the fields?

Happy New Year to All! I have a table with fields as Department ID, Name, Item, January, February……December. There are four different types of item. I have created queries to separate these items and have a table for each item with Dept ID, Name, January, February……December. What I would like...

Hi Can anyone help me with the code for a command button in access where I will get the same option as you would when you right click in the access database and then click on the import table option.

Hi, I am trying to import an excel file into access table. Until yesterday I had this code and it was working fine, where it imported the excel file into access table and named it. This is the code I am using: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "", strFileName, True...

Hi I am trying to import an excel file into access. Until this morning I was able to do that just fine, but all of a sudden I am getting this error: "The action requires a Table Name argument" This is my code: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "", strFileName, True...

Hi, I am working with access database, one of the process is to import an excel file, before I import I need to delete the blnak cells and other data that I do not need. I am using this code: Dim RetVal Dim strSettledFile As String RetVal = Shell("C:\Program Files\microsoft office 2003...

Hi, I have a query table that holds value in text data type. What I am trying to do is add these values for each staff. For example: Smith sells Oranges, Apple and Bananas the number is stored as text like 01... Name Orange Apple Banana Total Smith 01 02 When I try to use the a query Like...

Hi, I have about 15 queries that run to generate a report. Is it possible to somehow deactivate the warning message that pops up for each query that I run. Some of my queries are make table queries. If possible I would like to minimize the user to have to click on those 15 warnings. Any help...

Hi, I have a excel spreadsheet report. This report has two drop down box one for the staff and the other for the months. I use the drop down box to select my staff and see their report for the month. What I am trying to do is create two printing options either by using check box or options box...

Hi, I have a query that performs division based on two field values. My problem is the result it shows is huge and shows something like this: 8.00681431005111E-02 What I would like the filed to show is 0.08. I have tried to format the text box that holds this value on the report. I tried to...

This works for one text box, now I want to autofill other text boxes. Such as Pick the name, and, the ID, the mgr name and mgr ID fills in automatically. I am trying to automatically fill 3 more text boxes once I fill in one text box. I am using the process below which works for me to fill one...

Hi I have 4 text boxes: Box1 has IDs; Box2 has names; Box3 for sales, and Box4 for the dates. I would like to setup these boxes in such a way that if I type in the ID the name is automatically filled in the name text box for that id. From here these values are updated into another table. I...

Hi, I have a excel spreadsheet report. This report has two drop down box one for the staff and the other for the months. I use the drop down box to select my staff and see their report for the month. What I am trying to do is create two printing options either by using check box or options box...