Recent content by wotamelon

But do these data (column 2, 3, 4) gets stored in a table when its displayed? What I want to do is... I select 'SYDNEY' then '2000' comes up and 'NSW' comes up. However '2000' and 'NSW' data gets stored in POSTCODE and STATE in Tbl_SUBURB. Thanks...

Hello, thanks for reading this. I have a database full of postcodes, suburbs, and states (tlb_SUBURBS). They all correspond with one another. On the main form (frm_MAIN), I need to create an automatic tab tab system, where i type in first letter of the suburb, then its relavent post codes...

I figured it out lol, I just followed the wizard

Hi All! I'm looking for a way to find records quickly. How do I find a record based on a COMMAND button? The scenerio is that I'm looking at a product filling form, and theres a field where I select the CustomerID. Based on the customerID can I create a command button so that the button will...

thx man! quick n easy

Any codes for 'ALWAYS MAXIMISED FORM' on opening? =)

I'll just post back my solution to my problem. I downloaded doPDF from http://download.cnet.com/doPDF-Free-PDF-Converter/3000-18497_4-10648880.html?tag=mncol and it worked as a printer driver, so everytime i click print i select 'doPDF' as my printer source and it comes out as PDF file! sweet...

i get what ur saying now

but then when i generate the report, it's all coming up as the same invoice number. the invoice number textbox is in my PAGE HEADER in REPORT

this is the function in my txtbox ="TAX INVOICE #M1" & (Nz(DMax("INV","InvoiceNumber")+1)) It's currently sitting in my txtbox in my report. The report is generated based on query (criteria is that I enter first name and last name of customer) but when i gen the report, it's always with the...

nono, i am looking for a customise autonumber to create a continous invoice number flow

Ok, I don't understand the ''Criteria'' DMax ( expression, domain, [criteria] ) I've got expression and domain. what's the criteria referring to? and why is it a number and what for?

YAY! ur a champ, always helpful

How do I create an invoice number? Let's just say I would to have it in this format... ''M100000'' Im scratchingmy brains out on this one I want it showing on the report

Is there a function for auto number? eg. Current time: =Now() How abt one for auto number?