Search results

@theDBguy Ok, so I didn't start from scratch. I just did a copy and paste. Went back and created a copy from scratch. Didn't put all my code in, but it loaded a bit faster than what I received from IT. Still a bit slower than before though. What do you think might be going on?

@theDBguy I tried both approaches, the forms still load very slowly.

@theDBguy I made a quick form as you instructed. Seems to load a lot quicker than the existing forms.

@Minty Sql Server is remote. There's a mix, in that some forms load all data while others focus on a singular record. There's a mix on the comboboxes as well. Some forms have comboboxes, but I'm also having trouble with displaying just the datasheet portion of a split form. I have some vba...

I recently split a database that I have been working on into a sql backend and an Access front end. The split process was handled by my company's IT department. Prior to the split all forms, reports, queries, and tables loaded very quickly. However, since I received the database back from IT...

I think something has been corrupted. I went back to a previous version and the same code is working correctly. That is what was so perplexing about this issue is that this command had been functioning perfect for the last several months. It just started giving me problems yesterday. Thanks...

Still points to the open form command.

I added the spaces which makes the string more legible as suggested. As you can see it makes the string more legible, but I still get the same error. I don't get an error if I replace OR with AND, but obviously the sub doesn't work correctly. Is there something about the open form command...

I did as you guys suggested and received the same error. Here are the screenshots, they will probably be more helpful this time. Thanks for the help guys.

I copied and pasted into the sub routine as specified and I got a 3075 error, see attached

I tried both methods without any luck. The problem seems to be with the "OR" because if I substitute "AND" the statement works. Is there a rule against using "OR" in the where clause on the open form command? If so, is there a work around to this?

I am using the following code to open a form in my application. However, I am getting a 3075 error code. When I isolate the first portion of the Where clause the command works. Which leaves me wondering what I am doing incorrectly with the rest of the code. DoCmd.OpenForm "Commercial...

The DB is not split yet. We're still in the testing phase.

I have a user that is reporting they received the attached error from a data entry form. He claims that he began entering the record but became distracted by another matter. When he finally returned to the record the error was displayed. Additionally, he is claiming that his copy of the...

Actually @theDBguy was correct on what I was looking for. I was trying to make the field to be filtered on in the report variable. The suggestion worked. Thanks.

See attached picture. I have to set up a bunch of reports which will have some varying data fields. I will be using filter forms that allow the user to select what they want to view in the report. Once the desired information is selected the report is filtered via a where clause. My question...

That is definitely the problem then. As always, thanks for the help.

I think it does. Forgive my ignorance, but is there a rule that you have to interact with the main form before entering information in the subform?

Just go to the main form “commercial gas stats”, something like that I don’t have it open right now. Create a new record on the main form and try to select a value from the “entered by” combo box, first field top left, on the subform. As soon as you select the value the error message should...

@theDBguy, here is a dumbed down version of my database. I got the new record issue sorted. I think the problem with that occurred when I was playing around with the master/child links. The only problem left is the original error that I discussed above. Thank you for your help on this.