Recent content by Locopete99

Hi, I have a table that records user queries for other departments. This has a Date/Time field in for "Date Raised". We changed it from a simple date to Date / Time so we could see what hours of the day were more productive.....We did not envisage being in a lock down with users working from...

Thanks Riti, Turns out it didnt like the string name

Hi Riti, Still not working for some reason. Yet for instance I have another one that is working: ID3 = DLookup("user", "tbl_User", "[CID]=" & Me![User]) Same basic format but one is working and one isnt and again bother CID and Me.User are number fields

Just in case it helps I've added screen grabs of both my tables in datasheet and design view

Hi Riti, Thats one of the variations I have tried, didn't work.

Thanks guys, I'm going to mark this as solved for now and have a chat to the user

Hi Guys, Can you look at the below and let me know why this isnt working? Other Dlookups of the same format are working but this one gets me a runtime error Course = DLookup("[Level]", "[Tbl_Level]", "[ID]=" & Me![Course]) So the field Im looking for is Level on Tbl level. The ID and...

To try and explain 1) The customer has a machine breakdown. They use my database to report the breakdown. Additionally they can attach photos to show the break. Yes they can attach more then 1 photo per record. 2) my typo - I want to download the photos to a certain folder not file. But using...

Hi, I'm using 2016 and I'm using the attachment field type. My user wants to be able to just click a button and download any attachments to a certain file instead of 5 - 6 photos per record. This is for a fault that the user on the factory floor is reporting, so adding hyperlink is not viable...

Hi, I have a form on which users can attach photos. This is required for the users to log pictures of machine faults. Is there a way to save these attachments using a VBA button? I'm new to form attachments so i have no idea where to start.

Also Thanks to Pbaldy, I've said that link now for future use!

Nope, ID2 is the text input field not one of my table fields, so pretty sure that wasn't it. Anyway, its solved now thanks to Jdraw

Thanks guys, I'd forgotten to put the right syntax as per jdraw

Hi Guys, Its been a long day so i might be being stupid. Can you open a form using the Docmd.openform command, but not use the PK index field? I have a machine table and a field that is Symbol on machine but I cannot get it to open: ID2 = InputBox("Enter Symbol or # on layout")...

Thanks! This seems to have solved it.