Search results

hi there, thanks for reply. I have tried this but all i get is the message no invoice on file for account, then i have to manually enter the number ??

hi all, does somebody know the code to complete the following. when i enter the account number (accno) for a given customer the form will look up the last invoice number (invno) for this customer and if there is no current active invoice then it will create a new invoice number + 1 (dmax+1)...

Hi all, I have a list box on a form called "list4" on a form called "Main" On the main form is a command button that opens another form called "AddNewBooking" to add further records. This will not refresh/requery unless i close the main form and reopen it. I have tried me.list4.requery on...

solved it: just in case anybody gets the same problem this is waht i did on the form properties I set has module to NO and restarted the database then i reset to yes and added my event procedure back again...hey presto done!!!

this seems to be happening to only 1 of my many databases. i have this database to startup the form "main" in the access settings when i start the database to load as "none" then its ok i have now removed any events and macros from form "main", but still crashes so there seems to be a problem...

Hi all, 6 out of 10 times or so when i start access it crashes and i have to keep restarting until it eventually loads anybody got any suggestions! here is crash error: Problem signature: Problem Event Name: APPCRASH Application Name: MSACCESS.EXE Application Version: 14.0.4750.1000...

Hi all, Was wondering if somebody could answer this one. I have a form and want to create a popup form to enter customer contact name which will then be saved to the current records form names and fields MainFrm BookingNumber CollectContactFrm BooingNumber ContactName I have created a...

Hi all, Is there a way to have a small combo box, say about 2" wide then when selected this actually expands to say 5" wide Thanks Simon

hi there, yes many thanks this is a different form but all it was is that i forgot to add quote marks should have just looked at your post from yesterday many thanks simon

thanks guys

Hi all, i keep getting error with this button on click me.invoicenumber = dmax (invoicenumber,invoicedetails) +1 any body help

access 2003 version

please find attached if you read the form "read me " this will hopefully explain a little bit more thanks

Many thanks for your replys but there is still something slightly adrift Could I possibly send you a copy of the database of where I am at upto now this will show you more what i mean and you will get to what we are doing Thanks Simon

I am using this now in the afterupdate field of invoicedetails.customerid text field but still getting same message you must save first am i still doing something wrong i change the line invMax = Nz(DMax("InvoiceNumber", "activeinvoices", "CustomerID = '" & Me.CustomerID & "'"), 0) to...

disregard that last comment. sorry yes when a customer calls to make a booking and there are no active invoice ( already posted ) then this will create a new invoice but if there is an invoice waiting to be posted (active ) then this will simply add this booking to the current invoice? thanks

in the afterupdate event of the customerid box also tried the same in the combo box

i have now put in the afterupdate event of the customerid box

could be the problem! after the update event of the combo box??

now getting this runtime error to make changes to this field, first save the record.