Recent content by Slap

Wonderful credentials... I'm no labour fan but this is bull...

@all you are missing/underplaying the Japanese culture. Mistakes are unacceptable historically so to accept a barcode scan is normal. If it's wrong then someone notices/confesses and the customer is compensated. Aside from your phone being snatched while unlocked (common in big cities in the...

Absolutely right, fingers crossed for the rodeo ride we have coming!

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