Search results for query: *

That's ok - I figured it out, I had the qdf.sql = strSQL below my Save function. Thanks!

Hi - I have multiple "Multi-Select" listboxes setup on an Access form. I am trying to get one listbox (SelectGLDept) to populate the next listbox (SelectHRDept), which has a query behind it (QryMenuHRDept)to populate the second list box. For example, the user chooses the GL Departments from the...

I would like to duplicate a record that also contains a subform. How can I do this?

The problem is that some of my calculations on the Report are too complex for the query. I've had this happen before in a query. So I am unable to duplicate what I did in the Report's calculated fields. Is there anyway to sort the field, without it being in the query or using the sorting and...

I couldn't do these calculations in the query, so they only exist in the report. Is there a way to sort the report in VB "On Format" when the report is opened?

How can I sort by a Calculated field on an Access Report? I have various fields from a query that I am using to created calculated values on a Report. I need to sort from these calculated values and can't figure it out. Any help would be appreciated. Thanks!

Could you explain a little bit more what you are trying to show in the field? Is [EmployeeID] the field name? If you are trying to use the Dlookup function, it should look something like this: DLookup("FieldName" , "TableName" , "Criteria = n") Not sure if you can grab it from a query, but you...

I figured it out - I used the report.hasdata=true function and it works perfectly. Thanks anyway!

Hello - I'm sure this is a simple problem, but I just can't seem to get it to work. I have a simple invoice report that I have put a subform into. I total the subform and then reference that total field on the main report. It works great when there is data, but if there is no data in the...

This is exactly what I am trying to do right now! And I forgot the "&" in my "Like" equation, so it wasn't working right. Thank YOU!

Just as VicRauch said, it gets confusing, because it is not reallly a drill down search. It's three items- Invoice, Vendor or date. Seems like you would have to have all three fields for a drill down search like this to work. If I had exactly what the customer wanted, I guess there would be no...

I need some advice on search filters/combo boxes design. What is the best way to search for multiple criteria in a list of data? I currently have a list of data in the detail section and on the header part of the form are three combo boxes that filter the data upon selecting data in the combo...

I have an issue that has stumped me. I have created a shipping database that's end result creates an Invoice. The Invoice is a Report that grabs data based upon the date and Vendors specified in a pop up form before the Report is opened. The Report uses calculations and a subform to figure out...

Go to the copy of your Report. In Design view, go to Properties and change the Query that you want to use under Record Source. You can either create on in Properties or use an existing one. Is this what you need?

In your Copy of the Report, go to the Report's Properties in Design view. Under Record Source, change the name of the Query that you want to assign to it.

I wish I could tell my client this! In fact, I may have to. After I have totally created the database with the "snapshot" data design in mind for a final invoice, he needs line by line values (that I created from complex calculations) exported from the database. Actually, I guess I could export...

How can I grab a calculated value from a report and paste the value into a table? If I can do this, where would I place the code and how would I reference it? Thank you!

Thanks for the suggestion, but it is still not working. Pretty much the same result.

I have some code that puts data from my Main form to my subform. Everything in the code is working great, however, I would like to put a clause in the code that says if my Subform fields already have data, to abort the whole code. When I put in the following code, nothing happens when I execute...

Ok, ignore the last post I made. I had to change the "integer" in the code to "Long" so that it would accept the higher number. It is working perfectly, now! Thanks so much for your extensive help - you have gotten me through a huge hurdle on my database!