Recent content by reddwarf

Seniority does not reflect knowledge. I always find the rule "make it first - then make it sound like their idea and you have a winner. " if you can show them how it easy it is without having to exlplain it has more chance of being used. I spend most of my time as a DB admin working on ways...

having a button to get external data isnt easy to be honest - you can do it though using http://www.access-programmers.co.uk/forums/archive/index.php/t-169481.html. that said, most of the time when i use the get data featyre i run into problems if a field isnt formatted corrcetly or is to big...

need to do this at home as we only have access 2003 here. will sort the weekend, let me know if you still need it ?

sorry - forgot you were trying to close other forms not the one your on. good call vbainet

eg : Dim frm as Form For icount = 1 To Forms.Count + 1 For Each frm In Forms If frm.Name <> "frmMainmenu" Then Me.Undo DoCmd.Close acForm, frm.Name End If Next frm Next icount

Me.Undo DoCmd.Close just paste that into a button code.

post your app if you want and ill make the changes.

have the operator field as OPERATORID on your main table - then - have this look up values from your OPERATORID table with all the details in. then - when they have Created a docket - just write the operator ID to record which is saved in the main table. make sense ? so - instead of a...

is the prioblem that your TIME isnt what you think it is ? Access and XL seem to convert these to TIMES in the day as opposed to length of time between two events. As far as i can tell - to average minutes then you would need to so this in a NUMBER format as minutes and have your queries/reports...

sounds simple - but with excel tables i prefer "" instead of null. So - it would be IIF([MyDate]="n/A" or [mydate]="Ignore this one", "",[MyDate]) mydate could be any field name ? now, i see your making a new table with a query - is there any reason you are not importing the data using...

seems simple but its DATE() or NOW() - you are bracketing both right ?

Hi - it is confusing hope this helps Basically We have 100 Employees who all take holiday – they also all work different hours days. For instance Darren works 20 pers week 5 hours Mon 5 hours Tues Doesn’t work Wednesday 5 hours Thursday 5 hours fri Sharon works 7 hours Mon 8 hours...

I am desgning a holiday tracker. basically, each team member has a numbers of hours worked per day ech team meber has different days they work - so it can look like this >: Darren - Monday 5 hours, Tursday 5 hours, Wednesday 0 hours, thursday 5 hours , friday 5 hours. the working patter...

I have a UNION query which looks at three tables. it pulls REF - ACTIVITY_NEEDED - DATE NEEDED - TEAM - OWNER and some other fields What i want ... if a REF has three acitivities it only shows the OLDEST ONE according to DATE NEEDED. is this possible ? any one got any ideas ...

seems simple but cant you just out put the report to an RTF document. My DB does this and it opens up in word. ( degfault for rtf files ). I do it like this : Add a button then add this code to button from the form. Dim strReport As String Dim strWhere As String MsgBox "Give a message...