Search results

I've attached a print screen of the error message I keep getting. I even created a new table called Tbl_Seek and altered the SQL accordingly but it insisted it couldn't find it!

There WAS a db in Documents, but it wasn't called "Documents" and it's now deleted. The query is now looking for a table called Tbl_Find in the correct folder, which exists, but Access says it doesn't :banghead: I'm curious as to the problem with the SQL, apart from my erroneous placement of...

There's nothing in the VBA editor, and here is the SQL: INSERT INTO (Tbl_Find) Description SELECT Description AS Description FROM Tbl_Tools WHERE Tbl_Tools.Part_No = Tbl_Find.Part_No;

Nope, it is looking for the database in Documents, and it's on Desktop, and the table DEFINITELY exists.

Not sure where to put this as it's not a query specific question I guess. Anyway, when I run the query it keeps insisting it can't find the table in Documents, which is strange because the db is located on the Desktop and no copy exists in Documents! Can't find any settings to alter so anyone...

Thanks I didn't know.:D

Mods can we close this thread please? I've changed tack so it is now irrelevant. many thanks, Lol

To be honest it is the need to display what has been entered in a continuous list that has necessitated the formation of extra tables. The relationship between Tools and Location is managed nicely with just 3 tables. I was using a table to display scanned items, inserting the list into the...

I've since rationalised the structure a bit and deleted one of the tables, Tbl_Find. It was unnecessary since I can do all I need to with Tbl_Display. Cells are still not updating though. Any ideas please?

Could do with a bit of advice on this one please. I have attached the relationship layout for my database and I'm struggling to understand why certain fields automatically fill on a form and others don't. For instance, I have a form with a subform. In the subform is the table Tbl_Display, this...

The ID field is the Primary key in two tables but is not an Autonumber. I'm getting runtime error 3201, a related record is required in the Location table. Turns out I was not entering the location code properly. D'Oh! Many thanks for your help so far. What I need to do now is add code to...

Thanks for that I'll have a look at the link. I've just run the code but nothing is happening, the table I want to insert into is not being updated. Initially I had the wrong table to insert into but having changed it there's no action. Here is what I have: Private Sub Command7_Click() Dim...

This is where I struggle all the time, the ' and ". Can't find a good resource to explain them. Thanks I'll give it a try.

This is what I have so far, getting error 361 though Private Sub Command7_Click() Dim strSQL As String strSQL = "INSERT INTO Tbl_Location (ID, Location) SELECT ID, Forms!Frm_Booking.Txt_Location FROM Tbl_Display" CurrentDb.Execute strSQL End Sub

This is what I have: INSERT INTO Tbl_Location (ID, Location) SELECT ID, Forms!Frm_Booking.Txt_Location FROM Tbl_Display But the ID keeps causing a compile error with a Expected:case statement. Am I missing some de-limiters or some other some such?

First of all - IS THAT IT?! Secondly, thank you I have been going round in circles! I'll give it a try and let you know what happens :-) Cheers, Lol

You see I was going to use the On-Click event for a button and do it in a mix of VBA andSQL. The textbox variable is the sticking point here, I just can't figure out how to include it in an SQL statement :banghead:

Okay, I think I have some of it sorted. I decided to create another table, called Tbl_Display and embedded this in a subform. The main form has a simple text box, Txt_Location, for entry of the location tools are to be booked to. Tbl_Display is linked into the table Tbl_Tools on a many to one...

On reflection I'm not sure how I'm going to make this work advancing the cursor through the grid. Bit more thinking required.

Hi DocMan, I think after some playing around I'm going to go for the unbound option. I have worked with record sets and connections in the murky past so it's starting to ring a few bells. What I am trying to accomplish is a simple form with a text box at the top which receives the location...