Search results

I tried putting that in the on change and it is calling an event procedure. It gives me this: Compile error and it highlights .searchbox Should searchbox be what the box is named??? I don't do anything with VBA, Thanks for the patience. In addition to this, it is attempting to add new records...

I have a question and I don't know if it is even possible in a query or not. I have a form and on the form I have a spot for an Employee Number, I will have a table with nothing but Last,First and then Employee Number. My question is, is there a way that whenever I type their number in on...

Thats it. Thanks

I don't have any queries setup yet, and there are no records in it yet. Does this made any difference? On my forms i have setup before I have done it manually on the form and not used the form wizzard, which is what I done this time.

A spotter is a Multi-Gas Detector, Minning Industry.

Hello everyone, I am trying to get my main form up and going. I have everything on it the way I want it to appear. However nothing is appearing on the form other than the header when I try to view it. Any suggestions. I have not had this happen before. Thanks for the help.

Hello all, I am in the beginning of setting up a database and have NOT messed with multiple tables. I just want to make sure that I am setting up the tables as well as the relationships correctly. Here is what I currently have, 4 tables and they are named. Employee, phone, radio and spotter...

So it looks like a batch file is definately above what i know. I guess I will have to find aother way to back up my table. Thanks everyone.

Batch script?? Is that something in Access or something else? I'm using a company computer and I doubt they would let me do something outside my permissions. Thanks

Hi all, Had limited experience with queries, I am basically wanting to ensure that my backup database is as up to date as the one I am currently using in the event something happens with that file. What type of query do I use? I would think that I would use an update query as I would like to...

David, That is exactly what I want to do, being able to keep records of what equipment a person was issued and if that equipment didn't come back then I could "alert" whenever that equipment doesn't come back/ran over etc. In essence to keep a "running tally" of who is messing up. Doing...

Ok, I didn't know that. Thank you for the clarification. One other question I have. On my relationships between the tables do I want one-to-one or one-to-many? I know it probably matters what I want to do with it huh. Ex. John Doe (employee table) employee number 12 (employee table)was...

So in order for me to save information from the form I have to build a query? This might sound a bit remedial, but in a single table I was able to hit the drop down arrown in the control source and select where I wanted my information to go. Since I have 4 tables now do I have to go about it a...

Thank you for that, how did you get the information from the form to be saved in the corresponding table? I was having problems with that, on the drop down arrow under the control source it did not give me that option. Is that something that is handled thru the query or did you have to...

The form that I have there is just for input only, I have not set up anything beyond that yet, I was having some trouble getting the information from the form to being stored in the tables. I would just like to know how to get the tables setup correctly. I will use a report in order to filter...

In "drawing" my relationships I have went from ID on the employee table to ID in all the other tables. Like I said very new at multiple tables. I will attach the db and hopefully you can make some sense out of it. Ultimately what I am trying to get to is from my main form that everytime that...

Hi all, I'm having a little trouble setting up a new db in access 2010. I'm in the VERY EARLY BEGINNINGS of it and I think I know what the flow of it needs to be, however I've never dealt with multiple tables before so here is what I have. I have 4 tables and they are as follows: Employee...

Hello all, Just a quick question, what I am fixing to do is to setup an access d.b. and I am wondering what would be the best way to set up the initial page of it. I don't know if I should go with a form approach or a switchboard approach. I'm thinking a switchboard approach would be easier...

:confused:Hi everyone here is my problem I have 2 sheets in my excel file and I want to have a cell on sheet 2 equal a cell on sheet 1. I have done this several times before and I have limited success. Here is what I am getting On one column I am able to "copy" the information over with the...

Hi everyone, I have access 2010, I currently have a database in place and operational. What I am wondering is there a way to have a form come up whenever someone opens access and asks for a password and login name. Also I would like to have a 2 tier system. One for Admins and the other for...