Search results

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?

thanks got it!

I understand that Microsoft do not have their own function in report to pdf conversion... however any 3rd party apps to recommend?

Hi all! this forum is very interactive I'm making a report that will show the gross earning of the business when keying in which dates you want. I'm okay in getting the criteria together, just when I try to get the grand total of the 'AMOUNT' (actual field name) then i get an error. In...

GOT IT! thank yOU again

My COmboSuburb is bound to my tblCustomer's SUBURB column, instead of storing suburbID, it stores it as the 'name of the suburb' (because I want the title to be displayed in the report instead of the suburbID... Im trying to understand your concept, but im afriad that my report will show up as...