Search results

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.

Hi Guys, Can someone take a look at the below? I cant seem to get the export to work. It works as far as creating the directory and then stops. No error message or any issues but also there is no exported excel file in the folder! DirName = "B:\" & fOSUserName & "\Register Report\Outdebt\"...

Hi, The sub forms are not connected to the main form. The sub forms are just to display the results of the query. If you click them it enters the id number onto the main form. The table is updated by the "update" forms. The main form is just to display the data, so i dont want to add another...

Hi Guys, Need some help. I have attached a picture of a form I'm working on. The form has two query subforms embedded in it. The top subform shows things that have an action required date of <= today. The bottom has things that have a required action date of > today. Clicking on either of...

OK adding the height and width has got the main menu up, but now no buttons are working to open further forms. tried adding the height and width to all, but even my msgbox isn't popping up.

Hi, I'm having some issues using pop up forms and running them as minimised from a shortcut. My database has been developed using access in Office 365proplus on windows 10. My users are using it on a windows 7 virtual desktop, also using 365 I've set all forms to Pop up, I'm running it from...