Recent content by dsellers1

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