Search results

Thanks June7 for the reply. 'change manually' means they click on the status field in the form and change Out to In. I could delete the field from the form but they need to see what the status is in some cases. I hoped I could code something to check these fields but I think I'll just give...

The DB tracks stored pallets and calculates monthly storage charges. I have a button to change status to In and delete out date, but users regularly change the status manually and don't delete the out date. This only has to be done if an incorrect pallet is dispatched and then returned. Was...

Hello, I have a form that includes fields "Status" and "Date Out". "Status" is either IN or OUT and "Date Out" contains a DATE. I want the form to check that if the "Status" is set to IN that the 'Date Out" field is blank. If the "Date Out" field is not blank a message should pop up to...

Thanks for the info galaxiom. I was considering changing the $ values to just numbers so will go ahead and do that. Will also look into removing spaces in names

Hi everyone, I'm fairly new to Access, am stuck and hope someone can help me out. I have a query named "stock" that includes the fields "Pallet Type" and "Rate". I also have a table named "Pallet Types" (images of both are attached). I want to create another field in the "stock" query that...

Hey there everyone, I'm a relative new comer to Access and am really enjoying getting to know how it all works. I've managed to build a system for a friend who runs a storage company and have used this forum as a guest many times along the way. The system is in use but I'm constantly trying to...