Search results

I'm hoping someone can offer a bit of advice here. I admit I know nothing about coding but for some reason my boss decided 4 years ago that he wanted me to create an access database using records to keep all our client and worker records on, so that we could easily track who was available, what...

Hi I received some good help from this site back in the summer when i was landed with having to create a database for use at work. We have been using it with no trouble for a few months now but earlier today I noticed that when I used the filter by form option in the advanced part of the...

Hi there I'm hoping that someone can help me with this one. It's the first time I've had to create a database and I know zilch about coding so tried to do everything using the wizards within Access 2007 and a book from the library (some of the code from which wouldn't work when I tried to use...

Hi, I'm having to base an optional multi-parameter form on a query as the parameters come from two different tables and I'm getting problems with the construction of the SQL in the query. My co-workers and boss would want to search on any combination of 6 different fields but the results need to...

Most of the form seems to be working ok with the exception of the combobox for the PayingCompID on the third tab. I want it to be able to add extra payment companies when necessary to the list but each time I try selecting the limit to list edits property and altering it to no, I get an error...

Is it possible to use a word rather than a number as the primary key in a table which then becomes a foreign key when connected to a junction table? My reason for asking is that this would be a limited list of around 20 words and would be more meaningful to the end users if they were doing a search.

I know I'm going to have to change the fields in some of my tables so that the foreign key fields just show a number instead of a description after reading some of the posts against using look-up fields in tables on here. No problems with that. So now I'm hitting the problem of how do I get a...

In the attached database which I'm trying to build (try being the operative word!), I seem to have hit a problem with one of my forms. When I'm in the contact details form, go to the trades tab and try to find for example all the plumbers (there's only dummy data in there so far), using the...

I am just creating my first ever form and it needs to have two sub forms included in it because of the one to many relationships between the data. On the main form, do I need to have a field for the worker id as it would be automatically assigned and would I also be able to use the same form to...

Hi everyone, I'm trying to build up a database for work to replace the old multiple simple tables that we were using. The tables that I've now constructed are relational but I seem to have hit a snag with my very first query (see attached). The data I've entered into the various tables so far is...

Hi, I only joined this forum yesterday and I feel I've learned quite a bit already about relational tables, so now onto the forms. I've been trawling the web for quite a few hours today after discovering that I could use a form to do a filter from the advanced bit in the filters part of the...

Several months ago when I started a new job with a small recruitment firm, one of the things I did was to create a series of simple tables so that I had a record of who was registered, what they did and where they lived along with a few other things. At the time there were only a couple of us in...

Hi everybody, I'm very glad to have found this suite of fora (not sure if that's what they're supposed to be called or not) and I'm hoping that I'll be able to improve considerably on my very limited access knowledge. I did go shopping today and searched the nearest town's bookshop for a book...