Search results

Here it is: If you want to try using the database first, go to "Vendor Invoicing", "Add New". The first field is SETR, this is the project number I was talking about. The combobox is currently populated with records from tblSETRs that have the "Active" checkbox checked. Type in 5J474 or 5J486...

Yep. Also tried me.requery; tried a bunch of macros; tried opening the query in datasheet view, then closing it; tried taking off the required entry property, tabbing to the next control, then going back. I don't know what else to try...

Hi all, I've been searching for a couple hours, and I can't seem to find the answer to my problem on any number of forums. I will start by explaining it... I have a combo box on an invoicing form that is populated by a select query that lists records of active projects (by project number - a...

Well... I got it to work... by creating a separate update query. Turns out that the query I used to find un-billed invoices for each project was based on two other queries... I guess there were just to many layers of queries for this code to work? Anyways, this new update query I am using is...

Sorry... no, it's not working properly. I get the runtime error when I try. I don't think access likes me trying to update a parameter query. Maybe it is also because the other criteria for the query is that TMC Invoice is null? Yes, it is the same popup box prompting for the project number...

Hmm... Well, it stopped asking to Enter Parameter - qryNewTMC.TMC, but it is still asking for the project number when I click the command button. Could this be because it is a parameter query, and that when i try to use the Update function, it needs to re-ask the parameter? I tried...

Oh, I probably am... Report Name: rptNewTMC Query Name: qryNewTMC SQL Statement: SELECT qryInvoiceDetails.ID, qryInvoiceDetails.[SETR ID], qryInvoiceDetails.[Reference File], qryInvoiceDetails.[TMC Invoice], qryInvoiceDetails.[Date Paid], qryInvoiceDetails.[Invoice ID (File #)]...

I tried to change the name of the field, and it asked if i wanted to overwrite changes another user made? What does this mean? Is it easier to use the brackets? if so, how would I go about it? Around the whole string, or just the field name?

When I open the report, it prompts for the project number (this criteria applies to the query that the report is based on) Once I hit ok after entering the project number, another prompt pops up asking for the TMC Invoice # (this is supplied by the user, set up by the text box's control source...

I can't seem to put a button on the report... and it just keeps screwing up when I tried putting the code in the OnClose field. It keeps prompting me to enter the Project Number again, and then it pops up with another prompt for Reports!rptNewTMC!txtTMCinvoice, etc. I guess because there is no...

I'm going to try again right now!

That WAS fun! hahaha Ok, I think I have got it... except for one thing I hope you can clear up for me; when you say I'm not using brackets around a string where there should be brackets... is the string you refer to something like the query.field or reports!reportname!textbox?... so that they...

Got it to accept the code, but now it is prompting me for all these parameters, when it is supposed to just be taking the data from a text box and applying it to the records' corresponding field... Help?!?! Oh well, it's lunchtime now... Thanks in advance!

Didn't work. Runtime error... Hit debug, and it higlighted the whole line. I guess I will go back to trying to use a command button. I think part of the problem is, I originally designed this program following the standard naming procedures... frm pre-fix for forms, tbl for tables, etc. Then...

I tried, unsucessfully to put a command button on the report... so instead I went into the report's properties, and inserted the code in OnClose. I hope this will still work... I am about to try... Also, VB didnt like the _ between the ampersand and the textbox location, so I deleted it, and it...

Thank you very much! That is exactly what I need this thing to do... I will insert that code this afternoon, and let you know how it turns out.

Each project has many vendor invoices, which will be grouped into a TMC invoice. Each project may also have more than one TMC Invoice... I will post a sample db tomorrow, since it is officially quittin' time, and my brain is already at home on the couch with a cold beer. Cheers!

Ok... Let me back up a second here... When I want to generate the report, a query runs where the user defines the project number, AND where the internal invoice field values are blank. Then a user prompt pops up asking for a TMC Invoice Number (which is a unique, alpha-numeric designation...

It is a user defined parameter that is linked to a text box on the report... Control Source: = [TMC Invoice #] Then, once the report has been printed, we use a modified version of the vendor invoicing form to add this TMC Invoice number to each applicable record. So, yes... it is manually...

I've done some searching, and haven't found any threads that match what I am attempting... I have a database that tracks expenses that are incurred under different ongoing projects. I currently have a report based on a query that asks the user for the project number, and shows all the expense...