Search results

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

Hi, Here's the sub The macro import is the 6th last line, commented out. I've scanned the net and I'm getting the impression it may be impossible or only possible by making Register changes. It may be that being able to code a security change into a new workbook is considered a nono...

Hi, I'm in MS ACCESS vba creating an instance of EXCEL. i.e automation The new EXCEL Workbook I create needs to have Macro to do some formating. The code: xlApp.VBE.activeVBproject.vbcomponents.Import xxx This should do it but I need to allow "Trusted Access to Visual Basic Project" to...

Hi, I have a query with a sub query, all based on one table (attached). The query is a record source for a listbox. Two things occur; Firstly, the query SQL below changes as indicated after trying to use it. Secondly the Form upon loading says the query doesn't exist. This is very...

Hi, I'm using the SQL below as a Row Source for a combobox. A sample of records from the relavant table is further below. The first 3 columns are Primary Key. When I display the row list for the combobox all seems well, but when I select an item in the list the Combobox is not updated. If...

Hi, I'm using the SQL below as a Row Source for a combobox. A sample of records from the relavant table is attached. The first 3 columns are Primary Key. The value I am attempting to appear only once is 'obj_value = 'Flumegate m" using 0;0;3cm for widths When I display the row list for the...