Search results

In order to track down the problem, I actually copied each section into a new query, changed over to Design View, then played around with it. After fixing the problem, I then copied the sql back into the union query. Thanks again.

Success! That did the trick; I had to replace that in all of the sections though. After some investigating and playing around I discovered why/how this happened. Like I said, I created each part in Design View. Originally I had put "Discount" in the second line of the criteria instead of...

Sample_Lock is a true/false. In that case, it should be "0", right? I haven't had time to clean up & re-organize the code yet, once I do I'll let you know the results. Thanks.

I know this is a lot of info for the union query to pull, but it's for a continous form for users to easily find overdue programs, quickly read information about them, then open up a payment management form for any of the records.

Namlian, I didn't realize that so many of those paranthesis were actually clutter. Like I mentioned I had created each query individually using Design View (it's easier for me), tested it, then simply copied the sql into the Union query. I'll try to clean it up more and see what happens...

And I just played with it some more and found more out. I changed a "ZM" record that was paid and "Full Price" to "Discount". Now it also shows up in the query, even though it's still recorded as Paid. So apparently the problem is the "Discount" part throughout the entire query. The thing...

Okay, so after looking at things some more, I found that part of the issue is with the Cost_Category="Discount". The two "WE" are the only two records that are Discounts. I changed one to "Full Price" in the table, re-ran the Union query, and only one the one that is still "Discount" came up...

[Solved] Select query doesn't work in union query I created a rather lengthy union select query that works--except one section, which pulls records that should be ignored based on the criteria (whether a record labeled as "WE" is paid or unpaid). All other sections of the union...

I'll look into your suggestion, CJ, but I have a feeling that the report would be easier. Honestly the main reason I would prefer the Excel is in the past that's what we've used for that kind of thing and I want to limit the "what's this new thing" reaction of the Board of Directors & other...

What is the best way to customize the layout of query results? I'm working on creating a series of queries that will be merged into a union query as an annual report. I'm only part way through creating the actual queries and how they will all merge, but before continuing I want to know the...

Sigh... my backups seem to have the same issue. I guess it will remain a mystery. So long as my current solution works--and doesn't randomly stop working--I'm happy. Anyway, thanks for the help!

Khalid-- Thanks for the suggestion, but I already have about 35 forms (some with up to 5 subforms in each) that are already bound to tables. That's too much to redo. JHB-- Thanks for the help with that sample database. The code is very similar to the solution that I found in that other...

I think I found a solution: http://visualbasic.ittoolbox.com/groups/technical-functional/vb-access-l/ms-access-vba-for-close-form-and-dont-save-record-edits-3704643

And, besides, what's the point of having a command button that saves the design of the form? The general users won't need that--only the manager of the database design, who can save manually in Design view. And a save button will only confuse the end users.

And, yes, I know that Access will automatically save things but I want a way for the user to cancel mistakes. I may just scrap the whole thing and let people know that it automatically saves. What confuses me is how what I had used to work but no longer does. And I've been using the database...

Okay, I see what happened there. I created a text box, went to Form view, hit the buttons and they worked. But how can I create buttons that save, don't save or prompt for a save regarding the data? And how come what I had worked for the data before but not now? Here's an example of the VBA...

I forgot to mention that in the first database I tested that the warnings are set to true by running an update query. The standard warning came up as normal, so I can only assume that the warnings are properly set.

Okay, I thought that it was just the form, but now it seems to have affected the entire program. Yes, all of Access 2007 seems to be having this problem. I even created a tiny sample database with one form that has 3 buttons with macros--one set to an automatic save, one an automatic don't...

[Solved] Closing Command Button Won't Bring Up Prompt Okay, weird situation. In the past I've used command buttons with both VBA & Macros to bring up a prompt to save or discard changes to the current record then close the current form. For some reason, on just one single form that I just...

Found the solution! http://www.access-programmers.co.uk/forums/showthread.php?t=233270 Apparently putting quotes around 0 or paranthesis around the entire IIf statement makes Access see it as a string versus a number.