Recent content by VegaLA

Thanks again guys for your advice! sxschech, your Second option seems like the best direction for me. I don't particularly want to touch the Excel file so that option looks like the best fit for me. I tried to code this myself but it placed the second export to another Tab in the same sheet. If...

Thanks PB. Yes, I did try that before but because they are different Datatypes, the forced Headers as Data from the Table being text and the real Data from the query containing numerical, Decimals and whatnot it would not work. Thanks, Vega.

Hi Mark. Yes, TransferSpreadsheet function does allow you to export the Field names with the Data. Problem I have is that the field names contain restricted Chars, in this case #. When it exports it changes ay...the field from Account# to Account. No big deal but it means I have to manually...

Thanks for the reply PB. Yes, I could change the field names in the query but then I'd be forced to change them back in the exported Excel file which is ideally what I would like to avoid doing. I am using Access 2013 so thought this issue may have had a workaround by now?

Good day all. Its been a while and what I thought would be a straight forwards fix turns out to more complicated then it should be. I dare say there is an easy fix I've overlooked but having spent yesterday following various leads courtesy of Google I am still stuck on square one! I have a...

Hi all. I have been using PT queries from Access 2007 to SQL 2005 and it has been very helpfull, however, i'm now trying to do the same in order to pull some Data from an AS400 DB so that I can make the user's lives that much easier, however using the ODBC connection string below i'm not having...

Thanks for the reply Michael. I eventually used the GetDirectory method as this system will be used by the staff here and I wanted to make the interface as fluid as possible. Vega.

Good day all. Been tasked with a rather urgent but time consuming project of catlogging the names of a whole bunch of Excel file names into a table. I'm expected to just copy and paste the names of the sheets to a table but i'm certain Access can automate this boring procedure with just a few...

Good day all. I recently set up one of my Databases (access 2007) to create an ODBC connection to SQL Server 2000 on the fly, using the aid of these two sites/articles: http://support.microsoft.com/kb/892490 http://www.connectionstrings.com/sql-server and all was well with the world, but...

Cheers for that Bob. Mitch....

Hi all, I managed to find this nice code that creates a DSN for a SQL server table on the fly for when a user opens a form of the application I have created in Access 2007. Dim stConnect As String If Len(stUsername) = 0 Then stConnect = "Description=SQLDSNName" & vbCr & "SERVER=MySQLServer" &...

That' s a great application you have there. Thank you very much!! Mitch........

Hi all, bit vague this one but i'm not looking at doing anything particulary amazing. I just want to be able to open a form which has the webcontrol open to a particular website, be it google or one of my own and allow me/the user to use it from the Access app i'm developing. Not had any...

Cheers for that. Sorry for the delay in replying, finally found soem breathing time. Thanks again!

Thanks for that. Ideally I wanted to avoid that but if it is not possible to remove the offending Field i'll have to go that route. Thanks again.