Search results

I figured out how to copy the failed file names into a table. Thanks for the help.

I figured out how to implement the timestring code and to exclude the failed files from the import count. I would like to know how to capture a list of the files that have failed and show those in a report or table somehow. Is there a way to do this? Private Sub subImport() On Error GoTo...

Could you show me how I would implement the time function in my code? Thanks

That worked. But, how do I get the file count to exclude the file that was not imported? If I click 'ok' to ignore it, the 'y' variable still includes the ignored file. Also, is there a way to show the elapsed time as hours, mins, and secs ( ex. 3 hrs 14 mins 3 secs)?

I am using the below code to import .csv files from a directory and it is working fine. But, I would like for it to prompt me when there is an import error (ex. field names don't match), allow me to skip the file, and then continue with the import. Any suggestions on how to do this would be...

After rearranging the code I finally got it to work. Not sure this is the best way to do it, but it works. Private Sub showtdf() Dim db As Database Dim tdf As TableDef Dim x As Integer Dim tbl_Name As String Dim tbl_Field As String DoCmd.SetWarnings False Set db = CurrentDb For Each tdf...

I am trying to use the below code to list in a table all the tables and there associated field names in the database excluding the system tables. What I am having trouble with is excluding the system tables. I'm not sure how to modify the code to do this. Any suggestions would be appreciated...

Thanks for each of your responses. I went ahead and used DALeffler's InStr(InStr(InStr(1,[ttext]," ")+1,[ttext]," ")+1,[ttext]," ") for this instance, but will keep the other examples in mind for future reference. I have another question concerning extracting substrings. I need to find the...

Thanks, that worked perfectly. What would I need to do to find the position of the additional spaces in the string?

I am trying to find the position of the second space in a string, but have not been able to find a solution. Any suggestions on how I could do this using an expression in the QBE window or VBA would be appreciated. Thanks in advance.

I am trying to combine the below queries into one using nested Select statements, but I am not having any luck. Any examples on how to do this would be appreciated. Thanks qry1000_006_01-Base4 syntax: SELECT RIVMTRM0_STDY_GRP_TST_REMARK.IVMSGRP...

ByteMyzer, your SQL works perfectly. I had also implemented a solution using two querys, but if I can get the job done in on that's even better. Rural Guy, I would still like to see your solution using VBA. I would need the records copied into the temp table. Thank each of you for your help...

Sorry, I'm a little thick headed today. I would want the records put into a temporary table.

I need the results to be returned in a query

No, there are multiple IVMSGRP

The max number would work, but I need to return the whole record set that is missing the number. I am not very efficient with VBA, so if you could suggest some code I could use to do this it would be greatly appreciated. Thanks.

I am having to verify that for an ID group that the related column of numbers are in sequence. Below is a snapshot of the data I'm working with. I need to verify that the IVMTESTSN is not skipping a #. If anyone has a function I could use I would appreciate it. Thanks IVMSGRP IVMTESTSN...

Thanks for the response. I ended up figuring it out. I needed to trim the search field. It was comparing the field values using the extra spaces.

I am trying to exclude records that have a value like another value in a seperate field, but Access is not excluding the records. Any suggestions on what I could do differently would be appreciated. I have attached a snapshot of the query. Here is the expression I am trying to use: Not Like...

I am getting an "Invalid procedure call" error when trying to run this query in Access. If I remove the Distinct it runs fine, but I need it in there to remove duplicates. Also, When I remove the expression...