Search results

I am building a db for a small fire department. On the "participation" table there are fields for the year, rescues, fires, total calls, and a few more for trainings and meetings. The idea that I need to meet is a list box with all years that the employee has been there and the amount of calls...

Hey David! I sent a form not long ago for the first time. What I did to save confidentiality was copy the part of my db that I need viewed. Paste it in a db1 (or any dummy name) database. Compress it through the database utilities first and then zip it. I hope this might work for you, as it did...

Thanks IMO I am a little uncertain about the fact that the table that I want to pull them from has an ID num already set. I want to set new ones in the new table. Will there be any interference? Thanks so much for your help. I'm learning alot by doing, but sometimes it makes a body nervous to...

I am building a database for a local fire department. I have created the Employees form. The disk that was sent to me of the attempted database by an employee at the fire department hold photographs of all of the employees. I want to extract the OLE object to put into this form. These are part...

Thank you for your willingness to help. I will try to work with the compatibility modes this weekend. I am swamped with a programming contest and two design projects, so I will work with it within a couple of days. It might work. Maybe someone else that has Access 2000 will decide to take a...

Thanks In Chernobyl Pond I like the idea of checking for certain values too! The project is for a college. I gave the information to my partner (who is also one of the main users) to let her decide. I will submit this as well. I appreciate you sharing with me>:) :)

Here it is. I zipped the folder with db1, which holds the Employees form. If you need more info I can send a copy of the table. I have Access 2000, however XP has a compatibilty mode that should work. I have never converted or manipulated Office versions. Hope it opens OK. Thanks for taking a...

WOW Thanks Fornation! I thought there might be a simple insert that I just had not seen yet! This is soo helpful. A lot of work to build a "Names" table at a college, but a persons gotta do whatever works, right? I know that the reply took effort and time and I really appreciate it. My partner...

I checked it out Thanks for the ideas. The pop up property is set to no. When the window is not maximized the buttons are missing, when the window is maximized the buttons are right under the access close, min. and restore buttons. I'm fighting with it some. I have tried resetting the...

Yes the screen is maximized. All of the fields fit on the screen this way. I am running Windows XP and Access 2000.

I have a form with properties set. The MinMax buttons and the Close button are left visible at this time. I have a Close command button on the form. The buttons in the top right corner are not showing. Does the command button have anything to do with this? There are over 25 fields on the form...

I am searching for syntax to implement the Proper function for names and words that have more than one capital letter. For instance McDonald, or Some City. I have looked in the help files and it only offers a basic syntax. If anyone can help it would be greatly appreciated. Thanks.

Just a thought I know that access has a feature that will enter todays date when you enter Today in a field. You may be able to enter <=Today() as a validation rule to enforce a date on or before todays date. The feature is listed in the access help file but not alot of information is offered...

Not sure if this would help--however In the systems that I am working on I have a switchboard that opens as the main page. When a selection for certain entries are made a parameter or password is asked for. This has kept the users in the pages that they need to be in, and not other places. I...

A couple of ideas One thing that as access users we need to keep in mind is the fact that forms do not hold data--tables hold data. The information that you are looking for is pulled from a query and placed where? That is where you need to call your lookup from. The DCount function is used to...

Thanks! I deleted the form and set all field through the record source instead of using a query. It filled everything fine. The drop down arrow is there, however, that is not such a bad idea after thinking about it. The employee id may be selected instead of assigned in this form. I had not...

I'm not exactly sure why the fields are not showing. I had a problem using the wizard on one form that I created once, so what I did was delete it. I recreated the form using the record sorce property option. Select the tables that you wish to use, full the fields onto the form, and it will...

I have a master table named Employees. I have a table for Employee Family Information. I want the autonumber for EmpID to auto fill the value of the EmpID field in the Employee Family Information form? When I wrote the Select Query it shows only AutoNumber. (As a list box) I would like for the...

Thanks I changed the source from the student table to the intent table and everything filled in after testing. The subform is prefilling like it should. On to the next challenge. Again-thanks! (Too many late night studies can hinder the obvious)

The project that I am working on includes an IntentGrad table and a StudentGrad table. The Intent table holds info for those "intending" to graduate, while the other holds info for those who WILL graduate. The student information on the Intent form is prefilled from the student table. I need...