Search results

Can someone explain why these 2 queries have different results? 1) returns 314 records SELECT locations.LOCATION_NUMBER, locations.LOCATION_DESCRIPTION, FROM locations WHERE (((locations.LOCATION_IS_INACTIVE)<>True)) ORDER BY locations.LOCATION_DESCRIPTION; 2) returns 308 records SELECT...

I am trying to extract the data file path from an ODBC System DSN via code. I can view the DSN info in the registry, it is located at: HKEY_ LOCAL_ MACHINE\Software\ODBC\ODBC.INI\ and has the name "DSNOne". I have code to extract the info I want from the file. This code works for a File DSN...

Paul, It was as simple as 1-2-3 once I knew where to look! 1) At the top of my module (before the Function) I placed: Public blnCancel as Boolean 2) After DoEvents (which was in my Loop) I added the code: If blnCancel = True Then Exit Function End If 3) On my form I added a...

It depends on the import file. Could have 1,000 records or it could have up to 30,000. Not all of the import files will contain all of the importable fields, so the code checks if the field exists before it tries to add it. And the form has a progress bar which slows it down a bit so it could...

I have built a form that matches fields and then appends records. I want to give the user an out (Cancel button) if they have selected the wrong file or if the process is taking too long. The OnClick sub of the Begin button checks a bunch of combo boxes to make sure vital fields are selected...

Thank you that works perfectly! sup

I need to view the data in an imported excel table. I have set up a continuous form with textboxes named txt1, txt2, ... through txt16. After import, I run a function to write the field number and field name to a table. I can dynamically set the control source of the textboxes on my form using...

I'm having the exact same issue with "short date" correct in the table, but the 0:00 added in the csv file. Does anyone have a clue how to resolve this? Thanks, Sup

Thank you all! I hope to post a working example soon. Sup

I totally agree that would be the proper way to store the data. Unfortunately, I have no control over the data. I am building an external report generator that uses a "Professional" application's linked database as the source. There are various groups (turns out to be about 135 of them) that...

The record source for my report is a table that contains comma separated data in the field [Selections]. I need to filter my report by items that are in [Selections]. I have a multi-select listbox on my form to do that. I am trying to populate the listbox by parsing the values in [Selections]...

How are you entering or getting the date in the first place? If you are entering through a form, you can use the after update event. me.txtmyDate = Year(me.txtmyDate) If you are appending via query, you can format the column to append. FieldtoAppend:Year([myDate]) Sup

Format([myDate],"yyyy") or Year([myDate]) hth, Sup

I print barcodes in reports all the time without active-x or external barcode software. I just downloaded and installed the barcode fonts that I need, and then use them as the font for the textbox in the report. You must be sure to include Start & Stop characters in addition to your field...

I have a table of Transfer and Return dates for items that are moved between locations. The table includes the following Fields: RecordID ItemNo LocationNo TransferNo TransferDate ReturnNo ReturnDate I need to update the ReturnNo & ReturnDate for each record to the TransferNo & TransferDate of...

I removed the brackets and switched to DoCmd.RunSQL instead of .execute . Now it runs fine in both 2000 & 2003. Thank you very much for your help! Sup

The following code creates a new mdb and adds backup tables from linked SQL Server tables from the currentdb. This code works flawlessly in Access 2000, but seems to fail at the line ".Execute strSQL, dbFailOnError" in Access 2003. Private Sub cmdBackup_Click() 'Back up ALL linked tables...

Bob, You are good! I was set to break on all errors. I set it to Break on unhandled errors and that fixed it. Thanks so much, Sup

Bob, Here's a new zipped file. This is very strange, I just tried this test file and the cancel error is Not there. So I tried my real file, and the error IS there. So I tried my test file again, and the error is BACK. I guess my code is OK, but something else is causing this error to...

Attached is a new mdb with nothing but one table, one report and one form to test the error. I still get the error when I cancel the print dialog! What am I doing wrong? Sup