Search results

Thanks for the reply and sorry about the delay - I've moved so was without internet for a while. Your suggestion worked.

Hi All, I'm in desperate need of help as I've got myself stuck and can't see my way out for trying. I'm got this table in a db which tracks whether some training is due for a given person. In the table there are four columns; name & course (both as text), then "outstanding" and "refresher" -...

I always thought front end distribution was a bad idea for multiple users? That said, I've no idea how many users you would need before this became true. It has some vba in the form which is necessary in how it's set up. There no plan to upgrade as far as I'm aware and no SQLite server to...

Oh okay; what's the important bits people would need to know and I'll post them up... Thanks by the way!

darn! So I'll have to code something then to load the input data into the back end database. Any recommendations over which script to use?

Hi Can anyone tell me if it's possible to change a form I've got for my database into a HTML form? I toying with putting the data entry form on to my work's intranet site. I would need the form to load the data into the database on the server once the user submits it. Is this possible with...

The results table you suggested Gizmo is just like my original one when i first started, except yours logs numbers, were as mine had text instead due to how i set up the tables. Your excel walk through is excellent as well. It's pretty much a written description of my last 10 days or so. I'm...

Well my relationship table now looks different.

Thanks jdraw, will certainly have a look at those. I might need it as well as I'm starting to get the impression that what im asking is not possible.

Sorry, I didn't realise I wasn't being clear with my requests. Your reply Gizmo seems to be based on the original relationship table I attached. I've change it seen then hence the attachment of a sample table later on in the thread. As for the difficultly in interpreting my responses; I did...

Hi Gizmo, yes that is what I'm saying. Sorry I wasn't clear. The "results" table will already be completed and by finding the values, all the user will be doing is updating them. So I just need the form to display the values searched for in the staff, month and year comboboxes...

Is it a filter I should be looking at; Anyone?...

I've had another play and set up a practice file which I've attached. This should hopefully show more clearly what I'm after; I need the user to be able to select the Staff, Month and year in the form and then have the form display those particular results when the search button is clicked...

Thanks Uncle Gizmo - bit too above me at the moment though... :(

Sorry sneuberg, I don't see how that would be different to what I have? The measure names are the key ID in the measure table. I understand that it's not good practice to have tables that require repeat entries which is currently the case with the month, staff and measure being repeatedly used...

The measures are a bit of a red herring, as I do not their number being relevant. At the moment theirs sixteen of them. Next year it could be 13 or 21. They're just key indicators of performance. At the moment they're in the results table with a separate measures table just to ensure no measure...

The form has three combo boxes; two auto populate with the current month and year. The third is for the user to select the staff member. The rest of the form has 16 text boxes with labels specifying which measure each text box relates to. Ideally I want the text boxes to show the score achieved...

Hi Guys, Thanks for the replies; my internet has been down so apologizes for not getting back to you sooner. Here's the relationship table attached. From what I seen, I understand it's best practice to avoid repeating information in a table? I 'm unsure how best to layout this database other...

Lookup Values:SQL or dlookup? Hello Everyone, I'm new and wondering if i could get some advice? You'll have to bare with me though as I'm new to Access and don't know all the lingo yet... I've only been playing on it a month and only a chapter into my training manual. The issue I've got is...