Access Database Help please

[josh.clare]

Hi all,

i have created a very basic access database that contains all the information i need for our jobs at work. a majority of the data is in 1 table.

All i need to do now is create some userfriendly forms to add/edit data in the tables.

i have uploaded my basic database here:
http://81.134.132.58/josh/Database7a1.zip

Can someone please help me in creating these forms, as you can see i have made several attempts but am struggling. i want to create forms for sections of the table if possible,

Thanks,
Josh

 

[josh.clare]

cheers trev!
it works now but if i have three records with the same company, it only displays the 1st one.

 

[Trevor G]

Ok what about having a form with a combo and then select it then it opens another form which uses the values from the combo so you have a filter in place, this can be achieved via a query or a form using a table set of data but not showing the data in the form, and you can then use the command wizard to open a form with criteria.

What I have done is created a simple database with company names and a field which shows a count (I have added the text manually) then I have created 2 forms, the form which opens when you open the database is called search in the search form I have added a combo box and button and a hidden text box, the form is set to use the table data and the text box will hold the company name from the combo box, the command button will show the frmSelectCompanies which will only display the filtered list of companies. You can download this to work your way through it from my downloads page on my website. It is the first item in the list

http://www.wuit.co.uk/downloads.htm

 

[josh.clare]

Hey Trevor,

me again, have been working on my database and seem to be making good progress,
i am currently creating a form for a table but i want the form to be filtered. In the table i have a destroy/return field, i want this form to only display records with destroy selected. can you please help?

thanks,
Josh

 

[Trevor G]

Perhaps a quick option would be to open the form in design view, select the properties then in the record source select the elipses button to open the SQL builder, then select all your fields and for the field which holds the destroy/return field place in the criteria for destoy, change the view in the query window and if you only see the records with destroy you have your solution.

 

[josh.clare]

Hey Trevor,

i think i am doing it correct but am getting "Data type mismatch in criteria expression."

The destroy/return field is a lookup (which i have been told not to use) but do not know any alternative or reason why not to use them.

Any ideas?

Thanks,
Josh

 

[Trevor G]

If its a lookup field do you mean you have created either a table or field that provides a list and does it have an ID field associated to your list? If so then you might have to refer to the number rather than text.

 

[josh.clare]

hey trevor,

worked a treat, thank you mate,

Josh

 

[Trevor G]

Pleased to have pointed you in the right direction Josh.

 

[josh.clare]

Hey Trev,

sorry to keep bothering you, i am near the finishing stages of my access database and am just tidying and completing a few things.

I have a few forms with fields that i want to be locked unless another field/tickbox is filled out.

Can you please help?

cheers,
Josh

 

[josh.clare]

here is what i have so far
http://81.134.132.58/josh/sample.zip