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

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

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

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

I have a series of check boxes that once they are all checked, I need a field to say “Complete”. These are check boxes not option groups. Thanks

I have learned so much from all the help that this forums provides. How and were do I start so I can give some back not just receive? Again thanks for all the help.

I have a form that I use a combo box to pick a "department". When the department in no listed in the combo box I have a pop form to enter that department. My question is, how do I get my new "department" to be updated in the combo box so that I can select it. With out closing the form and...

I have a report based on a query that has [StartTime] and [EndTime]. I have a exp1 in my query ([EndTime]- [StartTime] that gives me my time worked for that entry. What I need, is that my report is divided by weeks from the date field and I need a total time “worked” by week and a grand total...