Search results for query: *

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...

...= 'File1-20130409-01.xls' declare @InFileDir nvarchar(255); set @InFileDir = 'C:\CompareTest\Load' declare @InExcelString nvarchar(1000); /**Get Data **/ set @InExcelString = 'INSERT INTO [KGUX_Store].[dbo].[Import_SetX01_Raw] SELECT * FROM OPENROWSET(''Microsoft.Jet.OLEDB.4.0'', ''Excel...

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’...

Many thanks mmendes for your concise and accurate answer. dkediger, I think you have answered the problem I was going to have next so thanks for that as well. Pete

Hi All, I have been asked to look after an SBS 2003 server and configure the Exchange 2003 part of it. I'm finding it rather more difficult than anticipated. Not sure whether problems with the machine or simply my lack of experience with exchange. Creating New mailboxes: I thought I could add...

PHV, Thanks for your comment, in the past I've used the 'compact on close' but I've always felt that was a sticky tape and chewing gum effort to cover my rubbish programming. I've spent loads of time today making sure everything's closed and set to nothing so I'm sulking a bit about my 30MB...

Hi all, My application needs to load data from two xml documents, I’ve used the command: Application.ImportXML stDocName, acStructureAndData After the import is checked, the data is transferred to the main tables and the tables created by the XML import are deleted: DoCmd.RunSQL "DROP TABLE ["...

Hi all, I’ve been creating custom queries by assembling an SQL string in VB and setting it as a query’s querydef. I was hoping to be able to use this technique in a continuous form with controls in the form header being used to create custom Queries for display in the Detail section. This would...