Recent content by REDaughdril

  1. R

    Movement within a form

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

    Printing on front and back

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

    Open form from associated form

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

    Data from form and subform to another table

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

    Data from form and subform to another table

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

    Data from form and subform to another 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...
  7. R

    Microsoft Access can't find the macro '.'

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

    Linked Tab forms

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

    Update new table from form and subform

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

    Date format and auto number combo

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

    split/link/synchronize what the deal

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

    split/link/synchronize what the deal

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

    You can’t assign a value to this object

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

    go to field

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

    popup keypad

    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
Top Bottom