Search results

Duh! Haven't had to use SQL in so long, I forgot about it. That worked perfectly. Thanks for the help, Brian!

In my query, I am looking to set the criteria by having the user pick 1 of 3 options, or a combination of those three options. Here's an example: The fields are Manager, Employee, Job Function. Let's also say that my criteria is David, John, Busy Work. I want to be able to pull results by...

They may work in up to four different areas throughout the day. By having it write to the same table, I was avoiding the extra queries. Probably not the best approach looking back on it... I do thank you for your help!

So let me ask. Would there be anything I could do other than splitting the database? Aside from just expecting this issue? Of course, I think I already know this answer

It is on a shared drive. Please don't tell me that's the issue...

Access 2007 I am currently working on a database that tracks what an individual does during the day. I have created a very simple form called frmOperatorLog that includes 4 subforms: fsubProduction1, fsubProduction2, fsubProduction3, and fsubProduction4. The main form doesn't write any data to...

Sure enough, it was set to no. Thanks for the help! Now to test...

I have DoCmd.GoToRecord , , acNewRec in my subforms. And I have no issues when I pull them up individually. The problem is when I load the main form, which include these two subforms. The subforms sometimes contain existing data. That is what I'm trying to avoid

I am working with a multi-user database in which a user will enter their data throughout an hour and submit the record before starting on the next hour. Each hourly form has two sub-forms within. These sub-forms have a "GoToRecord" macro that points them to a New record on load. I have noticed...

For anyone that runs across this scenario later down the road - I ended up creating 5 queries, one for each Combo/Text box combination. Then a simple union query and it worked fine. It's still probably not the cleanest idea but it works. Feel free to post any other alternate ways that could be...

So I have a form that has five drop downs with corresponding text fields. Each of the drop downs pull from the same row source and gives the user the option to pick between 50 separate tasks. The text field would house how many of that specific task they completed. Instead of making a subform...

I have an unbound text box that calculates a range of other text boxes. The unfortunate part is that if one of these text boxes are blank, the calculation doesn't work (correct me if I'm wrong). To get around this, I have defaulted each text box with a 0 and set the conditional format for this...

Thanks John, I'll check it out

I am trying to create a button that, when clicked, will open up a separate Form based on the username from Windows. I already have the code for my username Module and am not concerned about that piece of it. I just can't figure out the coding for the Button so that when I click on it, it will...

Makes since. So I simplified the WHERE clause and actually set my <= to a BETWEEN instead of >=. It worked! Where [Month Reporting] Between DateAdd("m", -14, Date()) And DateAdd("m", -1, Date()) This shouldn't cause issues down the road...I don't think

I actually need Sep through Sep. I do these reports at the beginning of each month and they focus on last months data. This is the only query that I need that shows a 13 month span

So below is my union query that I am having issues with. I am trying to get it to pull the last 13 months (Sep 2010 through Sep 2011) but am having some issues. When I set it to ("m", -13, ... it pulls August 2010 through August 2011. When I change it to -12, the query pulls the same date range...

I was definitely creating the circular in the union. Since my field was listed as 'Month Reporting', I simply put that in brackets to indicate one identifier Here's what the final union looks like...and it worked SELECT Format([Month Reporting],"mmmm yyyy") AS 'Month Reporting',[Portfolio]...

You are right. My stubbornness is coming out and I'm only seeing what I wanted to see. Never thinking about the space problem. I got it now. Just took a slap in the face to see it. Thanks again!

Thanks again for the response. I was able to catch the missed "BY" You stated, "Order By 'Month Reporting' is not the right syntax. Order By [Month Reporting] is the correct syntax.". I can't disagree with that. What I was mentioning was that the first line of each statement should read...