Search results for query: *

I want to be able to send an Access report to a printer that automatically attaches and Acrobat PDF to the end of the report. In this simple example, I have a form letter that I want to generate from Access and have a 2-page PDF go with it as one job so our printer/stapler will treat it as...

This may seem like a weird scenario, but here it goes. I have a one-to-many relationship with two tables, where there may, on occasion, be no records in the many, and I want to pick up on that circumstance and print a seperate report for the user to print a report (actually a hand-fill-in form)...

This is probably a really stupid question, but I want to commit values to a table for a record that is already partially populated, without using a form and VBA code only. I have no problems coming up with the values I want, but without using a form to bring focus to the record I want to...

I've worked with forms and creating coded links to picture files (jpegs), (rather than bloating my db with OLE objects), and it works pretty well, however, I'm not sure how to print those linked pictures in a report?? Namely, the problem is, that there is no place to trigger code to update the...

Is there a quick and dirty way to print multiple copies of the same report without using a code counter (do/while)? What I'd like to do is have a field on a form with a "number of copies" to be used to print that many copies of the report.

I have a report that I want to be able to change the layout via code, from data supplied from a table. I'm trying to change the top/left positing of the report fields on the fly to meet the demands specified in a parameter table. It doesn't appear there are any field positioning controls that...

I have a report that I want to be able to change the layout via code, from data supplied from a table. I'm trying to change the top/left positing of the report fields on the fly to meet the demands specified in a parameter table. It doesn't appear there are any field positioning controls that...

Is it possible to incorporate a field lookup in a SQL select statement? What I'm trying to do is have a select query return the results from a field name that is specified in a form. To make matters slightly more complicated, I'm only looking up the last digit (number) for the fieldname: So...

I understand that VBA code will not convert back very well (since 2000 has an expanded VBA dll libary). I have created the database (including VBA code) in 2000 and need to convert back to 97 for users that are only using Access 97. Is there a way to enhance the 97 VBA dlls so that the VBA2000...

I'm trying to use FormX to lookup possible values in FormY's recordset. Form X uses a subform with a "Like" parameter query to bring up all the possible records and then allow user to select value they want and have FormY go to that record. To further explain, FormY contains a...

What would be the easiest way of having a multiple column layout of detail within a standard formatted report? To explain, I want to have a full width report header and footer, but I want to display data (detail) within 3 columns. I know how to do this for things like labels (page...

This is probably a pretty simple question: I have written code that checks for missing records for days in the month (there SHOULD be a record for every day of the month) At this point it concantenates a variable string and then returns that result via a msgbox. What I want to ultimately do...

Is there a quick and dirty way to select a record on a form from the value selected in a combo-box within that form? The combo box is based on rowsource select of the same table.

I know how to delete a table in a macro, but how would you do it with code? I would assume you would use "DoCmd.RunCommand acCmdDelete", but how would this be syntaxed to kill a table?

I have no idea why this is happening. I created a new form and brought in the same bound controls (form based on query) and used the sum() to total records across form's recordset and it works fine. For some reason, it has gone buggy in a form that I've already developed. It is NOT a...

I know MS's approach to this subject in NWIND and I'm hoping there is a much simpler option to do this. I simply want a page subtotal (not running) to sum the values on any given page. I have no groups (as it is a single-linear report with no breakable points). The only definitive aspect, is...

In Access 2000, I'm trying to create an update query based on another selection query that is, in turn, based on a ODBC-linked SQL server table. The problem is, that I also need to sum a quantity field before updating my target table. As I re-discovered (deja-vu), you can't base an update...

Can a report object be used for a parameter criteria in a query? I know that a form can be, using the [Forms]![FormName]![Field] In this instance, it would take on the value of "field" for the current, active form value and use it as criteria for the query...

I'm trying to lookup a value based on more than one criteria in a report. Is there a way to do this with the DLookUp function? If not, is there a way to pass the current page value of a report back to a parameter query that would filter based on more than one field's criteria?

Let's say I have a report that I want to limit to a specific item (so that I'm not printing an entire recordset), but I want the calculated fields to look at the entire recordset for their calculation. The example is that I want to print a Sales Report for June of 2001, and I want to be able to...