Search results for query: *

jadams/pedrox - Thanks for the suggestions. The db is currently split front end/back end, but I was hoping to avoid local copies because of the number of users we have (50+). I have also considered the temp table option, but the db size bloat I was also hoping to avoid that option as well. It...

I need help resolving an "issue", and I haven't had any luck searching. I have a form that is used to run a report, and the criteria for the queries is built in the form. The where clause can be a combination of a number of options, so I have the where clauses being dynamically built in VBA to...

gol4 Worked perfectly for me, have a star! JR

Oharab, the class you posted was extremely helpful for my purposes of stripping out carriage returns from some large text files. This function in particular: Private Function AlphaNumOnly(strIn As String) As String ' removes all but the ASCII Characters on the ' keyboard. Dim intI As Integer...

JeroenNL, I had the same issue, you can get around this by changing the registry setting directly. The setting is here: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\Access\Security Then set the value of the Level Key to 1. Hope this helps, JR

Thanks Larry, your example was perfect for what I was looking for! JR

Fule, It sounds like your primary key needs to change if there are some fields that can change while others (your current PK) stay the same. You may need to add more fields to your PK in order to make the records unique. Can you send the table structure and what the PK or PK's are? JR

That is the reason for the primary key, to not allow duplicate data. If this is not the intention, you need to reexamine your table structure. JR

You may also want to look into the Nz function, just search for it in the Access help for an explanation. Just another option to consider. JR

Function importFiles() 'function importFiles() imports the files using the import specs 'because of Access' limitations in regards to importing to linked tables, a local table 'is used to import to, and the data in it is then appended to the linked table Dim fol As String 'starting folder path...

Here is the code that does the file extension in .txt format: Function moveAndCopyFile() 'Function moveAndCopyFile() finds the appropriate file, moves it to a new folder to with 'the current date and then creates a copy that is in .txt format to be imported into the 'database, it then calls...

Victoria, From the minimal amount of testing I have done it doesn't appear that a *** entry in the registry will allow any text file to be imported. I also tried F** to no avail. It looks like you would need to hard code each possibility, but my suggestion would be to write a function that...

If you don't want to go through the process of renaming the files each time you can also edit the registry to recognize .F16 files. What you will need to do in this case is edit the registry key that enables the .F16 extension. The registry path is...

No luck here either with the service pack update, thanks for the suggestion though. JR

I also have not been able to solve this problem. I found a site that has the functions to run most of the wizards from code, here it is: http://www.mvps.org/access/general/gen0028.htm If anyone out there knows how to run the Find Duplicates Wizard from code, I have been unable to find that...

If you don't want to go through the process of renaming the files each time you can also edit the registry to recognize .dat files. What you will need to do in this case is edit the registry key that enables the .dat extension. The registry path is...

I'm glad you got it, for my own curiousity could you elaborate on what finally fixed it as I wasn't able to duplicate the error. Thanks. JR

What version of Access are you using, and which references do you have checked?

You should be able to pass those in the same as the SQL statement, just add them as parameters in the Function. As to the other issue, try replacing this line in your Function: Set rs = CreateObject("ADODB.Recordset") With this line. Set rs = New ADODB.Recordset This should create...

Take this line out of your sub: strSQL = MystrSQL Other than the code referencing your form, there is nothing different from what I tried. You are not actually using the strSQL variable in your sub so it is not necessary. Let me know if you have any luck once you remove it. JR