Search results

I have a table that contains many inspection records for part numbers. I need to create a report that will display all the inspection records in columunar format. At the moment report is displaying all the records horizontally. Any ideas? Many thanks Gerry

Yes I am very much an amateur with access and have no experience with coding :confused:. I am trying to find out in simple terms (for a simple mind ) how I can do the following: In table i have a field (data type yes/no) named "pcb". In main form I have the same field - How do I have a sub...

Hi: This is the last step on 1st phase of a database which I have been asked to do. Basically its a form used for incoming inspection dealing with three main category type of materials: pcb, metal and other. In the main form (general_rev2) the field material category has a list value of the...

I have imported into my database the browsing form and all seems to work on until I try to copy the VBA code into another form where I want the browse option. I get the message to view in design view (which I am) or change "HasModule Property = true". I cannot see the HasModule" field or...

How do I insert a browse button in form design so that a user (data entry) can place a hyperlink to a report on a fileserver.

Can you advise how to have a form call on another subform. For example drop down list contains three values, fastfood, supermarkets and restaurants. If user chooses fastfood category it is required that a new subform is displayed containg (for example KFC, McDonalds and SuperMacs. Can anyone...

I have three material categories on a drop down (value list) on a form. Based on whichever category is chosen I want a sub form to open which will have criteria specific for the chosen category. For example if user picks circuit board category a new sub form with specific items for that category...

I have a form in a database that is currently in development. The form will be used for basic data input. As bugs/issues are discovered the form will be up-revd each time (form name). Is there a way to have the cuurently opneed form name displayed in the form header section similar to the...

Hi. I have been bashing around wuith this for some time now but seem to be hitting a wall. I have a database containing several tables. In the table named vendor_list there are fields vendor_nr and vendor_name - I have created a form named general_rev2 - in the form I have added a text box which...

Hi: I am relatively new to access and need to design a form. Have layout complete but now need to bring in a formula currently used in excel. Basically the formula will return a value under certain given criteria. Formula states: =IF(B4<8,5,IF(B4<50,8,IF(B4<90,13,IF(B4<150,20,32)))) Used...

Hello: I have a form designed that needs a distinct number for each record entered. I am using autonumber but need to set it in 7 numeric digit form (eg 0000001, 0000002, 0000003 etc). Can anybody help? Many thanks.