Search results
-
M
Copy rows based on field value
vbaInet/dcb Thanks for all the help, I've been trying to work this out for so long. I've taken your example but I'm getting a Run time error 3021 error No current record at line If (!products_stock_quantity & "") <> "" Then all my code is below, do you have any ideas? Dim yRow As Long, i...- MJT
- Post #11
- Forum: Modules & VBA
-
M
Copy rows based on field value
Thanks dcb but I don't get the Insert into the table Alter the original record to 1 what do you mean?, can you give me a bit more info. Thanks again for the help.- MJT
- Post #3
- Forum: Modules & VBA
-
M
Copy rows based on field value
I have only have basic levels of Access and VBA and hence have spent hours trying to find a solution in VBA to my issue and was hoping someone might be able to shed any light on how this can be achieved or have any sample code. I have a table that contains rows of items with a quantity in the...- MJT
- Thread
- Replies: 11
- Forum: Modules & VBA