Search results

I have two buttons on a form. One copies the Social Security Number and strips out the "-" then opens the IRS Refund Status website. The second does the same thing but (is supposed to) open the NYS Refund Status site. (The urls both work if c/p into a browser). The NYS one gives me an error...

When I use VBA to email a report - DoCmd.SendObject acReport, "Letter 2022", "PDFFormat(*.pdf)", [RealEmail], , , "Tax Return Submission " & Format(Date, " mm/dd/yy"), "Thank you", 0 I get a warning (from Outlook) that a program is trying to send email on my behalf. Is there a way to prevent...

Access (2013) Crashes on pressing Button that runs VBA Code UNLESS I view the VBA code before I hit the button. It works fine after I come back from viewing the code in VBA. Here is the VBA: Private Sub ShowIt_Click() If ShowIt = False Then cUSB.Visible = True CFireWire.Visible = True...

Hi, Currently have this executing at a button press: Private Sub GoIRS_Click() Me!Social.SetFocus DoCmd.RunCommand acCmdCopy FollowHyperlink "https://sa.www4.irs.gov/irfof/lang/en/irfofgetstatus.jsp" End Sub It's supposed to copy the field "Social" into the clipboard. Unfortunatley...

I hope I explain this correctly. I have a form (PCs) and a subForm (Notes). I have a report (Prt21) with the subReport (Notes). In the Form NOTES, I have a checkbox. Check to Suppress Printing that record. In the NOTES Report subReport It prints a Note and the Entered Date. In the controls for...

I wrote the database on a PC with a regular display but when I run it on my laptop that's UHD (3200x1800, I think), the buttons are way bigger, but the active part is correct. First link is the messed up version. The second link is the "correct" way (I changed most of the buttons to a simpler...

Greetings, I have a form with an Attachment field. It will always only have one attachment for any record. How can I directly open the Attachment from the form without opening the Attachment dialog? (The Attachment will usually be a PDF, but may occasionally be a JPG). Thanks in advance ViTo

I have a model database. It has a record for each model. I (finally) figured out how to add an image to the record (I have a jpg in a directory that is the models first name and the first 3 letters of her last name (taken from the open form). In VBA I check if the file exists, if not, it puts a...

I have some VBA code: Private Sub Command2_Click() If Me.TextBoxPassword = "password" Then DoCmd.RunMacro "Calculations.GoodPW" Else DoCmd.RunMacro "Calculations.BadPW" End If End Sub If I wanted to add a Change Password form for the end user, is there a way to do that from what I have...

I'm not a programmer, just have written some Access databases for my own use and some small local businesses. Every once in a while I hit a wall when I try to add some features to a database and this site seems like a good answer to those questions. Cheers, Vito