Search results

G'day, I have a products table which contains products from 4 vendors. The records have the following fields "Vendor", "Vendor Part Number"," Description", "Unit" and "Price" I have indexed same by Vendor Part Number and Description. The vendor's describe the same product using different...

G'day, I want to produce some UPCa bar codes which require 11 digits of TEXT for the barcode function to work. I want the bar code to be made up of several fields Make 3 Chars (Text) (eg 021) Model 3 Chars (Text) (eg 103) Serial_Number 5 Characters (Numeric) (eg 00025) (I need to...

G'day, I hope someone can help me please. I have a list of appointments by employee, client, date and time. I would like to be able to print them much like an OUTLOOK formatted schedule. Has anyone got any pointers on where to look abou thow to do this? Please find attached the type of output...

Hi, I'm based on Australia so default date format on the PC is "DDMMYY" I want to record credit card expiry date for a customers credit card transaction in MM/YY format. Can this be done using a Date/Time field or do I need to use a text field? I have tried making the input mask MM/YY which...

Hi, As you can see from the number of posts I am rather new at this. I am building an estimating package. If you open the JOB PRICING form you will see a page showing Client and several subforms including ORDER, PRODUCTS and TIME QUOTED. As you can see it is very, very cramped. When you enter...

G'day, I have a form with a number of subforms. One is the Product subform which calls a ProductDescriptionSubform (PDSF) that searches a table which has over 30,000 product line items in it. The PDSF provides a means of searching by txt strings in the database. What I am trying to do is to...

I have 3 cascading forms. The first form selects the client, the second form selects the project and the 3rd is used for quoting parts used and time spent on the project. As the 3rd form is very busy I need to maximize same to get it on the screen. Did this without problems but now when I close...

I am building an estimating database for my son who is a plumber. We have 2 major suppliers of products but neither of them record the description the same way. e.g. One supplier may record a product as a "6MTR 20MM Cu Tube HD" Whilst the other records it as a "Copper Tube HD 6 Mtr X 20MM"...