Search results for query: *

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

Thanks - that did the trick.

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

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?

lupins46: Thank you for the information. Based on my further readings, it appears that creating replicas in Access was never intended for forms, queries, reports, etc. It was only intended for the BE. I think will try splitting my database, mainting the BE on the server, and converting the...

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