Search results

Try doing a search on working days and I am pretty certain when I did it a few months back I came up with some perfect illustrations. No point in reinventing the wheel!!

Hi I think you have some structure problems Your central table should be tblEmployees but you have got too much duplicating data. Why not consider keeping all the data relating to the employees in this table and then have another table called tblLetters where you store the employee number, a...

Add a field dtmRecAdded and set it to date format with the default value being Now() Every time a new record is added it will catch the date and time Hope this helps

OK If you have populated the table then the next thing to do is create a query to turn the numbers into something meaningful. Create a new query in design view. Add your three tables and link the fields from the junction table. Now drop down the fields you want into the query (double click or...

Cool Glad to have been of help

Hi Basically you need a linking table between your two tables. Assuming your PC table is something like lngPC as an autonumber field and strPC as a text description of the PC (e.g. Frank's laptop), and your software table is something like lngApp as an autonumber and strApp as a text description...

Hi Its not perhaps the neatest but if you set up a temporary table with simply the VolunteerID field (lngVolId) and set it to a key index (so there are no duplicates allowed). Lets call it tblTmpVolunteers Then put together two queries, one called qdelTv which is simply a delete query to clear...

Just a stab, but what are the property settings for the field in the table that you are appending TO? If it is not set as a date field then I do not think it would append the contents of the text box correctly. Might be wrong though!

Hi As long as the form is open you can get to the data in the textbox by using [Forms]![frmMyForm]![txtMyTextbox] Where frmMyForm and txtMyTextbox are changed to the names from your application. If you simply wanted to use the value you would put a textbox on the report and make its source =...

Hi Glad you got that bit sorted. I worry a bit about the time on calculations. Is your network fully optimised and your server running on a decent processor? The times seem to be extreme so I wonder if you should perhaps be looking at SQL server instead of Access for your BE perhaps...

Cool Good luck with the rest of it

Just a thought, but is one of the fields an autonumber? If trying to append back then you could have a problem. That said I am not sure I like your concept but you presumably have your reasons.

Hi I think someone has not given you quite the right formula since it does not make sense. If my start date was 01/01/2006 and my salary was £10,000 then according to your formula the prorated value would be 01/01/06 / 365 * 10000 Which patently is cobblers It may be you need to calculate the...

Yes. If I had tried that in my school I would have got detention for poor use of English. Sounds like the teacher needs a reality transplant. What a w**nker. Mind you I would have got detention for that too!

Thanks namliam I had not come across this but think it will do since my calculation should get it close enough to round to the integer or the half Thank you It gets tricky when you have to delve into aspects you haven't covered before but there is usually a solution! Thanks again Best wishes

Hi Max First of all would be a good idea to put an autonumber field in your table so that each entry has a unique reference. As to the query, what you need is a grouping query. Open up a new query and add the ID, date and cost fields, then click on the ∑ button. This will set each field to...

Hi I have a rounding problem that I cannot seem to hack through. 99% of the time the entry in a field (which has to be calculated) is either an integer or a precise half - i.e. 10 or 10.5 for instance. Occasionally the computation goes to 10.0001 or 10.49998 where the environment has...

Thanks John Worked a treat. That is what I call creative use of Access! Sorry I didn't find it in searching Best wishes

Hi I have set up a tabbed form to preview data going onto a report. There are four sub forms each on its own tab. I have locked down the data on the sub forms. However when I open up the tabbed form the focus seems to shift to the first control on the tab. Ideally I want all the data controls on...

Hi You also need, at the very least, a third transaction table to hold the data on who borrowed what video (and probably what date they borrowed it). Then simply use a form with combo boxes to populate this table. The next stage will be to identify what videos are out, so exclude them from the...