Recent content by Custardptt

OK, Think I found my answer here: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=54271 Seems SQL Server samples 8 rows of the data prior to doing the import and decides what sort of data it is based on it's sample. (I also discovered that it's not the first rows it samples.) Unless someone...

Hi All I'm having a little trouble with SQL Server (2008R2) converting 10 digit serial numbers into Float (with 6 digit precision) whilst importing them from Excel. I'm using the OPENROWSET method, and doing an 'INSERT INTO' a staging table. If I just do a SELECT and get the results printed to...

Hi fneily, Thanks for the link, I hadn't clocked that I needed to nest the AddittionalData objects. Cheers Pete

Hi All, I'm attempting to export data from several related tables as XML. The Structure is rather particular and looks something like this BaseTable Table2 Table3 Table4 When I do the Export, only the first relationship is preserved and the XML looks like: BaseTable Table2 Table3...

Thanks All, Pwise's solution was ideal, Thanks Remou as well. Pete

Hi All, I need to use GUIDs to communicate with an external database. How can I create GUIDs within MS Access / VBA. Thanks in advance Pete

Hi All, I’ve written a distributed application that communicates over the internet using a standard windows VPN connection. Problem is that users are complaining about the extra step of establishing the VPN. Anyone know if the VPN can be started / stopped / status queried, from within VBA in...

Hi All, Is there a reliable way of detecting if a file is in use from within Access? My application needs to access and move files that are placed on the local disk by other applications (on the same PC). I’d like to check to see if anything else is writing to the file first. Thanks in...

Hi All, Sometimes I forget to close the properties box when editing my application. Is there any way to cause the properties box to close automatically when the application is started by a user (ie without startup bypass). Cheers Pete

Yep, That works. Thanks PHV Pete

Hi All, Is there an easy way to detect if a control exists in an access form programmatically? I have code that attempts to set the value of a checkbox (having retrieved the name of the checkbox from a lookup table). Problem is the lookup up table may contain the names of controls that are not...

Hi guys thenks for your help and sorry for getting back so late. My woes were multiplied by a failing PSU over the weekend. It turns out the error was produced by my own stupid fault. I included the code in the 'On Open' event but the code relied on some additional values in text boxes. The...

Hi All, Sorry to trouble but I'm having the following problem. I need to determine if an array is empty or not. Since there doesnt seem to be any official function for this I set an "On Error Goto ...." error handler then did a intVar = UBound(arrayname). If the array was empty it threw an...

Hi All, I'm working on an image database using access. The image files are stored externally but the database is used to classify and record secondary information. As part of the project we want to work on images stored in a 'hot folder' using an Access form. Whilst working additional images...

Dear All, We have forms that contain printed data (which must be reentered) and a signature (which needs to be scanned and retained). I would like to get the data included in a 2D bar code (we need about 300~500 characters) and then when the form is scanned this could be automatically ‘read’...