Search results

What criteria would I need to apply in order to show the last 100 entries in a record set? Lets say I have a table NoteID - Autonumber Notes - Memo How would I go about displaying the last 100 NoteID's I'm sure there's a dmax or d something but I could not find it within the forums. Regards...

Its OK now After several cups of tea I have now awoken and fixed the relationship for query in sub form 2. Now it only show the relative Orderdetails number. Sorry for the hassle. Regards Ade

a little more I wondered if you could think of a way of setting focus to the corresponding orderdetails_counter in this case 81 sub 1 to 81 sub b this way if someone where to add say 1 and then go away into another sub and then come back to the original entry adding subsequent numbers would be...

This is a very simple one people but my brain has been fried over the las few hours. Please excuse the messy layout its just for working. See below Basically when moving into form one how would I move te record in form two to the current Orderdetails_counter? At the moment the record pointer...

Just wondered if viewers had any suggestions for this one? I'm tidying up my works booking in system and instead of a person having to manually open the sub / sub forms then I wondered if I could have a button on the top form for instance "ORDER COMPLETE" Then upon clicking this button table C...

Works with a bit of jiggery pockery (changed names and event details etc) I got it working. Like a charm Many thanks Ade

Many thanks LaBelette I will have a go and keep you posted. Regards Ade

input mask from combo Although I have not yet looked deeply into this scenario I'm asking to see if anyone had approached this before. What I need to do is change a text box input mask dependant on a user choosing a combo box. The reason being I would like to record delivery note numbers in...

Thanks Jason That was enough to enlighten my cabbage of a brain as to how’s of counting in queries. Many thanks I can now apply it in the real world. Cheers Ade

When creating a project for a job You can only have one job ID (sequencial pri key) say (1781) You can only have one Contract creation sheetID say (12) (sequencial pri key) within (1781) You can have many Contract update sheetID say (7) within (12) So basically instead of the >report reading...

Thanks but... Yes its something what I would like here is what I'm after. I may have over simplified the example I have the tables JobID -- Contract creation sheetID (sub of JobID) -- Contract update sheetID (can be many within contract creaation sheet). When I create a contract creation...

Thanks Pat Cheers Pat but I wondered if there was a little example you or someone else could post. Queries and expressions are certainly not my strong point. Many thanks Adrian

Counting same IDS Here is a question for all you query experts, Just say I have two tables Job number ID (Pri Key) Job Description etc Customer ID (Pri Key) (IS a sub of job number continues form) Name etc How would I count how many instances of customer id's occur under the specific job...

Thanks Unc I will have a look into it. I have been bashing away with this overtime situation all afternoon and after numerous if's and a bit of jiggery pokery it looks as if I have worked out how to calculate overtime over 8 hours and by day. And all from my head (No copying and modifying)...

Thanks very much Pat I have these in place now and all working very well I now have to put my thinking cap on and approach the overtime situation. For example Mon - Friday 8 - 4.30 flat rate Before 8 time and a half after 4.30 time and a half Sat am time and a half Sat pm double time Sun...

By the way Pat do you know of a way of testing for nulls in continuous forms? I have been searching the forums to no avail. I would like to make sure that a user has definitely put data within all required fields. yes I have ref.integrity and required fields set but is there a coding way? If...

Yes the combo is bound to a date/field row source shows a date/time but it does give me wacky figures when datadiff executes. I have changed it now anyway to a small button type interface creating a 00:00 to 23:30 style (in the main form) that applies the time to time in time out fields. I have...

I did it so the user could just select a time rather than type it in. The time entry is stored in the Timesheet sub table but provided from another time related table. Yes I could go for the tried and tested (myself) method and it works a treat. I just wished for the user to be able to select a...

I'm working on a rough sketching out of a timesheets DB and have the following problem. It seems that I'm getting wacky result from the datediff function. I have the following structure Main timesheet table Sub timesheet Time In table Time Out table I would just like fot the datediff to...

Anyone care to have a shot? Just wondered if there is anybody else out there with an idea for this one?. Wayne is probably on vacation ;) . Or I have just asked an arse of a question. Cheers Ade