Recent content by xvertex

Any known issues regarding coexistence of Oracle Client 7.3.4 and Oracle Client 8.1.7 on same machine (Windows XP professional) ? Thanks.

I wasn't able to test this , so I'm asking if anyone can confirm. Having Office XP Standard + Access XP Runtime version, is it possible to open MDE files created with Access 97 ?

it's kind of frustrating - it seems to be a setting issue...or Import/Export Driver...? any idea?

I have to do a TransferSpreadsheet operation and it's working well. However when it is moved on some workstation, this operation gives me an error : Can't Open the object... and actually the problem is with path length (inluding the XLS file name) - it is working well if the entire string is...

Private Sub txtYourField_GotFocus() Me.txtYourField.Value = "" End Sub

if is not secret...u can zip it and send it to me : avertex@yahoo.com

4 linked tables? Those tables are in a different database? Anyway, I suspect the problem is in one of these tables. If I remeber well I had a similar problem, and I discovered an error in one record. Actually in one of the fields (a text field) I found written " #error ". It wasn't...

Private ComboName_AfterUpdate Me.ComboName.Requery EndSub

DoCmd.SetWarnings False DoCmd.RunSQL ("SELECT a.* INTO b FROM a") DoCmd.SetWarnings True

So...you are telling that you managed to repair and compact without problems, but then, you get the same message when you try to open the database? How big it is? Do you have many tables? With many fields?

I think the problem is with strEmailString (that should contain the recipient address). If this string is empty, the email pops up in Preview mode (even if you choose FALSE attribute in command line).

Similar code - OnFormat event for the report.

Open VBA code, select Tools/References and uncheck any unused libraries.

I'd like to send reports (in rtf or xls format) through Outlook (using SendObject command) Is it possible to send 2 or more reports attached to the same email, instead of sending separate emails to the same recipient (each email with one attachement)?

Msgbox "First line" & vbCrLf & "Second line"