Search results

Is this not possible to do?

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...

Thanks i actually thought about that approach, but at this point i really don't want to go with it. Thanks for the example though, i may just have to use it if i can't figure this out. Basically, i want to have it so i can bring up any given pc and all the software/hardware loaded to it, also...

Thanks i actually thought about that approach, but at this point i really don't want to go with it. Thanks for the example though, i may just have to use it if i can't figure this out. Basically, i want to have it so i can bring up any given pc and all the software/hardware loaded to it, also...

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 tried that and it still did not retain the last date entered for the new record.

ok i just found out i was asking the wrong question. When i open the form from a different pc, all of my startup settings are gone. Such as hiding the tables window and alsdo the form doesn't open up automatically. Does anyone know where the file that stores those settings is located at so i...

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...

Yes, the primary key is the number of the record

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 was looking at a few things and i saw that you can some how have three initials field matched to what they log in with. I already have set permissions and users for the db i'm just kind of confused as to how you could get the initials field matched with there logg-in name.

I'll take a look. Thanks alot for your help

That would be great if only i knew how to do that. If you know please let me know.

Kind of, but not really. I want them to have select from a set of initials, lets say out of 20. After they select their initials they will not have to select them again unless they close out of access. Basically, at the end of the week users have to fill out this form as to what work they did...