Search results

Is there anyway to auto populate one field in a form with data from the last record?

I have spent many hours on a report and don't want to start over, so.... The report is table-based and a user wants one more field added. Sounds simple, right? I have a query that returns the value I need for the new field. How do I add it?

I appreciate your comments and I plan on going back to redesign some items after I get through this first stage. About the code? I understand everything until it gets to the Nz, Forms, Form4, etc. It looks to me like it is looking for a specific field in a form. What I want it to do is look at...

I need to add a number to my inventory table based on a query. I want to add quantity_received from one table to instock in another table. There will already be a number in the instock field. What sort of query should I use. I already have a query to return the value I want, I just don't know...

I guess I'm having an "idiot" day. I trying to enter your suggestions into my macro where the action is to output to a pdf file. It asks for output filename. This is where I'm entering your suggestions. Is this the proper way or am I way off?

I am using Access 2007, but I'm not quite sure how to do the string. The query name is POQuery and the field with the number I want as the pdf document name is Expr1. Can you help me out?

I have set up a macro that among other things outputs a report into PDF format. I set it up to automatically go to the correct directory where I could also put in a file name. Is it possible to have the file named automatically from a field in the report? Specifically I want the PDF file to be...

I created a report based on a query. The creation process goes fine and I am able to run the report, but when I go back in to make design changes, Access crashes. I started from scratch and recreated the report with the same results. Below are the "details" of the crash: Problem signature...

Thank you for your help. It worked just like it is supposed to.

I have created a report that will act as a purchase order. I want to have a field that will act as a point to put a reference number. This number does not need to be stored anywhere. One criteria for the query that the report is based on is vendor name. When you run thew query or report, it...

I have a query that returns all the data I need for a report. PO data is stored in Table1. One of the fields in Table1 is VendorName. The address and account info for that vendor is stored in Table2 along with the vendor name as stored in Table1. How do I get the address, city, state, zip and...

Yes, I got the switchboard to work by editing the table. The switchboard manager still isn't working for some reason, but editing the table is easy enough.

For some reason the dates and times stopped showing up in my reports. They are displayed as #Name?. The reports have =Date() and =Time() as I believe they always have. Not sure what changed to screw things up. Any ideas?

As I said before, for some reason my switchboard manager isn't working. What is the command to run a macro? "1" is open a from in add mode. "4" is run a report. What is the one to run a macro?

For some reason, my switchboard manager isn't working. Not really a problem because I can edit the table. I need a list of commands such as "4" opens a report and "1" opens a form in add mode. What is the command to run an append query?

I'm not replacing a table, I'm adding a new one.

I don't see an option to delete links in the linked table manager. I'm using Access 2007.

I have created a new table in the backend of my database. How do I link it to the front end? Did I do this the right way or is there a better way?

I stand corrected. The category it uses in the cell formatting is "General". When 12-2896 is entered into the cell, the formatting changes to "Custom" with a date format. Why?

I am using Excel 2007 and am having trouble with certain numbers. The cell formatting is set to general number. When I type in 12-2896 (part number), it gets changed to Jan96. When I check the formatting, it has changed itself to a custom number into a date format. It only does this with a few...