Search results

Perhaps using the scrollbar activeX control instead the default vertical scrollbar in the continuous form can solve your problem, because you'll have to code when and how scroll the records.

Perhaps this can help you, but I suggest you to listen the advice you have been given: ? Format("49","####") 49 ? Format ("49","0000") 0049

You shoudn't link an image from your local/shared disc, the image must be accessible from the internet. If you want to embed the image into the mail body, you have to search information about "AddRelatedBodyPart" Set Attachment = Message.AddRelatedBodyPart(CurrentDBDir() &...

If I print some hexadecimal values, this is the result: ? &HF 15 ? &HFF 255 ? &HFFF 4095 ? &HFFFF -1 ? &HFFFFF 1048575 ? &HFFFFFF 16777215 ? &HFFFF = &HFFFFFFFF True ? &HFFFF , &HFFFFFFFF -1 -1 All hex decimal values from &H0000 to &HFFFF are considered signed integer type so...

Characters that are shown in a textbox depends on the font you are using in the textbox. Some fonts have more unicode characters defined than others.

Are you talking about twinbasic? I can't post links, but if you are talking about twinbasic it would be easy for you to find it.

Perhaps the basMouseHook by Wayne Philips disables the mouse scroll wheel in Access forms, it only works in 32 bit MS Access. AFAIK there is no 64 bit version and no way to disable the mouse scroll wheel in 64 bit MS Access. If I'm not mistaken if you want to disable it, you have to comment...

According the code you posted, SSL is not configured.

No you should ask your SMTP provider what configuration you have to use when using SSL and then configure it in the CDO procedure. Search in google: 'sending messages using SSL authentication in CDO' Lately it's recomended to use SSL when sending messages.

Have yo tested to authenticate using SSL?

The report textboxes must refer to the form textboxes values. Their controlsource property must be: =Forms!FORMNAME!StartDate and =Forms!FORMNAME!EndDate (Change FORMNAME with the name of your form.)

You don't need an invisible button to open the agent profile, you can use the onclick (or better double click) "AGENT NAME" textbox event to open it.

To test if it might be a data problem, you could assign the number "3" instead of copying the value from another combobox to see it it works or not. [edit] Too late! I see the problem is solved!

If I'm not wrong when you use the IIF() function in VBA the interpreter always evaluate both branches of the exrpression, BUT if you use the IIF() statement in a query the SQL interpreter only evaluates the according part of the expression.

The query works fine but depending on the data, if there are 0 or Null values in [VP] then the code will fail. This code avoid the 0 and null values in [VP] and [SP] SELECT qry_receipt_bay_progress_2.[Cases Expected], qry_receipt_bay_progress_2.[Cases Receipted]...

Test with this code Dim DelPic As String Dim Response as long DelPic = Me.picafter1filepath If IsNull(Me.picafter1filepath) Or Me.picafter1filepath = "" Then MsgBox "No Picture to Delete", vbInformation, "There is not much to delete" Else 'Execute Response =MsgBox...

Perhaps these videos by Richard Rost can help you:

Hi Colin, I've converted the databases in several steps with no issues. 1.- Access 2 to Access 2000 using Access 2000 2.- Access 2000 to Access 2003 using Access 2003 3.- Access 2003 to Access 2010 using Access 2010 To convert the HLP file, I searched a andom HLP online converter (I can't...

@isladogs Here it is the Solution database converted to these ms access database formats: 2000,2003,2010 accdb. There are some compiler errors and I suppose it needs the NWIND database to work properly.

I don't use it in my applications but I've used it every now and then for testing purposes or for helping me to fix some bug. Using DAO and printing bookmarks, I noticed that if you open a dbOpenTable recordset, bookmarks are consistent after closing and reopening the recordset, or if you open...