Search results

Paul, How does that work when the field I am trying to query off of (Closed Month), is in the format mm/dd/yyyy?

I am creating a report and I want the title to be "Sales Adjustments CURRENT MONTH". Is there a way to this easliy?

I have a query which I use to generate a report. I want to return all records where the Closed Date is in the Current Month. I know that I can setup a form where I put in the date range and use that to pull the records. But I want to know if there is a way to write a statement that says If...

Bob, One more question, what does the Chr(34) do in the code?

Thanks, I will give it a try and let you know how it works.

Bob, Thanks for you response. This code would go on the Run Report click button, correct?

I have a database where an administrator enters orders. For certain products, a warning pop-ups. Right now the user can open a Word doc of the warning, and I would like it to be populate with two fields from the Access Form they are using. I am getting a Comile error:Invalid qualifier...

I have a database where an administrator logs orders. Based on some of the orders that the user enters, certain warnings pop-up. I want to give the user an option to open a Word doc, which contains the same info, which the administrator can them print. I know how to do this. What I am...

I have a from where users pick from a list in a Combo Box which then generates a report. The user chooses either orders received before the monthly financial close or received after. The combo box is setup with a ROW SOURCE of BEFORE CLOSE;AFTER CLOSE. These are the values in the CLOSE...

I have spreadsheet where I have a column in a number format (###.#) I want to convert this to hours and minutes. For example, I want to display 138.2 as 2:18, or something very similar. Can anyone help me with this? Thanks.

I maintain a database that is used by approximately 15 users on my team. Most of them use it for look up, only a few for entry and running reports. My problem is that whenever I want to make changes (update forms, new reports, etc.) I have to find everyone who currnetly has the database...

Pbaldy, Thanks so much. I use the requery code and the sql statement and it works great. I will definitely be using this again.

OK, Not to sound dense, but where in the Combo Box properties would the second solution code reside?

Thanks, Your code for the second option can just go into the Row Source of the dependent Combo Box, correct?

I have a form where users can populate two combo box from drop down menus: Conflict Reason and Conflict Details. I want to make the choices available for the Conflict Details cb dependent upon the choice the user made in the Conflict Reason cb. I tried the follow SQL for the Row Source for...

I am trying to create a query which I am going to use to build a report. What I need to do is create a condition in the query where i want to return the records for one Table (RFQ Sent) where there are not a corresponding combination of two field (Supplier and Part) in a second table (RFQ...

I am writing a query where my WHERE statement has a combo box which contains two fields for the same table in it. How do I writre the WHERE statement to inclde two fields, I tried different thing but cannot get the first half of it to work: WHERE(field1 + field 2) = Forms!mainForm!cbSupplier...

Thanks, that looks like a good start to what I want to do. To write the SQL with multiple WHEREs, do I just say AND WHERE after the first one and second one and then end with the ";"

I have a report created which has three drop down boxes and a report of data below it. What I want to do is write a query where the user make their choices in the drop down lists, clicks a 'Run Query' button, and the data is displayed in the table of data beneath the drop downs. I know how to...

I have writted the code below to allow the user to use the arrow keys to navigate up and down a report. I also want the functionalily so if the user is at the first record and hits the up arrow key they will go to the bottom and vice versa. I know I need to write code that knows the record...