DB Asking for a parameter when used in a different computer.

[TrulyVisceral]

Ok, so in my computer I made the database in. It works great, no errors, the data displays properly, etc.
So I tried to run it on a different PC, to show how it works. When I tried to open the search form, it asked for a parameter for the search boxes, all of them.


Normally, this should happen:

And that's that. It just opens the search form.
Instead, when opened from a different computer, it asks for parameters for the search box for some reason, even though they're supposed to be empty on open, and it doesn't display the info on the list box. I don't know if it's because of the different access versions (mine's 2010, theirs is 2013 or 2016, it varies). At first I thought it didn't transfer the tables, but they're still there, and they're being read, at least by the graphs.

I might provide a screencap of the box that pops up, but I need to wait for the peeps to come back, not gonna start using their PCs just like that.

[isladogs]

Check for missing VBA references on the other PC

[TrulyVisceral]

Check for missing VBA references on the other PC

Still have to wait for them to come back. I'll get back to you on that.

[TrulyVisceral]

Whappam, there it is. BUT, their Access isn't activated, so I can't even check the code... gonna have to wait till tonight, see if the error happens in my home PC.

EDIT: I should probably specify that I tried it on yet another computer, same error. But I can't just go and use it because they need to work so... yeah, 'till tonight.

[TrulyVisceral]

Check for missing VBA references on the other PC

Ok, so I checked their references. Exactly the same, nothing's missing. The only differences are that I have Microsoft Access 14.0 Object library, they have 15.0 (guessing that's because their version is 2013) and my "Access database engine object" is 14 as well, theirs is 15.

No differences between the code either. I don't know what's happening.

[June7]

I run 2010 so might not be much help. If you provide db, perhaps someone else can. Follow instructions at bottom of my post.

[TrulyVisceral]

I run 2010 so won't be able to help. If you provide db, perhaps someone else can. Follow instructions at bottom of my post.

I COULD do that, however, there's some sensitive information there I'm not very sure my peers would be happy sharing. Regardless, if I just keep clicking OK on everything, the form opens and all the records are displayed properly. After all, all the things it keeps asking for parameters for are Unbound, they aren't linked to anything. Can I just make it NOT ask for parameters? I tried setting default values to "" but nothing.

NOTE: I'll try to empty the DB and put some dummy info in there, JIC I can't make it work.

EDIT: I didn't read the bottom of your post attentively. Sorry. Regardless, basically ALL the info in that DB is confidential. Gonna have to wipe it clean and put dummy info there. But oh boy does it have a lot fields.

[June7]

Why asking for parameters? Code on Open or Load or Current events? Dynamic parameterized query?

[TrulyVisceral]

Why asking for parameters? Code on Open or Load or Current events? Dynamic parameterized query?

The codes are for the buttons next to them, but all they do is refresh the query filtering whatever is in the boxes.
Some are combo boxes which refresh the list on update.
Nothing on open, load or current events.

As for query, well... This is for the list. (NOTE: "Como" = "Like")


Gotta go, won't reply for about an hour.

[June7]

I never use dynamic parameterized query. Review http://allenbrowne.com/ser-62.html

[TrulyVisceral]

I never use dynamic parameterized query. Review http://allenbrowne.com/ser-62.html

Is that what that is? That's what that type of personalized query is called?

[June7]

Yes it is. No idea why 2013/2016 would have issue with. Assuming other PCs set for same language. Posting your db may not be useful because most of us use English and if your code is not then we can't run it.

[Micron]

Isn't Formularios "Forms"? The query is looking for a value from a form, but the form isn't loaded? And that's because of code that didn't run on the other pc? And that's because it's a Trusted Locations issue? Just guessing.

As for posting sensitive data, you can always copy the db, strip out records and only leave enough to create the issue (assuming any are required for this problem) and Ctrl+H (find and replace) in sensitive tables and change your boss's name to Donald Duck (or something like that). If you're db is split DO NOT delete records from the back end while maintaining the same links. You will delete from the primary tables. If it's not split, then deleting from your copy should not cause any harm.

[June7]

I presume the query parameters reference the unbound textboxes on same form query is RecordSource for.

[TrulyVisceral]

GOT IT.
Yeah, it was the language. Which I found weird, because while I was working in spanish, everything auto translated from english to spanish. But since my supervisor's and my home laptop's versions are in english, it doesn't work backwards. Dunno why but oh well. All I had to do was change "Formularios" to "Forms" in the query.