Search results

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...

@pr2-eugin: Thanks a lot! That worked exactly as I wanted it to. :D

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...

@pbaldy: Thanks a lot!! It works as I want it to. You just solved a huge problem for me :) And you are absolutely right. PartID is 1, 2, 3...upto the number of parts that the user has entered. If he has entered 5 parts, PartID would be from 1 to 5. Actually, the user enters directly into the...

@pblady: Thank you for that suggestion, but I am still getting an error (Type Mismatch). I shall explain what I am trying to do and maybe you could point me in the right direction. 1. Get all part numbers from the user 2. For each part number, I ll look up some specifications from a different...

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()...