Search results

  1. J

    Truncate last Character if its "/"

    I have a statement in an update query that I have gathering some data frm a table. I'd like to get the first 16 characters and if the last on is a "/" remove the "/" how is this done. Here is the statement: UPDATE ElecTrayFitting SET ElecTrayFitting.Name = Left([ElecTrayFitting.Name],16)...
  2. J

    OK Button

    I am trying to pass a return in a VBA program that is printing multiple reports. I have evertyhing automated except clicking the ok button. Anyone know how to do that?
  3. J

    New field

    I have a new field I havbe added to a table. How can I retroactively fill in the records automatically?
  4. J

    I am trying to compare tables

    I want an expression that will display data from fields only if they are different. Any suggestions? I have attached my database and the query is "A Query" Thanks....
  5. J

    Compare Data

    I have a database that gathers and coalates data from hundreds of individual databases. What I need to do is find a way to compare the data from one point in time to another. What I am going to do is initially run the coaliting database and name it Rev_A. Then at some point in the future we...
  6. J

    Multiple Table find

    I have a form that has multiple tables that git filled in. Is there a way to use a find button and find a record by searching multiple tables at one time?
  7. J

    Printing Default to 11x17

    Is there a way to have a report default to print 11x17?
  8. J

    SubForm w/ entire table in datasheet view???

    I need to show my entire table in datasheet view in a subform. Is this possible???
Back
Top Bottom