Search results

this is true, you need to change your code: Do Until RS.EOF = True Debug.Print RS.EmailID ' SendPDFReportAsEmail 'Currently commented out for testing RS.MoveNext Loop

the code for the saving image and blurring is generated by our favorite AI friend. demo will show you how to "simulate" blurring of the background so you can pay more attention to the Msgbox presented to you. the demo forms are using "Tabbed documents" (not overlapping). so that frmOverlay can...

I revisit this thread to add another "blurring" demo. This time using API and of course with the help of our AI friend out there.

you should change all Joining lines. right-click on each relation line and choose: Join Properties and from there choose: "select all records from OrdersT..." do this to all your relation lines. you should have this:

remove the filter from the query, do you see any data?

is the report based on query and the query is getting the filter from the form? it's hard to guess, without seeing what is going on on your form/report.

I cannot add new update on the original "cheap alternative to access imagine" thread since it is already closed. With this update (form frmCamera2) there is no need to configure the camera (unlike before) before it can be used to take a snapshot. You may want to experiment with various...

it works with Excel, why shouldn't it work in Access?

you may start with this one: https://www.wiseowl.co.uk/vba-macros/blogs/vba/general-programming/speech-recognition-object-library/

upload your db.

can you issue Requery on those 3 Textbox on the Footer, like: Private Sub Form_Current() [TotalMinutesTextbox].Requery [TotalHoursTextbox].Requery [TotalHoursMinutesTextbox].Requery End Sub on you can use the Form's Current event.

you may try this: Private Sub cmdExportToWord_Click() ' Code to export and save data to MS Word Template On Error Resume Next Dim objWord As Object Dim wdDoc As Object Dim strPath As String Dim AnswerYes As String Dim AnswerNo As String strPath = "C:\templates\mytemplate.dot" Set objWord =...

there is a sample in our Code Repository bank, and is uploaded in Github. https://www.access-programmers.co.uk/forums/threads/serial-com-ports-in-access-vba.324523/

there is a simple "control resizer" on the attached db (see the code on frmAppCalendar form. the resizer code is in basUtilty module.

here this time this has highlight and without flicker.

here test your db. i arrange the Tab order and also add ControlSource to textbox txtSelectedRecord.

i save the record immediately after each scan.

record_id is autonumber and is unique, so you will end up with All the records returned. use Total Query: Select Min(record_id) As minRec, artist_name, Min(record_release) from yourTable Group by artist_name;

that is a presumptive size. when you add table to blank database, it create the table, yes. but it also add record to MsysObjects and other system tables.

i don't get any error on the new code.