Search results

Hi, I am exporting a record set to Excel within a loop and I am encountering the following error while defining that record set: Error 3061 - Too few parameters - Expected 1 The line of code highlighted is: Set SResults = db.OpenRecordset(sqlResult) The line in context is: For x = 1 To n...

Hi, I get the following error when I open a record set: Run-time error 3075 Syntax error in query expression 'Equiptment = 40' Standard Dry" I am guessing that the error is because of the symbol ' in the string. But here 40' stands for 40 feet and has nothing to do with SQL. How do I make...

Hi, This is what I want to do: 1. I have a split form with a button. When I click the button, the table should open in a newly created excel file. 2. The user will make some changes to the data. 3. At this time, a pop-up box will appear in the access window saying something like, "Do you...

Hi, I have a split form which I am filtering based on selections from two cascading combo boxes. The filter works fine with the first combo. But when both the first and second filter is applied, I get a syntax error. The piece of code that I am using in the after update event of the second...

Hi, I have adapted a piece of code which is used to copy a record set to an excel worksheet. What I want to do is copy multiple record sets one after the other and paste them side by side in the worksheet. This number of record sets is not fixed and is determined by a counter. Basically, this...

Hi, I have a button in the main form which opens another dialog type form. This form uses some values in the main form to populate its boxes. When this form is in normal type, everything works as it should. However, when I use 'acDialog' to open the form, the form gets opened but the fields are...

Hi I am mid-way through a database system and suddenly today, its size has increased tremendously. It was 12-13 MB till yesterday and today, it is 230 MB. Also, some VBA code is not working as it should be and it is very sluggish. I tried Compact and repair but it only decreased the size by 2-3...

Hi, I am trying to run a query from within VBA and I am coming up with this error. Please help! Set TACData = CurrentDb.OpenRecordset("SELECT * FROM TACWithLRB_tbl WHERE [Part Number] is not null AND [Supplier Name] = Me.SupplierName_cbx.Value AND [Destination Plant] = Me.PlantName_cbx.Value...

Hi, This is what I am trying to do: 1. I have a form with a sub-form which is a query output in datasheet view. 2. Adjacent to this sub-form is another sub-form which is another table with information about the corresponding line items in the previous sub-form. 3. I need to use the...

Hi, I have to extract certain cells of an excel file and update an access database. I have already found code in this form which does exactly that. The problem is, this code has the path of the file built into it. I want the ability to be able to browse and choose the file. I have tried out a...

Hi, I have a form with two combo boxes (Supplier and Plant). In the same form I have a table in datasheet view as a sub-form which shows all suppliers and all plants. I want to be able to select a supplier and a plant and I want the table to show only the entries matching that criteria. Any...

Hi, I am running this code to calculate some expressions using the values stored in a table and then return them to another table. I am using a For loop with a counter to move from one row to the next. However, when I run the code, I get error 2471. The code is: Private Sub LRB_TAC_btn_Click()...