Search results

Can you please give me your email address in a private message? I can email you some material to explain what I am after.

Happy guy I am. Thank you! Do you design databases for small businesses?

I run a small business. I started designing a couple of databases some time ago and never finished them. I am still using paper based system and sick of the paperwork. Can someone finish my half done databases for me? I am happy to pay a reasonable fee. I think someone who knows how to write vba...

Used your code and it is working. there was an extra ')' (as you said above) so it wasn't letting me save the query. That is why I had to modify it. Any idea why it creates invoice numbers backwards? for example it takes customer 1, customer 2, customer 3 & gives them invoice numbers 2010...

tblTemp only has two fields. 'InvoiceDate' and 'Description'. I change these two fields each month. (I created tblTemp as I didn't know how to append some unbound text ('Invoice Date' & 'Description') from a form to a table) in the append query. AccountActive and EnableRecurringInvoice are...

here is the append query INSERT INTO tblInvoices ( Customer, BillingAddress1, BillingAddress2, BillingAddress3, InvoiceDate, Description, Terms, PONo, BillingEmail1, BillingEmail2, TotalAmount, GST ) SELECT tblAccounts.CompanyName, tblAccounts.BillingAddress1, tblAccounts.BillingAddress2...

Trying a different solution. I put this expression in the append query & selected to apend it to 'InvoiceNo' field. Expr1: Nz(DMax("[InvoiceNo]","tblInvoices"),"Tables![tblInvoices]![InvoiceNo]")+1 This puts the same invoice number to all 30 invoices.

when I run the query, it adds 30 invoices to the invoices table. where does this code go?

Hi, I am looking to make an invoicing database. I create 30 invoices a month. each client gets billed the same amount each month (for example Customer A gets billed $100 every month, Customer B gets charged $200 each month). Only two things get changed on the invoice-'Description' (for example...

Thank you Pat. Trying to do it now.

Yes the tax is fixed 10%. The description is the same for each month e.g."I.T. services for January 2012" But I do need to store the total & tax amount so I can later modify the invoices later for tax free items. How do I do the following? Do you have any example that I can look up & try to do...

Hi, I am making an invoicing database, So far I have the following tables & fields. tblInvoices invoice no (autonumber,primary key) invoice date (date) Description (memo) amount (currency) tax (calculated field) total (calculated field) customerID (foreign key) tblJobs Job Id amount customer...

Problems Solved. Thank you thank you Thank you!

Thanks John That solves my one problem. How do i go about creating a new record and keep the same "ASSETID" ? e.g. when i click on "Maintenance" button on Assets form, it opens the maintenance form & shows only the maintenance records related to that particular asset that is open in assets...

Hi All, I have an asset db. (it is attached) - - Access 2003 File It has two forms 1) Assets 2) Maintenance I want to have a button on Asset Form which opens Maintenance form (i can do this myself) but how do i pass on "AssetID" to maintenance so i don't have to type it into Maintenance form...

Thank you Paul. The link is great. JOHN WHITE has explaied this very well in another forum. I would like to share it here as many people can benefit from it. ========================================================= Your tables should contain raw data without any lookups defined in the Table...

I have designed 2 databases. in both of them i had lookups (e.g to select Company name from combo box drop down) The thing is, in actual table it only saves reference number to the lookup NOT THE ACTUAL VALUE. (e.g. if i select Microsoft which is under Company combo box drop down, it saves...

Hi David, This database has attachment fields (data type) so i can not save it as mdb. But i will keep that in mind for future posts. Thanks!

I have 4 tables in my Asset manager database. 1) Desktop PCs 2) Monitors 3) Locations 4) Company the tables LOCATIONS & COMPANY are lookup tables for DESKTOP PCS & MONIOTORS TABLES. - see image and database attached Pls Note: I still need to make heaps of changes in the db. IS THERE ANYWAY I...

I am sorry. I knew i needed to add something, just couldn't remember it. Now i know. I AM USING ACCESS 2007.