Search results

I changed it to Shell "explorer " & "https://www8.tax.ny.gov/PRIS/prisStart" and that worked. I don't understand why the original stopped working. But, whatever. At least I got it working. Thank you to all who helped.

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...

It's Office 2013. There is no Programmatic Access tab in this version.

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...

Thank you. This fixed it. I don't know why it's different on the two systems? I installed them from the same files and never changed anything. Oh well, at least the problem was solved. Again, thank you.

No. On my Win10 system, it only copies the first character of the field. When I copied and pasted the exact same db file to the Win11 VM, it copies the whole field.

That didn't work.....BUT, I copied the DB to my VM (Windows 11/Still Office 2013) and it DID work. I saw when I clicked the button, it highlighted the whole field, not just the first character/number. Any ideas why?

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...

Ignore the above post. I imported the Notes Table, Form and Report from the "Clean" version I uploaded and was changing things in, into (a copy of ) the Production Version and it's now working. Thank you all for all your help.

Let me think... I wrote that part a few years ago. Okay, the ID in Notes is not a primary. When you're viewing a PC Record and you add a note, it takes the ID of the PC Record. If you look at the NOTES table, there are multiples of an ID. This was so all the Notes for one PC record would have...

So.. I got it give me the right information, thank you, BUT.... If a record has 4 notes, it's printing 4 copies of the same page (each with all 4 notes). I'm thinking of just abandoning this "update" ughhh

Looks good. BUT, I'm a little confused, where did you prefix txt? Could you possibly upload the fixed version? Thank you.

Fixed it. I saved it as a RAR file. Changed to Zip

Here's a cleaned out version. The main form (PCs) has another checkbox (Print21) which is a flag to print that record. Click "NOTES" to see the Notes, their EDate, and Print Flag for that note. Each record can have multiple notes. Click "PRINT OPTIONS" then PRT 22 to generate report. Report pages

I corrected above. It's actually: =IIf([Flagger], "REDACTED", [Notes]) =IIf([Flagger], "", [EDATE]) I also had =IIf([Flagger] = True, "REDACTED", [Notes]) =IIf([Flagger] = True, "", [EDATE]) Both of these DO give me the same result, Error if not checked and "REDACTED" if checked (and date is...

Sorry, I did have as you said. I typed my post from memory. The Checkbox in NOTES is labeled "SUPPRESS PRINT", but I realize it's conditionally display. Thanks. I'll retype in what you suggested. Maybe I typed it wrong. I'll check

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...

One line: DoCmd.CopyObject , "Backup Name" & Format(Date, " mm/dd/yy"), acTable, "File to Backup"

I created a quick form manually (no wizard) with 2 fields and a button. 1. When I first open the form, I see this: http://www.cdphotography.com/55/t12.png 2. If I click on it, I see this: http://www.cdphotography.com/55/t22.png 3. If I look at it in design view and select the button, I see...