Search results

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

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

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