Recent content by stevendt

Hi Steve, thanks a lot for the code etc. - much appreciated. The way that my application works is that the target table lives in a backend database, the table doesn't get deleted, prior to a new import, the table is cleared with an SQL DELETE *, followed by compaction with...

Hi Steve, Thanks a lot for the update, it seems that 2010 and 2013 have the same "feature" then. I have been messing around trying to write a dummy formatting line on the second row of the sheet, after the header row. It is bed time now though, but I will be very interested to look at your...

Hi Steve, so, are you saying that even if the long string is at, say line 100, Access 2013 finds the string and sets the field to Memo? Access 2010 definitely doesn't regards Dave

That would work if only one field had long entries (in fact, I did try that), but there are three large text fields, any 1 or more of which can have long or short text data in any them. i.e., the longest first text field would not necessarily have long text in the second field, but another row...

Hi Steve, thanks a lot for the reply and the attachments, I will try it with you files and let you know. I am using Access 2010 regards Dave p.s., if it's not too much trouble, could you try it with a larger spreadsheet please? From what I have read, Access uses more than the first dew...

Hi Ranman, well, after struggling through some VBA, I have created a linked table and tried to pull the data through it to send it to a target database. As I mentioned above, as expected, the linked table is created with the fields coming up as text, the data IS truncated when I...

Hi, following on from my question about trying to update a table from Excel . . (Tried to add the link, but I have <10 posts, but it is (delete the spaces) access-programmers.co.uk/forums/showthread.php?t=290594 I have created a linked table to point to the Excel file, now I am trying to...

Hi, thanks a lot for the answer, but before I code the append query stuff, could you confirm that this will actually work please? I have created a linked table using DoCmd.TransferSpreadsheet acLink, . . . . is that what you meant?. When I do this, the linked table has the same issues as using...

Hi, I have an application that uses the DoCmd.TransferSpreadsheet method to import data from an Excel spreadsheet into an existing table (which is cleared before import) in an Access database. The Excel sheet has a number of fields that can be up to 500 characters in length, so I need to...

Thanks Mark, that is useful info - much appreciated regards Dave

Hi Mark, thanks for that, I think I'm getting there. . . At the moment, the counts are configured as a formula in the Control Sources of the textboxes. Your VBA is obviously doing the counting in the Current Event action. Obviously, I don't need both methods counting, but are there...

Yes, I did think of DoCmd.HourGlass(), but could not think of a suitable On event either. I tried checking for the values in the counters being Null or 0, but without success :-( regards Dave

Hi, I have form that has some text boxes at the bottom that are populated by the Count() function. They work fine, but the counts can take quite a few seconds to complete when the form is loaded/changed. It is it possible to display the hourglass cursor (or some other text) while the...