Search results

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...

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...

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...

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...

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...

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'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...

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 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 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?

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...

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...

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...

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...