Recent content by NKA

Hi there, Excel data is linked each month into Access. Fields are: [Dept_ID] - Text [Department] - Text [Emp_No] - Text [Emp_Name] - Text [Days] - Number Currently these are appended to a master table. Fields are: [Dept_ID] - Text [Department] - Text [Emp_No] - Text [Emp_Name] - Text...

Can anyone help me please? I have been running a report (company sick) for several months but have been manually changing the fields to suit the current month! I would like to set the report up ONCE and then have some code which will dynamically change the fields on the report. Eg. In...

I don't know how to explain this in simple terms - but I will try... I run a report monthly based on data received in Excel. There are several queries, all of which do the same thing every month, but I need to change a field to recognise the newest month. Is there any way, either in queries...

Thanks Frink, Yes, you are kind of on the right track. I have had all sorts of problems trying to convert the data type, but will try your code. The looping through bizzo is exactly what I couldn't get my head round. Thank you so much - will keep you posted on progress! Cheers NKA The...

Hi Frink, The records show exactly the same, with the activity field reading something different - like "iginition on" and "ignition off". This is why I am struggling to get the answers as the date/time is all in the one field - regardless of activity. Would it be easier if I emailed you the...

Not sure if this is any use. If not, let me have an email address to send it to. VEHICLE ACTIVITY DATETIME ONSITE LOCATION ABC 123 Ignition On 16/08/2004 7:27 0d 14h:35m James St, Claudelands, Hamilton City, Waikato, New Zealand ABC 123 Timed Update 16/08/2004 7:32 Howell Ave...

The table is a CSV file imported into Access 97. The fields are: [vehicle] text [activity] text [datetime] date/time (ie: 16/08/04 2:35:00 p.m. [onsitetime] text (ie: 0d 14h:35m [location] text The table is a raw data dump from the GPS system NKA The answer's always easy - if you know it! ;-)

Hi. I am hoping someone will understand what I am looking for below. I have a linked table with GPS tracking data for vehicles. I need to produce a bar graph which shows the total time (calculated from last ignition off - first ignition on) divided into productive and non-productive time. I...

Hi. Wondered if anyone can help me. I have a feeling I need the "Do While..." To give the overall picture, I have a table which contains GPS tracking data. I need to be able to work out how long the vehicle was stopped at all the locations visited so I can create a bar graph showing...

Thanks Roy! It's working a dream now. NKA The answer's always easy - if you know it! ;-)

It's me again... I am trying to put some sort of validation on the form now and want a message box to appear if nothing is selected from the listbox. This is the code I have at the moment (which is positioned after the SQL has looked at the records selected - think it could be in the wrong...

Roy! You absolute beauty! Works a treat - star for you! (So much hair loss is not good for my image I can tell ya!) Cheers NKA The answer's always easy - if you know it! ;-)

I have added the line DoCmd.OpenReport "RPT_StockMovement", acViewPreview before this code 'run query based on selected item(s) in list box Dim ctlList Dim sSql As String Dim Lmnt As Variant Set ctlList = Me.LST_Location '**************************** sSql = "select * from...

Hi matethreat, Does this work for multiple selections in a Listbox? You mention combo box - that is only singular selection. I am about 75% there - just gotta work out how to open the damned report with the multiple selections!! Thanks for your post. NKA The answer's always easy - if you...

Still confused! This is the code I picked up from the FAQ's (adapted for my table/queries/forms etc) and put it in the On Click of my button. 'run query based on selected item(s) in list box Dim ctlList Dim sSql As String Set ctlList = Me.LST_Location '**************************** sSql =...