Search results

Thank you for your response Minty. Can you explain how to do that?

Hello everyone, I am trying to export a multi page report to .pdf files. Each page of the report is a different file, so if there are 50 pages to the report, there should be 50 different .pds files, each with a unique name. I can get it to loop through every page and export a file, with this...

Thank you for the information! I have been away for a little while and just saw your responses. The last one isn't free, but the first two show great potential.

Hello everyone....I was wondering if there was a way of exporting a access report to multiple .pdf files. The report length can vary, but for this example, lets say it has 50 pages. Each page is a seperate customer with their information and we would like to email each customer their own .pdf...

Hello all, I was hoping that someone knows of an offline free QR Code generator. I am currently using Google's QR Code generator, but I would like to create them offline. I wasn't sure if there was free code out there for access or not, but I have been searching for days and so far the...

The query could have anywhere from 1 to 130+ fields depending on what they want to see. I think it would just be easier to view if it was a query. If need be, that's what I will do. I was just trying to avoid that.

Hello everyone, Is it possible to make queries popup & modal? Currrently the users export an excel file based on multiple variables, which works fine, but recently they asked if it would be possible to view the query results before exporting, but everything in the database is popup modal and...

I went with the tri-state checkbox (for space reasons), which I never knew existed, so thank you for showing me that. I will be training the users once I have the db completed, so I will make sure they all know about it. How do I check for that state of the check box? Now I have True, False...

Ok, I got that working, it shows ever record with a date, but it doesn't show null values. Is there a way to show records that are null? Thanks

Hi Spikepl, It turns out that I have one more followup question. The code you posted works great if the checkbox is check with a date range and it works if the checkbox isn't checked, but I have a third option. I would also like to have the option to have the checkbox checked and have no date...

Thank you for your help! That worked perfectly! I try to name everything and not go with the system defaullts, but I have almost 150 check boxes on this form and got lazy.

I have a query, "adhocComplete" that has criteria ">=[Forms]![frmAdhoc].[Date] And <=[Forms]![frmAdhoc].[Date2]" for the field [30DayDue]. Is there a way of removing the criteria from the query by unchecking a checkbox [Check62] on the form [frmAdhoc] and re-adding the criteria if the checkbox...

Hopefully I will be able to explain this properly. I have a query that is pulling a date from a Form. In my Query Criteria, I can put: >=[Forms]![frmAdhoc].[Date] or <=[Forms]![frmAdhoc].[Date] or =[Forms]![frmAdhoc].[Date] And it works fine, but I don't want to hardcode the ">=", "<=" or...

Hello everyone! I have a form, frmEmployeeData, that has a subform, frmSubEmpData. On the subform I have a Tab Control, TabCtl0, with four tabs on it. What I am trying to do is: When the form opens, the Tab Control isn't visible, but as the user checks a check box on the main form, the...

Hello, I am trying to automate the function that imports Infopath (.xml) data into access tables. I can have a button run the MenuCommand, but then the users have to go through all of the prompts and I just don't trust them enough to do it properly. Does anyone have code that automates this...

Hi Everyone, I am creating an update database (DB A) that when opened it will copy various tables, queries & reports from DB B and put them in DB C. Then I want to delete DB B and rename DB C to what DB B was named. I am able to copy the table, queries & reports over, but not sure how to...

Hi, I am trying to reference a field on a subform from another form. So basically I have FormA - SubformA - FieldA(CheckBox) and then I have FormB - Field B. When I click a button on FormB, I want to check to see if FieldA is checked or not. Then, depending if it is checked or not, certain...

Hi Everyone, I'm wondering if it is possible to export certain data fields to specific cells in excel. ie. LastName exports to A3 FirstName exports to C8 DOB exports to H2 and so on... Thanks for your help! Jeff

Here is the code behind the button. The Button is on the Mainform (frmBC2ndParent). Combo173 is on the Subform (frmBC2ndChild). When the button is clicked, it refreshed the data from the query which feeds the Subform, then the fields listed below are supposed to change background colors based...

The Combobox resides on the Subform. I made the changes to the syntax and now I am getting the error: Microsoft Access can't find the field 'frmBC2ndChild' referred to in your expression.