Search results

How do I make a form invisible? Where are the visibility properties?

The main form links to these other forms. They are for administrative purposes. They allow the users to add additional vendors, commodities, employees, etc. I ended up setting the main form to load from the navigation bar and then hiding the navigation bar all together to work around hiding...

I just split my DB into a front end and a back end. I only want the users to have access to 2 forms in the DB because the form already has buttons that link to all other forms and reports needed. How do I customize the front end view so that they only see these 2 forms?

I added the button, changed the "On Click" expression to read: me.Due Date = Date me.requery When I try to save that, it says, "The expression you have entered contains invalid syntax. You have entered an operand without an operator."

So do I just disable the wizard, insert a blank command button and change the "On Click" option as you specified?

I have a form that contains 3 date entry fields. I want to associate a button with each date field so that the users can click the button and populate the current date. I tried to create a command manually and change the "On Click" option to populate the date, but I'm not sure how to associate...

Thank you so much! :D

I am so appreciative of your help, but you are being too high level. I am a newbie so I need you to spell it out for me. How do you base a form on a query? Do I create a macro for this? I am looking at the Filter/Query/Search macro. Would Apply Filter do this? :confused:

I have a table with each status option listed by ID: The number is from the "ID" column and the status is from the "Status" column. 1=Uninspected 2=In Test 3=Rejected 6=On Hold 7=Released I want to create a script to only display a status with an ID of <7 so that my form will not display...

I like the idea of not moving them. It makes me feel better about the data not being lost in transfer. So you're saying I can archive the "Released" records somehow so that they won't appear on the form for the users to see? How can I hide them from the form once they have selected the...

I have a form that is used to enter test results for a lab. We track the status of each test and when the test is completed, the analyst selects the "Released" status from the list. I want the entire row of information (not just a field) for that test to then be transferred to a separate...

I am fairly new to Access. I took an online certification course for Access 2010 so I know the basics but I want to learn to design more sophisticated databases with user-friendly interface abilities. I hope you all can help! :D