Search results

thanks for the quick response. to while that did add the double quotes to the each list item (which I noticed was missing), I'm still getting the same error. I'm thinking that it is somewhere in the Criteria part. it claims that the error is in the expression, 'where status_cd...

I have a continuous form with comboboxes that feed into a query. In addition to the comboboxes, I'd like to add a multi select list box that enables the user to filter the form (query results) based upon the selections. For reference, the field that I would like to filter on is also referenced...

sorry, I thought I deleted my post in time. i was able to figure it out shortly after posting. all I had to do was duplicate the dhAddWorkDaysA function, rename it to dhsubtractWorkDaysA, and change the line "dtmTemp = dhNextWorkdayA(dtmTemp, adtmDates)" to read "dtmTemp =...

For those that are having trouble deleting that ~tmpclp#### form or report that only shows in VBA module and NOT as an object in the navigation pane. I created a new blank form (but did NOT save it). created a button, assigned a macro to it and gave it the following code: docmd.rename...

the code is the same as in the original post except for the addition of the msgbox line directly above the .mergealljobs command. one other key point (as noted in my code, but may not work for others), is that I make sure to launch Adobe Acrobat first.

thanks again for looking deeper into this, much appreciated! along those lines, I stumbled upon a possible solution. if click on the line that reads ".mergealljobs" creating a stopping point whereby the line turns maroon (not sure what the correct terminology is for that), and then run the...

sorry about that. version 2.2.2 this is what my company has. this appears to be a free version

PDFCreator works fine except for my minor issue. it seems to be a decent alternative to those that do NOT have Adobe Pro. Essentially, PDFCreator acts as another Printer, so you can print to PDF as well. The merge feature is the one that I am most interested in. It does merge the files, just...

thanks for the reply. I did see that, but my company will not approve downloading and installing library files from unapproved sources. thanks though...

trying this again folks since my prior thread (XPS merging) got zero responses. I soon realized that using the VBA code for PDFCreator will merge PDF files, so I can move away from XPS. My code is almost there. my only roadblock is that once each PDF gets sent to the PDFCreator Print Queue...

bump. unfortunately, my company blocks the pdfforge.org website, so I cannot view those manuals. I'll check from home next. but anyone with any coding insight, I would be most appreciated. thx.

Hello all, I'm somewhat new to Access/VBA, and I'd like to add a button to a form that will merge all XPS files in one folder into a single PDF using PDFCreator. Given that all folks on the team that I support do NOT have Adobe Acrobat Pro, merging PDF files into one PDF is not possible (from...

I'm looking for the logic that will allow my union query to exclude a table based upon data from a separate table. can a union query be designed in this fashion?

I built a union query, combining the fields from table_A, table_B, and table_C. However, I want to exclude table_C only if the inactive_date is not null (data stored in a master_list table). This master_list table lists all of the tables within the database. I tried to insert some iif/then...

thanks for the response, but I found a solution. with the help of a colleague, I set up a module function for the e-mail logic and used that rather than docmd.sendobject. no more crashes. the key in the module could be better identifying Outlook as the application.

thanks for the quick response. however, I don't think that will be very efficient to send seven e-mails when one should suffice. in this case, there are no nulls, but I'll certainly try that to see if it makes a difference. every field does populate correctly on the e-mail, and the e-mail gets...

I found several threads on this topic, but could not find an appropriate solution for my issue. I created a database (frontend/backend) for my team where the frontend is installed on their PC and the backend table is located on a shared network. There can be as many 30 folks in the backend...

thanks for the feedback, but I figured it out. the subform was embedded in the header rather the detail section of the form. moving it to the detail section solved the issue.

Hi all, I created a form with an embedded subform (continuous form). The main form (frame) has 15 buttons going down the left-hand side with the subform adjacent to them. This format works very well for my team and looks asthetically pleasing. The lone draw back is that some folks have a...

Hi all, I'm having some trouble getting my database to run a public function called "Export_as_Txt". I have the VBA coding setup as, "Public Function Export_as_Text()" both within the form's VBA code and within a module named "Export_as_Txt". I then want users to be able to run this function...