Search results

For those who are wondering why this is marked as complete, I eventually just create a procedure to import the search data into local tables.

Have you changed your macro settings? I know your database is already in a trusted location, but this might help bypass the security message as well. http://www.ageesw.com/macro.htm

Ah, that is how you do that... I was originally going to do it that way but somehow I overlooked doing it that way while doing some trial-and-error. Thanks GinaWhipp!

Good morning everyone, Thanks (many thanks) to John Big Booty's post below, I was able to create a very user-friendly pop-up search form: http://www.access-programmers.co.uk/forums/showthread.php?t=188663 I would like to take it a step further... Now, I would like to grab the selected record...

Thanks for the tip, pbaldy! I was actually trying to do just that with the OpenForm statement within another database. That link will definitely be referenced a lot! :)

Good afternoon (for those in the Atlantic Time Zone), This is more of a curiosity, so if it's not possible it's not the end of the world... I was wondering how I could do a multiple value InputBox in VBA, if this is even possible... This is so I can prompt the end user to enter a range (with...

I have it right now and I'm still enjoying it, honestly. I can see why people are bashing it... but not to the degree which they are as well. It's a different MMO (and it obviously isn't going to be a carbon copy of Skyrim -.-) but it's still fun to play, imho.

I couldn't find exactly what you were mentioning, but I think you're on the right track :). There's something in Windows 7 (my mind first thought of indexing within Windows, but that didn't help) that hinders searching performance on my pop-up form within Access 2007 that doesn't exist in...

For some reason, it was having issues with parameters when executing (even after checking all the references and spelling :P), but I was able to mimic the SQL execution within an actual query and made it run with no hiccups. Regardless, thanks for all the help pr2! :D

In that case, what I'll be replacing is our company's model numbers based on a value in a control box so, from a data perspective, it would look more like the following: Replace("PD15-001", "PD15", "PD12") However, from a vba perspective, I was intending on doing something like this: Dim...

Good morning everyone! I've got an issue pertaining to inner joins within an update query. This query will not run now (giving the expected "must use an updateable query" error) due to two fields involved in one of the inner joins are now both memo fields. Is there any way (and I assume there...

Thanks Fran, do you know where I can find this in Windows 7?

Haha awesome, I'll wait and see what happens. Thanks for all the help though! :)

In addition, the search is being performed within the same pop-up form in both cases.

My apologies, it is the same front-end (back-end is linked to SQL Server) .accdb database being used on both the Windows XP and Windows 7 PCs.

I current have an Access 2007 database which one of our end users utilize faithfully. When he initiates a search in this Access 2007 database on a Windows XP Professional station, it returns the results almost instantaneously. However... this same search started in the same database on a Windows...

That's weird... does your Desire S have the Windows Phone 8/8.1 OS?

Anybody else looking forward to this epic MMO? I can't be the only one excited for release day (or early access if you pre-ordered)! :D. Let me know what you think!

I've personally boycotted COD as well, especially since I'm a full-blown PC gamer now. Battlefield 3 maxed out makes me wonder why I didn't make a custom gaming rig in the first place! Now that I've played Battlefield 4... I just can't go back to COD, I'll have a LAN party with it but that's...

Never mind, just had to move my code calling gemma's functions from my reports OnOpen event to the button itself on my Main Menu :3 Thanks again for all the help! :D