Search results

I think I am working more towards hard coding for now and the users that are allowed to access it will have the password. I hadn't considered this running over a network, but it is something I should consider. Do you have a sample of how the table would look if it is storing for several people...

Thanks. This is a capstone project for school so I have to follow naming conventions. I am working on getting this code to work. I will check back with questions. The first thing I am confused about is where is all this code going? Can I set it to have just one password that when the user...

On_Load event of the form when the user clicks the button?

I created a switchboard that allows the user to pull up a data entry form, a form that produces reports, and a form that allows the user to open table update forms. I want to put a password on the table update button so not everyone can get in to change the items in the tables. I am assuming...

Looks much better now. Thanks

I created a form that has buttons on it to access forms that are used to update tables. How do I get rid of the bar at the bottom to scroll to other records? I am looking for a clean look on this form and since it won't scroll to any other records I want to clean up the bottom. Idea's??

The table has data in it. I put the code DoCmd.RunCommand acCmdRecordsGoToNew in the onload event. When I created the Switchboard button to access the form for data entry I said to open the form in edit mode and not add mode and now it seems to work. So far.

Data Entry does say NO and put the code in the onload event DoCmd.RunCommand acCmdRecordsGoToNew and when I open the form to update the table it shows 1 and allows me to enter new data to the table, but still doesn't show any previous data. Any suggestions

Thanks works great. Produces exactly what I am looking for. I knew it was something simple.

I not sure what you mean. One area was for opening form for entering data into tables. The second button would open up a form that stores data for downtime, The third button would open a form that when you click on a certain button a particular report will open. The DoCMD sits in the ON OPEN...

I have a form that stores data in a table. When it stores data it is using the primary key as the source to save space. When I write a query for a report using this data I want it to show the value of the primary key and not the pk value. Does that make sense?? Any suggestions??

I am using a DoCmd.RunCommand acCmdRecordsGoToNew to open a form starting at the point where a user can enter new data, but when I put it on a switchboard it will only start on a new entry and won't let the user see any previous entries. How do I make it open for data entry but still be able...

Thanks for your help. I will look over the database and see what I need to do, then I will be back.

Any more good advice? I could really use it. :confused:

1. The foreman are in charge of more than one crew. 2. The crew only have one foreman at a time. 3. There are 2 lines. Line 1 has 11 Machine Center areas and line 2 has 10. The only difference is line 1 has backline, other than that they both have the same areas. 4. Yes. Each record is...

Here is a copy of the DB. Please anything will help at this point.

Do you have a second to show me the kind of query you are talking about. I can get a query that list all the choices in each box and I put the requery in the after_update, but it gives me all the choices and all I want is if they choose line 1 then only the machine centers for that line show up...

I am back. Sorry, but I still can't get this code to work for a cascading combo box. The tables are: tblLine = lineID (pk), lineName tblLineMach = lineID, machID (composite PK) tblMachCent = machID (pk), machName tblMachCat = machID, catID (compostite PK) tblCategory = catID (pk), catName The...

Could you put that in simpler terms. I eventually need it to produce 40 different reports. Each report will be produce from each button and will be shown in a bar graph showing most to least. They start with line then drill down into machine center, then drill down even further for the...

The only reason I was wondering is because it is for a project and it was suggested that I could use one query based on the specifications picked by clicking on a button with different criteria. Basically one query would be run by 41 different buttons with the one constant always being between...