Search results

I would like to be able to press a button and move to another section(field) in my form. Can this be done and what is the code. Thanks.

Two questions: I have a form that I need to press a button and print only the first form of the list of forms in the query. I also need to print the two page of the form on the front and back of the paper. Thanks always for the help.

I have a form "a letter" with associated data that I want to open with a button from my primary form. When I made the button I associate the data but it opens all the the forms and displays the first data entry. What am I doing wrong. Thanks

how about a better explaination Main form has a "Mission Number" Sub form has "Unit Number" New table would have the "Mission Number" and "Unit Number" I need to assign multi unit to each "Mission Number" Thanks

No, it is a separate table. Yes, it can just depends. I can, I just need the form and sub form to make a different table.

I have a form with a sub form. I would like to have a button that would combine the data from the sub form with data from the main form to another different table. I can do it but it just over writes the data. I know will be simple but I haven't figured it out. Like being unable to spell a...

I get this error message (Microsoft Access can't find the macro '.'). How do I get rid of this? Thanks

I have a tabbed form that the employee will choose a vehicle from a list of available units. By pressing a button I want it to jump to a different tabbed page that will have another form that is linked to unit on the button page so the employee and update the data. Thanks

I have a table called "tblMissions" and a table named "tblUnits" I have a form called frmMissions (to enter the different missions) and a subform called (frmUnits) for the unassigned units to choose from. I have button on the frmUnits subform to choose the unit which enters the mission...

I have a query that I want the Now() function in the year only format and in an expression combine with the auto number one extra field to get the following: date YYYY-------Autonumber---------color----------exp1: ---2007--------------23--------------green-------2007-23-green Thanks for...

How about this 1. split the db a. Main be on the network b. Make multi copies of fe for all the others including off network. 2. Make replica for the off network db from the be on the network drive. 3. Copy to offsite computer and Re link the off network db with the replica db. 4. Log on to the...

Ok, I’ve worked far too many hours to say and am now ready to put into action. I have some questions. I have multi uses that will use the db on our in-house network. So I plan to split the db. However I have other uses that must use the db that can not access the network. Here is my plan...

I have a form that has a field (MedicalRecordNumber) which is null. I have another cascade sub form that is linked to that field. When I add a new record I get the following error: You can’t assign a value to this object. The object may be a control on a read-only form. The object may be on...

I would like to move between all my fields in a form but when I get to the end I want to go back to the beginning and not open a new record. What happens is someone is tabbing and enters a new "duplicate" record. Can someone help? I entered a command button that pops up and stops them but I...

I would like to make a form that would pop up in a standard keypad format. This would allow me to enter the number and on close, it would place it in a chosen field. I saw the one that was is a previous thread and it does make sense to me. Thanks for the help

I have a form that has a related pop up from. I have an IF/Then/else statment. I want to up date a field in the orginal form from that if/then/else statement. I can get my IF/Then/Else statement to work on the subform but I can get it to update the orginal form. I might have a problem with my...

I have a form that I has a password field that matches the employee name. I want the employee to enter in a data field their password. If it matches I want another field (verified) (yes/no field) be marked as yes if it matches and no if does not. I did IFF([Text5]=[Password],[Verified],= -1...

I have two times I need to subtract in a query. When I subtract these in the query I get a decimal point. How can I convert this data. Thanks

Ya know, it's the little things that make you feel so stupid. It worked great. Thanks for the help.

I have a form that student grades on. I use a listbox to pick the names. I also have a pop up form for me to enter new students that are not in the pop up "query" form. I can go to my form with the grades and hit a refresh button and the listbox is updated. I would like for my data to be...