Recent content by gpbuckley

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 John and thanks for the email. I am an amateur user for access and am not familiar with the above. Can you expand for me (in "access for dummy language" ? Thanks a million for the help

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

Hello Trevor G: Thanks for the help. I have attached the database in zip format. As you will see I am having problems with the forms "general_rev2"; "pcb" etc. Same message. I really appreciate the help. I have been given this project with the "sink or swim" understandfing!!

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

Thanks for that - at the risk of appearing like a total clutz could you show me the syntax as I am not having any success. The form name is "general_rev2" and this is what I need displayed.

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

Thanks a million - it works fine - You're a life saver!!!!

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

Thanks for the quick response and I will give it a shot. Cheers

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