Search results

WayneRyan, Changing the wildcard in VBA to a percentage did the trick - I'm very surprosed to see that VBA wildcards and standzrd MS Access query wildcards are not the same. Thanks! ________ Mflb Vaporizer

I have a procedure that uses a recordset. The recordset is set to a string that contains an SQL statement. I can run the SQL statement in query view and return about 300 records. When I try to open the recordset defined by this SQL statement I receive no records. What's happening? Here's a code...

read http://www.zmey.1977.ru/Access_To_Excel.htm ________ Zetec Engine

Thanks! This is helpful. The caveat about a multi-user app is well noted. I'm wondering what you have to say about the following workaround: (1) dynamically generate an "eligible" column name based upon logged in user and date-time stamp (2) execute an ALTER TABLE...INSERT COLUMN statement...

I have a problem and am looking for some advice on a best approach with respect to performance. PROBLEM: I need to have MS Access perform a complex search - I have a master list of records with about 120K records. - Each record contains about 40 fields. - 5 fields contain free text. -...

What I was thinking was more of a log application where new entries could be added to an external log file. I'm terriby rusty with my unix shell scripting, but I do recall scripts to open a log file, and append new values to either the start or end of an existing log (cat piped to sed?)...

as an FYI - how would I concatenate a new value to an existing output file? ________ SILVERSURFER VAPORIZER

Brilliant! Thanks for all of your help. ________ NO2 VAPORIZER REVIEW

I have a MS Access database that recently had a BLOB like feature added to support the storage of documents. Since this feature was added (and documents started being stored) the DB has not behaved especially well. For exmple, every time I run a compact/repair operation on the database...

When I use the Write # method to srite string data into a text output file, the output is nested between double quotes. My problem is that I want to dynamically create a batch file that deletes temporary files MS Access has created (through custom VBA code) upon exit. When I use this...

I have a database that extracts a batch file and then executes this file as part of an OnExit procedure What I want to do is set the file attribute of this extracted batch file to be hidden. My code looks like this: When I run this code a command window opens, but the ATTRIB instruction...

once your data is normalized, you can use a "Make Table" query to build your 3rd table ________ EAGLE TALON

This might work for you because the Workbook.SaveAs Method supports the FileFormat argument ________ Acura el specifications

this is promising - but something is still wrong I tried executing the code and now get the error "Microsoft Access cannot find the field [...] referred to in your expression" The error is right because [...] is the name of a form control (option button/radio button) and not a field name...

I know this adds extra complexity, but I have had success using the ADODB recordset method to export MS Access data to MS Excel, and then passed MS Excel VBA code directly from MS Access to MS Excel to draw heirarchal headers, draw lines, merge cells etc within a created MS Excel spreadsheet...

I have never figured out how to calculate the name of a control and the use that calculated name to assign a value. Is this possible in MS Access 2000? Pseudocode emulating the behavior of an option group or control array when a form is loaded is listed below. Please consider...

JonTheOne, Sorry for overloading you with detail. Here is my quicky introduction to VBA. STEPS FOR ASSIGNING CODE TO A FORM OR FORM CONTROL (1) bring a command button onto a form from the form toolbar (2) cancel out of the wizard (3) open the PROPERTIES window for the command button...

pick a control at the beginning of the relevent section and use either code or a macro using the SetFocus property e.g. with code: [Reports]![rptComprehensiveReport]![txtTextBoxInReleventSection].setfocus Change the control you wish to set focus upon based upon the report name that the user...

I'm guessing that you want to see an example of the approach I described. Here is one I wrote several years ago. The premise is as follows: (1) [Forms]![frmNameLookup]![lstPeople] shows a listing of people identified as cases or contacts throught the course of a major hepatitis outbreak...

Re: Display "Null" data/records in subform with Filter HIGHLIGHTING RECORD IN PARENT FORM: Not knowing the exact relationship between the data in the parent form and subform I'll take a guess that the parent form diaplays a list of all records and the subform displays details. What...