Search results

my experience after June 15 2020 was that the g-suite email accounts don't let you use the 16 digit pass. even so it lets you create a password. but the regular gmail accounts still work.

My old email works but the new one dosen't. can anyone try to see if configuring anew email account with the 16 digit password works for them?

today is 6/15/20 I tried using a new email account, and it didnt work

I guess this is my only option if I want an accurate log. I"ll use the docmd.runsql "insert into log...."values(date... to log the print date Thanks for your hep!

I would like to save a log when a report as last printed. how do you add vba to a report that if printed update ReportPritedLog? I can't figure out which event it is. Thanks!

yes. for people looking up this string I"m providing the standard answer how to create a defaults structure. create a table, give it a name DefaultsTable add fields corresponding to the fields in your regular table or form, and a field with autonumbering named ID create record 1 with the...

my form lets user select options from unbound textboxes and combo boxes [date range, amount, Account, etc.] and then press CMD Print Report to see a report of transactions in the selected options. I wanted the CMD button should also show message box Do you want to save your selection for an...

one user

I"ll ask differently, how would you handle my scenario? making a way user could save his choices in the forms unbound/bound control appear by default the next time he opens the form?

no way to save it from VBA (maybe changing form to design view and saving)...?!

trying to figure out, I can set Default values for form bound and unbound control in Property Sheet. but could i set it with VBA? I tried to add a button on a form, running code to save the current value of specific control to default values, me.control.defaultvalue = me.control when I change...

its more complex then that, because only specific donation are included in the filter string created by the forms textboxes. [date range, amount, cause of donation] What I did in the end is, I added a Yes/No field CreateReceiptSelect to the Donations table and divided the code in 2 the first...

thanks!

by me it definitely realizes the differnce, could be because by me the way it works is, there is a field in the query that looks up [using dlookup or using a subquery] the total of that donor that did not get a receipt yet, and every time a receipt number is assigned to a donation, the total...

how can i test it by me?

no. yes. yes. Do all Dim 's create a temporary storage with data? it looks like this Variable- Recordset changes every time the underlying data is changed, which if i understand correctly dose not occur with Dim As String etc. I saw there a few types of recordsets out there maybe i need an...

Thanks!

The goal is to assign Receipt Numbers to donations With the option of combining donations and only printing receipts if total = $xx.xx or more. the query does just that it selects all donations that don't have a receipt number, that their donor's total donation amount = $xx.xx or more the...

Dim RCPTSetUp, FilterString As String RCPTSetUp = Me.ReceiptSetUp FilterString = " WHERE " 'good trick from DBGuy to check if textbox is null or empty string. it adds an empty string to the textbox, then checks if the total = empty string. If Me.FundFilterAndGroup & ""...

Hi, thanks again I"m going further with your help in https://www.access-programmers.co.uk/forums/threads/recordset-too-few-parameeters-expected-2.311358/ could you explain more clearer what I should do? Thank You!