Search results

That's good to know about the Order By expression. However your code produces a circular reference error, possibly because of the "AS [Month Reporting]" statement as opposed to "AS 'Month Reporting'". Regardless, using the code below with AS 'Month Reporting', I still receive the error stating...

I'm trying to ORDER BY the first column in my Union Query. The problem is that the first column is a formatted field. Everything I have tried produces errors. Below is a sample of what I have. I have tried Order By: Format([Month Reporting],"mmmm yyyy") AS 'Month Reporting' Syntax Error...

Worked perfectly. Thanks for the help!

Here is a quick excerpt from a union query I am working on. I need to pull the data only for last month based off of the 'Month Reporting'. I am sure that it's a Where statement but I don't know exactly how to word it. Is it easier than what I am making it out to be? SELECT Format([Month...

"On Error Resume Next" worked. Thanks! Actually, I do. I currently have it set up to where they can add/submit new data to the table prior to entering it in the combo box but nothing after. Now since I have the error fixed, it would be nice to simply have a button that could be pressed to...

On one of my forms, I simply have one combo box that will update another combo box based on information in a table. However, there will be times that the information being entered will not be on the table as it is not a reoccurring item. How do I stop these instances from causing a debug error...

I knew it had to be something more simple than what I was making it out to be. Thanks to all!

I have added a tab control to my form and currently have 3 pages in the following order: Transaction, Case, Customer. Is there a way to default to the "Case" page when I open the form without losing the page order?

Thanks pbaldy, you were right! Though I am now completely embarrassed, I had them backwards. For all interested, the code would be: DoCmd.OpenForm "DAS_Edit", acNormal, ,"[DAS_Edit] = " & Me.[Searchbox] Not: DoCmd.OpenForm "DAS_Edit", acNormal, ,"[Searchbox] = " & Me.[DAS_Edit]

My form, frmDAS, is used to enter a Control Number along with many other fields. Once entered, it is routed through a query that populates a separate form, frmDAS_Edit, for the user to go in and modify the data if need be. I have a search box on the frmDAS_Edit that will filter the information...

You're right. Why I didn't think of doing the calculations at the end, who knows? Thinking about it, I don't need that data to populate on the form but on the final report. I went in and through together a quick expressions query and lo and behold, it worked. Thanks again for the input!

Thanks for the input jzwp22. In most cases, you are right, there isn't a need to store this value in a table but I need it for this one due to reporting purposes. I tried your suggestion but it doesn't seem to update the End Date field. I still think your expression is correct, I just have to...

Well, sort of. So here's what I'm needing to do: In my database, I have a "Time_Frame" table that houses 3 abbreviations along with each of their corresponding time frames (45, 30, 15 days). This table is used for a combo box on the form entitled "Results". What I am wanting to do is while...

Ah, you may be right on the subquery. Going to play around with this idea for a while and see what I come up with. Thanks for the info!

So I have a very simply table: Column1 is 'Name", Column2 is "Sales", Column3 is "Month" I am needing to run a query that will only show the differences month over month for each of the names. As an example, the table shows: David 5 January David 6 February David 7 March When running a...

Yup. I originally wanted this to be an advisory message but you may be right. With the question in the message box, it would be best to go with the before update as opposed to after update. Thanks again!

Pbaldy, That link helped me more than you could imagine. I was simply missing a few words in my script. I ended up using the After Update event and it all seems to work well. And though I feel like an idiot for missing this, I am posting the results for anyone that reads this and is...

I have a bound combo box that has the numbers 0 through 9 as the options. These numbers are pulled from a table and are associated with other fields (though this is not important). What I am trying to get done is have a pop up box indicating "Are you sure?" if the number 6, 7, 8, or 9 is chosen...

What am I missing? I am trying to populate options for one combo box based off of another. I have been reading through these threads to figure out what I am missing but can't seem to get it. You will see that based on the "Action" combo box, I want the "Place" combo box to automatically populate...