Recent content by ScribeGuy

Solved. Of course you were all correct. The HW1 etc fields had no business being in that table. As soon as Cronk mentioned the third table it all made sense. I used to know this, in fact I’ve done it before on this same database. Problem is, like many, I only get ten minutes at a time to...

thanks Cronk, I'm starting to get it now.

I see now what you mean about structural problem. I think I need a many-many relationship in my tables. Not too experienced with that but I'll look into it.

I have attached a sample database. There are 3 tables Cabinets Hardware Orders This is how I have it structured at the moment. If this is incorrect please let me know. That said, I need to write a query on the Orders table that will list for me the various hardware items and their...

Thanks for the response. Not sure how I could structure it any differently, perhaps you can help. Cabinets are in one Table Hardware in another table Each cabinet uses different combinations of the items in the Hardware table but no two cabinets use the same combination. Some cabinets...

I have a table of Cabinets. Each cabinet has 20 fields for Hardware (HW1, HW2 etc) and 20 for Hardware Quantity (HW1Qty, HW2Qty etc) Not all fields are populated. Hardware is entered as an ID number eg "Hinge" = 620 and "Handle" = 750 So say there are 3 Cabinets in a Job Order Cab1...

Hi, running Access 2007. I have a report which lists and totals job orders. When opened in Print Preview all is correct, but when opened in Report View everything is there EXCEPT any calculated fields - they are blank. If you go on to print, or print to PDF the totals are there. I...

Hey thanks ChrisO. I had tried that method originally but got errors unless I used the full path name. However in veiwing your code I see where I went wrong. I had neglected to put the dot (.) before each control after the With statement. Thanks.

simple question yet I cannot find an example anywhere that works for me.. I want to refer to the following nested subform with a variable: Forms!frmMain!frmMainSub1.Form!MainSub2.Form (Sub2 lives inside Sub1, which lives inside Main) my first thought was: Dim strMainSub2 As String...

I had same problem. It's timers. I'm no expert but I'm suspicious of timers. I only use one becuase I want current time on the user's dashboard. Is there a better way to add current 'real' time to a form? You'd think it would be an easy no-brain add-in for Access - like the pop-up calendar.

Hi Vassago, I got that it was a joke (lol - see?) but actually did you know there are penguins in Australia as well as Antarctica? My return joke was that 'penguin' is about the only thing I haven't been called ('selfish bastard' comes up a lot though)!

Been called many things, but never penguin. Joinery as in cabinet making - we do furniture and counters for stores, banks etc

Excellent. Thanks JBB.

Hi everyone, I have searched and searched forums but so far have found nothing on this problem: I have a search query that filters the search based on several fields from a form. The user chooses from combo boxes and whatever they choose goes in the query. The problem comes if the user...

Hi from Australia everyone, Currently developing a large inventory, ordering and job management db for a joinery company. This is only my second db and my first in Access 2007. I originally learned to code with the old BASIC (remember line numbers?) but a lot of time has passed since then...