Search results for query: *

Is there any way to do this? I would like to be able to show a single-page .pdf in my Access reports. I would like to be able to refer to it (not actually store the .pdf in the database) so that the report will generate, and insert the .pdf as one of the pages. Haven't found how to do this...

I'm trying to get a query to display the average age of a product for which I have a manufacturing date (fill_date) and a disposal date (termination_date). It's been a while since I've worked with Access, so I forget how to subtract one from the other in a query (in design view, if possible) so...

Don't know VBA, so I apologize for asking what has to be a stupid question. I have a query set up in the following manner: UPDATE tbl_containers SET tbl_containers.location = "" WHERE (((tbl_containers.location)="S001")); What I'd like to do is have a form in which there is a field that I can...

I am trying to construct a form to change the inventory status of items on the shelves. There are three fields; from left to right: Item number Location Status Under "location" and "status" fields, there are check boxes; when I enter a code into either or both of these fields, I can...

Go easy on me. I don't know much programming. I'm trying to change a status within a form in a very straightforward manner. Using a text box, I want to be able to enter a number to change the status of a "yes/no" field. In other words, when I enter "1234" into the text box (for...

I've been trying to add some new fields to a table; the database is split into a front end and a back end, and it's either that or the number of linked tables that has the main table locked. Someone told me about a trick in which a query can be used to temporarily unlock the table, and allow...

I should know how to do this, but I'm lost. I'm trying to get the focus to shift to a certain field after selecting from a "yes/no" data type. Specifically, I would like the cursor to switch to a given field after selecting "yes" or "no"- the same field, regardless of which selection is made...

Someone prepared a Homesite website for me, and then sent it by email. I uncompressed it, and now have no idea how to load it. He said there's a "bulk loader" feature, but all I can do is open one page at a time. With 300+ web pages, that isn't going to cut it. Anyone know how I can open up the...

I have a video I want to show in "PowerPoint." Unfortunately, it's too dark. When I use the image adjustment widget in PowerPoint, the first scene is exactly where it needs to be- but the rest of the video is way too dark. Is there any way to change this in PowerPoint or, if not, how can I...

Go easy on me- I barely know any VB at all! I'm trying to get a form to look up the information so that when I enter an item number, it'll go to another form and give me the information relevant to that number. In short, it locks up on the "itemdata" part of the indicated line with a compiling...

Still pretty new to Access, so be gentle with me! I have a table that has an item number, a quantity "in," a quantity "out," and a date column. The date column is new. I'm trying to figure out a way to change the "date" field for each line as the quantity "in" is incremented. In other words...

Is there any way to get a two-page spread view in Word? Or am I doomed to use Quark or InDesign? Thanks!

I think I may have painted myself into a corner. I am using linked tables for my database, and now that I need to make some changes, Access won't let me. Specifically, I need to change one field in the main table from a "number" to a "text." Either that, or add a completely new text field, and...

I have a relatively straightforward task I'd like to do, and can't figure out how to do it. Programming isn't my forte, so- bear with me. Let's say I have a table with two columns. One is for item numbers, and another is for their status (expressed as a number). So, it looks like this: Item...

I need some help in doing a one-time-only inventory change to my database. I'd like to create a form that, when a given number is entered, a field with a "yes/no" data type associated with it is changed from "no" to "yes." In other words, when number "1234" (container:table_containers) is...

I've been trying to figure out how to do this for a couple of days now, and thought I might ask if what I want is even do-able. I use Access to generate a list of products; the report generates an HTML table, which is then manually uploaded. What I would like to do is have Access generate the...

I've been trying to get a query to work so that I can produce a running total by month of products that have been purchased. In order to do so, I use [tbl_items]![quantity]*[tbl_items]![unit_price] to get the line total. I've yet to figure out how to get a total by order...

I've been trying to use the MS Internet Transfer Control, but I get an error when I do- "You don't have the license required to use this ActiveX control." It then suggests I contact the company that provides it. I've been up and down the MS help pages, and tried to find how to do this, but am...

I've been puzzling over this for a while- I can't figure out how to do it, so some help would be much appreciated! I have a certain set of items, and each has a date associated with them. Some dates have many items associated with them, some dates have none. Each item has only one date...

I need some help figuring out how to take my results- a query in .html format- and uploading them to my website. Right now, I dump the finished product to a disk, move it to another computer where I have my FTP program, and then upload it manually. Is there any way to arrange for Access to...