Search results

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...

this is my understanding - each "record" you have is made up of fields. Each field is allocated a space by Access everytime you create a new record. Even if nothing is entered into the field is is allocated the space determined by how many chars you have allowed for it or the field type. eg -...

Well, the server it is on its slow. also - the system runs a load of activitys. The Q up these activities i use the a union all querey across 5 different tables, each table has about 10 fields but 10K records. In one office it is Ok and only takes about 5 seconds, in the other office were the...

Question - splitting a database up. I have a case management system built in access. it services 8 teams, each team has 10 people. Its working ok and has about 10K records a month I am managaing the back end with weekly Compacts and even with 20K records its about 90meg. The main query (...

pretty much on the autoexec ( asssuing you have one ) get it to name your log ion field with whatever value your FOSUSER returns. then, on the log in page, just lock the user field and have a box ready for password. you will need to use the SETVALUE command in the autoexec macro somat...

its a common problem - 2010 saves features into DB which are not available on older vserions. Therefore, 2010 will not let you save older versions. the only option you have is to get 2010 on your laptop and to your clients. you may have to revert to a previous 03 version, export the data from...