Recent content by tgroneck

I have to have the composite key to avoid duplicate data. I have users importing excel spreadsheets with data and need this to avoid duplicate imports. I can, however, remove [AccountNumber] from the composite key on [AllItems] without any effect to the data integrity. I am still getting an...

I am trying to create a one-to-many relationship between these two tables. I want to be able to access the 3 fields on the [Processors] table within reports based on [AllItems]. [AllItems] is a listing of account activity where the [AccountNumber] repeats. I have every field set as the...

Re: TransferText Error - "The Microsoft Access database engine could not find the..." Instead of adding the .txt to the end, I replaced .tsv with .txt and it worked. parentFolder = objFileSystem.GetParentFolderName(objFile) Call UnZip(parentFolder, objFile)...

Try: Set objExcel = CreateObject("Excel.Application") objExcel.Visible = True objExcel.EnableEvents = False objExcel.Workbooks.Open "C:\test.xlsm" objExcel.EnableEvents = True

Re: TransferText Error - "The Microsoft Access database engine could not find the..." The following copies the tsv file to a txt file because Access has an issue with tsv. So, at the time of error, the file '20130411012402_BKCHKY_Unusual_Lo.tsv.txt' does exist. objFile.Copy strFileCopy, True

Re: VBA code/ selecting every 3th record You would have to choose what you want to order by. The table wouldn't technically have row numbers. The rows are relative to the order by. So something like this might work (untested): SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY Salary) AS...

TransferText Error - "The Microsoft Access database engine could not find the..." I'm having an issue with the following code. I've attempted to build in the ability to select a zip file for import. The code references a function that successfully unzips the folder and loops over each...

:banghead: I was missing a close quote at the end of the record... Thanks for your time & answers!

How do you step through the import process so that you can tell what record is causing the error? Out of 33 records, the first imports and then the next 16 fail and the last 16 import. Currently, I'm importing via an import specification. Also, I should add that manually importing the large...

I'm using VBA to parse a text file report and reformat it into a comma-delimitted file that I can import into a table. The issue is that when I append each record to a text file and then import it, about half of them do not import due to "Unparsable Record". If I write each record to its own...

After looking at allenbrowne, I decided to get rid of the drop-down and just do a "To:" and "From:" scenario with VBA handling the scenario where only one of the values was entered. Thanks Again!

That makes sense that you can't pass SQL language elements. I had also tried something along the lines of: =IIf([Forms]![Unusual Login Research]![CookieNetworkCriteria]="between",Between [Forms]![Unusual Login Research]![ScoreAtLogin1] And [Forms]![Unusual Login...

[Solved] This expression is typed incorrectly, or it is too complex... This expression is typed incorrectly, or it is too complex... I have a form that I've created to allow users to do a ad-hoc query on data in a table. Most of the fields are setup as Like [Forms]![Unusual Login...