Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: osjmgr
  • Content: Threads
  • Order by date
  1. osjmgr

    Error - You can't go to the specified record

    I know this question has been asked many times; however, I cannot find a solution that works for me. Background: I have a form that is based on a two-table query with two embedded subforms that are based on tables. This worked fine. However, I made several changes to my db and now when I...
  2. osjmgr

    Checking Values in Several Query Fields

    Hello: I am writing an expression in a query to check whether any of 5 Yes/No fields returns the value of Yes. I wrote the following nested IIF function, however, it returns an error: BPIssue: IIF([Field1]="Yes", "Yes"...
  3. osjmgr

    Help with TRIM function

    Hello: I have a field where the data has single quotation marks on each side of it (ex. '79-45-09'). I would like to trim the quotation marks off using an update query. I tried the following: (Trim(Left([AgentNo],1))) but it did not work. Any ideas?
  4. osjmgr

    Difficulties with creating Replicas

    I am trying to create a replica of my database so I can make changes to the Design Master while my users use the replica. However, after replicating, when I open the Design Master I get the following error message: "You tried to commit or rollback a transaction without first beginning a...

Part and Inventory Search

Back
Top