Recent content by intern42

Wow, that was amazingly simple. I've never clicked on "New" before, I've always just clicked on "create new query in design view." Anyway, that worked beautifully. Thanks for saving me a ton of time and effort.

Thanks for the quick reply, but I don't see an option for "unmatched" anywhere in the wizard or design view. Could you be more specific, please?

I have two tables with identical fields. The newer table has 200+ additional records and I need to find out exactly which records are new. I know in PL/SQL you can do a minus query that looks like: SELECT * FROM NewTable MINUS SELECT * FROM OldTable; This doesn't seem to work in Access (I...

Hey, that worked! Thanks a ton!

I'm using a query to populate a combo box with three fields, one of which is a date/time field. I'm concatinating the three fields in the SQL statement so that all three will be visible in the combo box when selected. i.e. SELECT Table.field & " " & Table.field & " " & Table.field AS... I...

Looks like everyone's stumped on this one. I solved the problem by taking the easy/cheezy way out: I put a hidden text box on the form and dumped the desired value into the text box (.visible = false) Since the saved query CAN reference the textbox's value, problem solved. Not by any means...

Hmmm... I hadn't thought of directly coding the query in the module. Could I directly assign the result of the query to a variable if the query only returns one cell? Here's the way I'm doing it now, which would work if I could reference the selected list box value from the query: SELECT 1 AS...

Hey, I'm getting hung up on this and it's getting a little bit frustrating... I have a form with a list box (lstTookCourse) that is populated by a query. (the populating query works fine) The listbox has 3 columns, a personnelID (number field and an auto-number PK for the personnelID table), a...

I know that Now() returns the current date/time.

Can you reference a variable in a query? For instance, if I have an integer variable that is populated in a form's modual, can I have the form call a query that looks like: SELECT ... FROM ... WHERE ... = intVariable; Maybe [Forms]![Form name]![variable name]?

All my code is compiled and I have the db set to compact and repair on close. This problem hasn't resurfaced and I'm hoping that it was just a random incident. Thanks for the suggestions.

Quitting the db wasn't possible... The first time, I stopped Access by going into Task Manager and ending the task. When the error window came up again, I tried shutting the Database window. This caused the program to "hang up" and become unresposive. A Windows message came up informing me...

That is correct. The error window flickers, as if it closes then immediately opens again, yet it always remains.

I'm encountering a weird error in my Access db. While debugging a form, I added a couple of message boxes. Now, whenever I try to close an opened window, whether the window is a form that is "running," a table in design view, ANY window, I get the error message: "This action will reset the...

That would work, but I don't want the user to EVER have to navigate to anything. I am going to give the user a folder containing 2 .mde files: the front end and the back end. I'll probably make the back end a hidden file so that he doesn't ever click on it accidentally. However, if he...