Search results

I am creating a database that is going to import excel files once a week. Most of the data will be the same every week, but some may change slightly or new records may be added. I need to create a query that will show all the changed/new records that are imported from the excel file. i would...

I have a command button on a form in access to run a query, everything works fine but when the query window opens it is to big on the screen (meaning i have to resize the window to see the scroll bar) how do you change the size of the window so that it stays the same size everytime you open it.

i am creating a DB for all the software installed on PC's i have a table that if a certain software is installed i would enter the version number, and if it is not installed then i would just leave it blank. How can i create a query that will disregard all the null fields (meaning that software...

I have a database that users log into to keep track of there work hours. At the bottom of the form i have a command button that will bring up a report of all the users hours. Is there anyway that i can have a command button that brings up the user's that is logged in hours. I was thinking...

Is there any way that you can have required fields in a form, but access will not look for the required fields until you try to exit the form. Basically; i have a form that users keep track of there work hours on specific parts. they leave the form minimized for most of the day. After they...

I have a table that shows all the company's PC's, and another table that shows all the software. I have a smart look up for a the PC's that when you click on it, it will show you all the software loaded to that machine. however, there is so much software loaded to these machines that when the...

rounding decimals I am trying to round decimals to either .5 or 0 right now i have it set to 1 decimal place and it rounds to to the next place. So if a user puts in 1.23 it would round to 1.2 instead of 1.0, is there a simple way to solve this issue?

I have a form that i only want certain users to have access to. Is there any way i can have them login with a user name and password just for this one specific form. I have a work group set-up on a test machine, but now it asks for a user name and password everytime i try to open any kind of...

i have a form and i am trying to have the date field retain the value that the user last put in. So when they go to the next record the previus date that they entered will be in there, so they don't have to keep re-entering it. As of right now i have it set that it puts in today's date...

I am currently working with a form that automatically puts today's date in the date field, which can be change if desired. However, I want to make it so user have to enter the date on there own, and after they create a record and start a new one I need it to retain the date that they entered...

I am working with a db in which users have to put in there initials in a text box. Right now i have it set to put in a list box anyone who has entered their initials in the past. I want to have it set up for when they open the form the list box has only certain initials (such as only the...