Search results

Search for articles on SPLASH SCREENS. Theywill give you some ideas!!

Thanks Len and Jemma for your suggestions. Both of the my primary Vendors do have product groupings but as in the case of the product descriptions the groupings do not match nor cover the same group of products. I get monthly feeds from them of the product description, part number and price...

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 Mark, Thanks for your reply as well. That's exactly what I did after the lead I got from RuralGuy. But thanks for your help it is always appreciated especially as it's free and prompt! Avagoodweekend!

Hi Rural Guy, Many thanks for your prompt reply. It worked a treat. Thanks mate!:D

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 Alex, Found the simplest way of getting this was to add a crosstab to get number of weeks a song was in the charts and the positions it occupied in the top 40. I then exported same to Excel and used the 'MEDIAN' Function to calulate same for each song. If you thumb through the worksheets in...

Try TOOLS, OPTIONS, GENERAL and you will see same on the right hand side of the form. ;)

Your have formating problems. This works for me in a query so modify yours to resemble same with the sqare ([) brackets. SELECT [Combined Data].Description FROM [Combined Data] WHERE ((([Combined Data].Description) Like "*PVC*")); :)

VB & VBA reference book Tmarsh, Try VB & VBA in a Nutshell: The Language Author: Paul Lomax Publisher: O'Reilly ISBN 1-56592-358-8 I have found it very useful. Try Amazon, Border or the like US $24.95 Cheers mate,

Rusty, Firstly the left most column is actually referenced as Column(0) not Column(1) Also try changing field to "=cboActivity area.Column(1)" Cheers Bob

Pat, Many thanks!! Bob.

DCX693: Thanks mate for the suggestion. I'll give it a whirl. I hope weather is warming up in Brooklyn for the Easter Break. It was bonza here in Adelaide.

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 Wayne, I have been sidetracked on other issues. Thanks for the feedback and suggestions. I'll see how I go with the Modal - POPUP forms. I have spoken to one of the senior Analysts at work and he indicated that your suggestion is the most frequently adopted. Now I'll try to read up on Popup...

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

Wayne and Bert, You blokes are fantastic. Thanks for all the hard work. I had tried this beforehand but had the wrong syntax when trying to populate from the parent form. I am finding it hard sometimes to see if I should apply the code to a Field in the form using ON_FOCUS event , or the...

Hi Wayne, Thanks for looking at my problem. It's probably best if you look at the JPEG Ipreviously submitted. The screen/form with the Merchant group on it allows me to filter the records by Merchant and also the 3 fields "Find record containing", "And" and "And" end up doing a text string...

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