Recent content by Slap

@Gasman @Pat Hartman @GaP42 Thank you all for your help. GaP42's solution has worked as expected and my form now works correctly having corrected the relationships in reverse :rolleyes: Thanks again, Tony

OK, I swapped those around, but I have not had any success in stopping the 'add new record' behaviour other than to trigger an error saying records did not exist in the parent table, but still not working as expected. To recap I want to use a combo box for data entry and pull the related FK...

Thanks Gasman, it was intentional that this form only allows data entry, I have a separate form for viewing/editing. Your new entry has spawned a new entry in the venues table (ID=5), likewise in the FishType, Photo and Angler tables, which is exactly what has been happening to me also. I...

I have created a database (attached) in which I am having an issue. In essence there are 4 types of forms - Switchboard from which to launch actions - data maintenance (frmAddAngler, frmAddFishType, frmAddPhoto & frmAddVenues) - view data (frmViewCatches) - add catch data (frmAddCatch) I am...

In warehousing you'll often see the term LPN (Licence Plate Number) which refers to a collection of goods stored together and intended to move together. In your instance there could be one or more per job/project. You'd relate the LPN to the physical location and also to the job and a list of...

Maybe try this in vba Call DoCmd.SelectObject(acTable, , True)

Show navigation bar

Should you be storing this? How do you handle a new restaurant popping up nearer to the address? Shouldn't you just always run the query?

Have you considered using power query in an excel file linked to the table with an auto refresh on open? Host the excel file on sharepoint.

Based on the OP last post this may not be solved, so here is my take: Sub groupShader() Dim shadeArray, currentShade, thisRow Dim criteriaCol As Double, startRow, endRow Dim dataArea 'below if only using alternate colouring 'shadeArray = Array(xlNone, 3) 'below for...

If the column names, not positions, are constant then a recordset based on sheet1$ where you use a sql select could work. Then read that recordset set in line by line in a loop to your table.

Don't poke the bear comes to mind

https://www.bbc.co.uk/news/uk-54422505 How are we reporting this type of detail via excel?

So to troubleshoot I would do the following: Insert line after: query = "SELECT * FROM StatusComments WHERE EquipSN =" & Forms![Update]!EquipSN & " ORDER BY CTimeStamp desc" New line: Debug.print query Insert breakpoint on line after debug.print and then step through the code using F8 in the...

query = "SELECT * FROM StatusComments WHERE EquipSN =" & Forms![Update]!EquipSN & " ORDER BY CTimeStamp desc" You need to break the sql and allow vba to parse the actual value of the form box.