Recent content by SanHall

  1. S

    Change Navigation Selector Default

    Is there a way to change the Access 2000 default for navigation buttons. They are so small my users can hardly see them at the bottom of my form. Not everyone using my forms have great monitors. Is there a way to change the way it looks, such as font and size ?? I don't really want to create...
  2. S

    Syntax Error in code I wrote

    Can someone tell me what is wrong with this statement. I get an error message stating Run Time erro 3134 Syntax error in statement. Not sure what to do. Can anyone help?? DoCmd.RunSQL "INSERT INTO [tblProductionInformation]![cur] VALUES Forms![frmProductionEntry]![cur]);"
  3. S

    Forms- storing a field based on a query

    Tried your suggestion about creating the code both in the exit and onlost focus and I am having problems. I am getting an error asking to define variable. Not sure what this means.
  4. S

    Forms- storing a field based on a query

    Hi, just wondering if anyone can help. I am so glad I acciddently stumbled into this forum.Since my knowledge on Access is basic to moderate and have taught myself most of what I know, this forum is very useful. I have created a form based on a table and part of the fields in this form are...
  5. S

    Queries - New at this stuff

    my tables are pretty much set up that way with an entry form for filling in the details. I have a table that lists all the presses and one table to store all the data that has been entered. The only thing not working and I can't get to work is the running total field. Because of my...
  6. S

    Queries - New at this stuff

    Let me be more specific. I have a form that plant operators enter the amount of parts produced by a press. All they do is enter the parts produced number, the next field gives them a running total and a third field subtracts that running total from another value. It is the calculation of the...
  7. S

    Queries - New at this stuff

    I know it is bad to store a calculated field, but in my case I have to. I have a field in a form that is connected to a query. I need the calculation stored to the underlying table each time the query is run. When I try to use the controlsource solution from microsoft Q109704, it does not...
Top Bottom