Search results

Hi all, I have a query which provides a count of the rows meeting my criteria. I want to call this query from VBA and capture the count. I know that I can create a recordset using this query and check the recordcount of the recordset. But... What I'd like to know is there a quick way to get...

Hi - what I did was a get a free PDF download patch or whatever from Microsoft which allowed me to use the code I posted earlier. I never added a dll (which I believe is a dynamic linked library) which I wouldn't have a clue how to do. Magster

Do you have any unique indexes in your database tables? If so, you may be trying to append new records that will cause duplication and the query will not append new rows. Magster

Hi - the last posting gave the link for the snapshot download from Microsoft. Its been several years since I created a snapshot file, and it was in Access 2003. I found the code that I used just incase someone else wanted to use it. DoCmd.OutputTo acOutputReport, , acFormatSNP, , False I...

Hi, I want to hide a field on my report when it is called from one specific module. I thought that I'd just pass an openarg so I could check the openargs but I can't do that with the code I am using to output the report to PDF - the code is: DoCmd.OutputTo acOutputReport, "rptProjectSheet"...

I'm using 2007 and the following code exports my report to pdf. strFileNameAndPath is populated prior to the call below: DoCmd.OutputTo acOutputReport, "rptProjectSheet", acFormatPDF, strFileNameAndPath Also, I believe that I had to download some info from Microsoft to be able to output to...

Hi all - can anyone tell me why the following code doesn't work? When I open the form that this ribbon code is used in, the Ascending and Descending buttons appear, but they are not available to use. The other two buttons work just fine. Thanks in advance for any suggestions. <customUI...

Thanks! I expected that it would be a very simple setting!

Hi all, I can successfully send a Lotus Notes email from VBA, however I can't find any samples of how to indicate that I want a return receipt. Does anyone know how to set that? Thanks in advance!!!

I having it working now.... I added an unbound check box and in the control source I put: =IIf(IsNull([memDetailNotes]),False,True); I set enabled to false and locked to yes. thanks!

Thanks for the reply - I looked at the example you sent and I don't see the connection because the check field on the form is a field in the table. There must be another way to do this... am I missing your point?

Thanks for your reply - and that does work great... however, my question is centered more on how to accomplish this on a continuous form. The continuous form displays a check (in your example) on every detail line as long as one of the detail line has something in the memo. There must be a...

Hi all, I wanted an easy visual way to let my user know if their memo field has any data in it without clicking a button. I created a single form with a button that calls a modal dialog form where I allow the users to edit a memo field which is contained in the underlying query of the single...

Thank you both - I have it now. I couldn't get it to work because I forgot that the wizard was on.

Hello all, I'd like to have a tabbed form to show customers on one tab, orders for a selected customer on the next tab, and order details items for the selected order on a third tab. Setting up the first two tabs was easy; I dragged the continuous form onto the tab and linked the Master and...

Thank you! It workds great! I had to do a bit of renaming because of combo boxes in the form and matching text boxes in the report but that was minor. I really appreciate that you took the time to explain... you saved me a lot of time and I can use this concept in a lot of places! :)

I asked a similar question today and I was able to solve my problem and it is under VBA questions and here is the title of my question: Open a report using a form's recordsetclone as the report data source This will work for you... I am still trying to find out how to do this using a...

To print info about any object within Access you click on database documenter in the ribbon under Database Tools. You'll see all of the object types. You can limit by selecting the options. If you want a picture of the design view of a form, the only way I know how to do that is a print...

Well, through a bit more digging, I was able to call the report and use the form's recordsetclone from the report as follows: from the form in the button on-click event I call the report: DoCmd.OpenReport "listNonHREmployees", acViewPreview In the report module itself, I set the recordsource...

Hi all, I want to open a report using an open form's recordsetclone. I know how to get the recordsetclone in VBA - I just don't know how to open the report with the form's data. I am assuming that I either pass the recordset to the report or reference the open form's recordsetclone from the...