Recent content by bobmac-

I should have remembered this. I'm using SQL INSERT so I have to make sure the date part of the string is in americain format. Problem solved

Hi, I have a date value being taken from an android tablet which had it stored in a CSV file. The CSV file is opened with EXCEL and saved as an XLSX file. When I use VBA to read in the value to an ACCESS table the month & day is reversed. What is the easiest way to fix this in VBA? Cheers

Hi, I tried to use the command line and it did begin executing Python. However, when I pasted the string it only displayed part of the string then printed a Python traceback. The traceback showed 'list index out of range'. This is what I would expect if the script is expecting more argumants...

Hi, I'm using the SHELL function to command execute a Python script but I get the following error whenever the total length of the Arguments is too big. 'data area passed to a system call is too small' I've looked at the parameters for the function but there doesn't seem anything to suit...

Thanks. Is there a way to hide duplicates in queries though?

Hi, I have a report where there is usually duplicate data for the first of seven columns. If I turn Hide Duplicates to 'no' in the text box properties then the export to Excel is fine. When I put 'yes' the excel display is missing data at seemingly random places. Any idea what may cause this...

Hi Alan I have just worked a way around it. First I created summary queries for each field i.e. count of applications received, processed, accepted and confirmed Second, I created a UNION of all four summary queries to get a date field for all possible months I then created another query using...

Thanks Alan, I'm still confused on how to handle the rows. If I just use app_date_received as a row it will give me all the unique dates available which is not what I need. I need a monthly summary of how many applications have a app_date_received in that month

Hi, I have a table: app_id app_date_received app_date_processed app_date_accepted app_date_confirmed I need to produce a report giving the following: Number of applications (app_id) received by month Number of applications (app_id) processed by month Number of applications (app_id)...

Hi, I've linked to an Oracle table that has a date/time field of format dd.mm.yyyy hh:mm as Text. When I display the table in Access, the Times that Australian Eastern Standard Time (AEST) apply have one hour removed i.e. 21:30 instead of 22:30. Does ACCESS 2010 do a conversion of some...

Hi, I'm trying to access a pdf file. I get the following; run-time error '429' ActiveX component can't create object The code Dim gAvDoc As AcroAVDoc Dim strPath As String Dim strSrTxt As String Dim AcroApp As CAcroApp Dim AVDoc As CAcroAVDoc Dim PDDoc As...

Thanks Bob Worked like a charm, although I did change it to interior.colorIndex Cheers

Thanks Bob, I was trying to do the formatting in Access but couldn't get the Range object to work properly. I was fully qualifying the Set Range using the current worksheet but on some executions the Select at the end of the Range statement didn't select causing an error on the...

Thanks, much appreciated. I consider this issue closed As for early and late binding, I need to do some reading on it Cheers

Thanks for the reply How do I, in Access, set the trused access to visual basic project in Excel? Also, how does dimensioning the excel instance as Object change what I'm trying to do? Cheers and many thanks Bob