Search results

<SOLVED>Change a string to be able to use as a text box to access the properties Right i have been racking my brain on this im sure its something simple but im not getting it. on a form i have 14 text boxes named txtbay1 - 14. Now what i want the code to use the value in that Textbox to find a...

hi all im hoping that some one will be able to help me i have a text box that users will need to put values such as >5 <5 to filter through results problem is when i put >5 or <5 its not displaying anything this is the expression im ussing in the Query Like...

Hi all I have created a database in access 2016. now i also have access 2013 on my computer and when i open the database i experience no issues. but when my end user saves to their laptop they experience these issues when logging in will keep flashing with a box if flashes to quickly to...

hi all i have a query that criteria is linked to a form now i need the query to return all the results even if the criteria box is null this includes two date fields so this is the code i have but keeps throwing it back saying its too complicated or entered incorrectly Between...

So i have a text box called Description. this is the only text box in which they would add alphabetical characters. if they where to put an incorrect character such as a ' then i would stop the macros that sends the data to a table :/ i need a way of restricting such characters any ideas please

Hello i have this vba code that is supposed to resrtict access to users based on their access level what i have is a table that shows the access level and the forms they have access to and a tick box that says whether they have access to that form. now the problem im finding is that if i give...

Hello i have a form it has a combo box that allows you to choose between shifts then i have 12 text boxes that have a dlookup. the dlookups return the number of errors in a month from a query. i need the dlookups to refresh and display the new values when they choose a different shift. I AM...

what it originally wanted this macro to do is to record the date the user put but for some reason it would record a completely different date in the table for some reason it was putting a date from 1899. so instead im trying to get it to put the system date at the time of adding the record...

Hello everyone i am very new at using access. what I am trying to do is when i type in Someones User Id in this form i want 3 text boxes to auto populate with the users first name last name and shift from a table. if there is a easier way than dlookup please say so for one of the text boxes i...