Search results

Many thanks!

I was editing and using from a linked pair off the company network so I'm a bit confused on that one.

Okay here it is. The form is frmInspection.

Bear with me

This is the sql for the cbbox2 : SELECT tbl_Product.ID_Product, tbl_Product.Part_No, tbl_Product.Details, tbl_Product.Date_deCommissioned FROM tbl_Product WHERE (((IsNull([Tbl_Product].[Date_deCommissioned]))<>False) AND ((tbl_Product.[ID_Tool_Category])=4)); The control sources of the 3...

Hi arnelgp, the rowsource is set to a query based upon the value selected in combo 1.

Hi folks, hope someone can help me with this one because it's got me puzzled (no change there then). I have a form with a subform. The main form has two cascading comboboxes on it which work fine. I have created 3 textboxes bound to a table and the corresponding fields. What I would like to...

Evening Colin, many thanks for your help. I'm a bit busy for a day or two enjoying myself but I'll have a look at it this week. Is there any annotation on the code? I would simply like to learn which bit does what. Thanks once again, Lol

Thanks for the code, I understand so little of it it's not funny. To clarify though, what I am looking to do is open the file explorer window to show the root folder for a particular file, not to open any documents specifically. Many thanks, Lol

Hi all, not had a lot to do with Excel since the early 90's so please bear with me. I have a spreadsheet with assorted data, one column of which could be used to hold file paths. Is there a way to open the file explorer window with the correct folders in it by selecting a particular cell in...

Hi Paul I misunderstood your post, I was so frazzled as to why the "should work" wouldn't! It was actually looking towards the Tbl_Location_Type and wondering if it was connected when I fell across the FK problem. Bit aggravating but at least it got sorted :D

Solved it. The reason was I had assigned the incorrect value to a variable to be entered into the FK link field between Tbl_Current_Location and Tbl_Location_Type. One of the values being submitted was 4 and the range was 1-3, hence a Primary Key violation, not in Tbl_Current_Location but in...

Hi Paul, just done a dummy run and here is the debug.print for both strings, they are showing the exact same values for ID_Product: INSERT INTO Tbl_Inspection (Date_Inspection, Date_InspectionDue, ID_Product) VALUES (#09/04/2018#,#09/04/2018#,53); INSERT INTO Tbl_Current_Location (Date_Loaned...

Further investigation reveals it is the code for strSQL2 that is causing the problems, if run in isolation strSQL1 works fine. is it because the child table to Tbl_Product is Tbl_Current_Location that strSQL1 works but strSQL2 doesn't? Do I need to change the relationship before running strSQL2?

I ran the string queries nd despite the date going back to front they wrote just fine so I don't understand this Primary key violation problem.

Interestingly 9/4/18 is going in the table as 4/9/18 which is most infuriating!

I tried printing the strings to the immediate window and got these results: INSERT INTO Tbl_Inspection (Date_Inspection, Date_InspectionDue, ID_Product) VALUES (#09/04/2018#,#09/04/2018#,50); INSERT INTO Tbl_Current_Location (Date_Loaned, ID_Location_Type, Comments, User, ID_Product) VALUES...

It worked and actually wrote to the tables?

Hi, I'm having some problems with a form and getting data into some tables. I have a form, some of whose controls are bound, some are not, because I couldn't figure how to get a from to accept data entry so I opted for some vba and sql statements. Okay, so what I'm trying to do is write to 3...

Thanks for the link.