Recent content by mrojas

You have complicated things more than needed. Change the query and code behind button as shown on revised database. The report's query has as its criteria the form's client ID. The send report command takes the email address from the form.

Can you upload screen shots of what you have so far?

Try this: stAppName1 = "C:\a folder name\pdftk.exe " & combine_files & " cat output C:\folder where merged file will be\merged filename.pdf"

Your code below the If DCount statement should look something like this: If Msgbox("This reporting month already exists. Do you want to overwrite the data?", vbYesNo) = vbYes Then DoCmd.RunSQL "Delete FROM Months Where Months.Reporting_Month = '" & repmonth & "'" Else followed by the rest...

This might be more than what you can chew at this time, but it's a start. Once you have your input form designed, in your button's click event, whatever you happened to name this button (Ok, Save, Post, etc.) you call this function passing it the parameter you see fit, in this example, you're...

Could you share with us a copy of "scrubbed" database so we can be of most help?

The following pseudo code might do the trick. Place code in a subroutine or function, and call it from the button click event: Dim aFSO As Variant Dim strFileNameAndPath As String Dim strFileNameOnly As String Dim strNewFilePath as String Set aFSO =...

Could you share with us a copy of your database (scrub it if you have sensitive data). This way we can see what you're running into.

Tell us why you are checking if a form is "visible"? And if it is, then what, and it isn't what?

Pardon my ignorance, but where does one find FindAsUType function?

Have you thought about inserting a sub-form in the main's form footer, keeping the footer hidden until such time the maintenance is flagged as incomplete? This way all your information is in one form, no opening or closing forms, except for the main form. What follows are two routines, one to...

As for the renaming, why not use the aFSO.CopyFile Source, Destination then use the Kill command to delete the old file?

Have you tried creating the query in the design mode, and then making this query the form's record source?

Have you tried to add, for those fields where there's a possible null value, the following: Like "*" & [Forms]![PawnProperty_PawnerQueryForm].[Make] & "*" or ([Make]="" or [Make] Is Null)

How about: Me.Combobox2="" This will clear the text area of drop-down