Search results

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...

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...

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

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?

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...

Hi =) I don't know much about VBA codes so how should I go about doing this? In my form I wish to enter my suburb followed by its postcode/zipcode. Thing is a particular suburb has its particular postcode.... so to save time is there a way so that i can type in my [Suburb] then TAB to the...

Is there a way to adjust properties setting on a text box so that it will display more information? This is a one to many relationship. So for instances... On the report i have one customer (TOM) owning 2 CARS. On the TagNo. or Reg.No text box it will only show up the first CAR, but no info on...

[RESOLVED] Missing databse window HELP Hi all, This is the most nervous question I will ask... Problem: When I hold down the shift key to open my database (ACCESS 2000), the access program itself opens, but the database doesn't open. With this database, I've created a desktop shortcut to a...

Hi all, thx for taking time to read this. Problem: All the detail supplied to the report is based on query. The query displays results based on customer first name and last name based on parameter prompts It's not displaying all the data, even when i hit show all... (Customer details, job...

ERROR in combo box, Scenario: when creating combo box with wizard, forgot to select the primary key as well. i.e. 2 columns: primary key (auto no.), products So when the combo box is bound to a field list, the end text shown on the table ends up as the auto no. (NOT the title of the...

Hi all, I am troubled by this problem, I'm new to ACCESS (last time i touched base on VBA codes was 5 or 6 yrs ago where I took Microsoft Visual Basics for beginners) Please help! My workplace was to develop a search and traceable system for their customers and job orders, I've put in...

Hi all, I am troubled by this problem, I'm new to ACCESS (last time i touched base on VBA codes was 5 or 6 yrs ago where I took Microsoft Visual Basics for beginners) Please help! My workplace was to develop a search and traceable system for their customers and job orders, I've put in...