Search results

That's True, especially if your End-User gets cocky - and wants to print out on blue paper! :D

Have you tried putting a * in as a default for each option box? this way, if the box is not selected as part of the query - the * will pull all the records out instead of none?

Forms - SubForms Are you wanting to develop this program to handle purchase orders as well? Because getting the foundations sorted out at this stage will make it alot easier for developments in the future... I take it that the deliveries table is some form of goods' receiving from an order...

Now that i've mastered the ability to distinguish the difference between post new and post reply... i can apologise.. Sorry, mile.

If that doesn't work then i'd put your first idea into a public function that you can call upon to screen your figures whenever you want to... Public Sub Converter() (Put Your Equasion in here) End Sub ie. If value > "1,000,000" Then Call Converter Else End If Hope that Helps!

I think i know why he got the sack, at it didn't have anything to do with his programming skills...probably more to do with the fact that he couldn't speak english. :p

Isnt there a property you can set in design mode on the table? or are there figures which want to show as $12.00 as well? :confused: (EVILMAN - THIS WAS SUPPOSED TO BE A REPLY TO YOUR POST!)

Hmm... Hey Foster, Had a look at your tables to start with...it's a bit higgle de piggle de! If you've only got Material Description and Price then i suggest doing it like this... tblMaterials (the ma before each field lets you recognize it as a field from the materials table) maID...

Ugh! Hi & Thnx Again Chris! :rolleyes: I've been in disscusion with the main supervisor for those 'little darling users! Ugh...anyway, i managed to persuade her that although it does state in my job discription, my need to create such systems, i ain't a myrical worker and nor is access! I've...

Hi There, i'm also new to this forum - and newish to access (i'm more used to VB...) The way i got round this problem was to change the query for the combobox's recordsource...if you select the id (autonumber) and the name(text) -- sort name as ascending to get them a- z ... then... in the...

... Thnxs for the info CJ, That's pritty much what i did in the first layout of my form... i had a mainform containing all the customer information and under a machine heading, a subform linked through cuID which displayed all the computers associated with that customer. Everything was fine...

I'm currently working on a form, which contains quite a few subforms. It has been suggested (or should i say forcefully suggested) that I use tab controls for a certain subform. Here's the catch. I need to be able to add X number of tab's depending on the number of records retreived from a...