Search results

I found some VBA code online to add page numbers from Access to a PDF. It works but the formatting of the numbers is not ideal, and I'm admittedly unsure exactly what needs to be changed to achieve what I'm looking for. Here's the code: Sub addPageNumbers() Dim acroApp As Acrobat.acroApp...

I have listbox in a form which lists changes made to a record. I have code that lets the user click an entry in the listbox and it opens up a single view form with a more detailed view of the change. I want the code to open to that particular entry but also apply a filter as well so that the...

I have a combobox with three preset values (New, In Progress, Closed). I want to have VBA where if the combobox's value is changed from 'Closed' to 'In Progress', then my date field (ClosedDate) is changed to null. Any suggestions? I don't know how to specifically make an action happened when...

Thanks. How would I incorporate this into an update query?

Curious if someone could help with this issue. Couldn't find a specific guide online to assist. I have a table of last names that are entirely uppercase. I want make them proper text. I'm using the following function in an update function that works well: StrConv ( [CustomerLastName], 3 ) The...

Here's a sample of my data: 202210 202208 202210 202201 202204 202109 202104 202106 202303 202207 202209 202211 202202 202108 Its year and month. I want to use a query to group this data and count it. I want to group it in 12 month intervals (ie. 202205 - 202304) Any suggestions? Not sure if...

This worked. I appreciate all the help

I'm very much a beginner with Access/VBA. I'm sorry

So I have a form of complaints (frmComplaints). The form's record source is tblComplaints. I have a large inner join query whose records have a field of ComplaintID (qryX). I want to use a command to open frmComplaints and also filter it to any records whose ComplaintID matches the ComplaintID...

Gotcha. So I want to open the form from a command (sorry; I should have mentioned that). How do I build this into a DoCmd.OpenForm code?

Basically the title...any suggestions for code to open a form to only the records that match an ID field of records in another query? Which isn't the form's record source?

Thanks. So I tried the below and it almost worked: Right([yourfieldname],Len([yourfieldname])-InStr([yourfieldname],",")) & " " & Left([yourfieldname],InStr([yourfieldname],",")-1) It swaps them perfectly except it leaves a space at the start of the field. I'm not sure how to fix that with the...

Nvm I'm dumb. I changed to this and it worked. I appreciate it! Replace$("" & p & "", "" & ![Original] & "", "" & ![Replacement] & "")

Like this? p = Replace$( & p & , & ![Original] & , & ![replacement] & ) I'm getting a syntax error when i do that

I am using the below function which uses a table to replace values. It works well except I need to add in wildcards and I'm unsure how to do it correctly. Right now, if I want to replace 'Hello' with 'Hola', it works perfectly. But I want it to replace any instance of hello, even if it is...

I have a name field which is formatted as "LastName, First Name". I want to rearrange it to simply be "FirstName LastName" and get rid of the comma. Any suggestions on how to write that in an update query? I feel like I found a guide online to do this before, but for the life of me, I can't...

I have a query which selects 30 random records from my table. I want to be able to export this random listing to both a PDF file and an excel file. The issue is I'm not sure how to use VBA to export this listing to PDF & excel, and have the random records on both be the same. My query is...

I have a really odd problem which is likely way too specific but what the heck. I have VBA code which creates a ACCDE copy and a Backup copy of the current DB. It works perfectly fine except for a very small quirk. After executing the code and exiting out of the main DB, any Access file you...

That worked! Thanks so much!!

Where do I place that code?