Search results

Is it possible to code the CD-ROM tray to open/close? Thanks, Jeff

If using an Access query drag down the LetType field to the grid and enter "6M" into the Criteria cell and "30M" into the "or:" cell right below it. If you are using VBA code add the line "WHERE LetType = '6M' OR LetType = '30M'" HTH, Jeff

For a start I believe you have an error in this line: Criteria = "[Project] = '" & "[cmbProject]" & "'" Perhaps it should be: Criteria = "[Project] = '" & [cmbProject] & "'" HTH, Jeff

Yep, the UNION command did the trick... THANKS! Jeff

Thanks RV The UNION command is exactly what I needed. Jeff

Thanks for the reply Wayne. I was trying to tackle a problem that I have detailed in this post: Combining table data problem If I can't reprocess open recordsets with SQL, it looks like I need a slick SQL to generate the data upon opening the recordset. Thanks again for you reply, Jeff

I have a database with a table of employees, a table of contacts, and a table of suppliers. I wish to create an "Address Book" form that will generate a combined, sorted list of the Name and PhoneNumber fields from all three tables. I need some slick SQL to combine the data into a new...

Yes, I realize that upon opening the recordset I have full SQL control, but I was wondering if I can manipulate recordsets with SQL after they are created. Jeff

You best be good with code to venture into this task. There is no quick and easy way to do it without coding it (in my experience). Here's a start. For the checkbox control try this untested code... Private Sub chkGenerateControlNumber_Click() Dim rsGetMax as ADODB.recordset If...

The right syntax is: Me("Book" & intBookNumber).value = 'whatever HTH

Use the timer function to automatically close the splash screen Set TimerInterval for the form to 3000 (for 3 seconds) Private Sub Form_Timer() DoCmd.Close acForm, Me.Name End Sub Also consider an option to close the window with the click of the mouse (for those impatient types). Private...

Hmmm... Not exactly sure what you are getting at. Give an example of a "control number". Is there a fldControlNumber in each record of your table? Do the "control numbers" increase sequentially if the checkbox is clicked? More info please.

Thanks for your response cpod. Works like a charm!

Is there a way to apply SQL statements to a recordset? For example: Dim rsOne as ADODB.recordset rsOne.OpenRecord("SELECT * FROM tblEmployees") doCmd.RunSQL "DELETE rsOne WHERE fldName = 'Jones'"I understand the example above can be accomplished all in the OpenRecordset method but what I'm...

Is there a way to use FindRecord to find the first occurance of a particular field with a zero-length string? The following code generates an error (requesting that criteria be supplied for the FindRecord method)... fldLastName.SetFocus DoCmd.FindRecord "" Any help would be appreciated, Jeff

Thanks Rich this helped. :)

Just a thought- Try Mid$ See if this helps.

I like "lighter_triangle".

Say audrey, what program are you using to create all these cool looking logos? (from one still in need of a nice graphics application) Jeff

Sorry don but even the best spell checker probably doesn't have "rockman" in it.:D But in general I agree that a spell checker for the forums would be nice! Jeff