Recent content by osp001

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...

Let's see if this code comes through OK. This is the "On Load" event procedure code for the entire form. Option Compare Database Option Explicit Dim LocationToApply As String Dim StatusToApply As String Private Sub ApplyLocation_MouseDown(Button As Integer, Shift As Integer, X As Single, Y...

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...

Well, shoot. That was easy. Thanks!

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...

Thanks all for the help. I plumb forgot about Windows Movie Maker. Worked like a charm!

Well, I searched for .apf and .apj files, and couldn't find one. What I'm looking for is how to load the website so that I can upload them all at once. I was told there was a way to open the project file, as you describe, but I can't find one- even tried a global search for those file types on...

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...

Zion7> That works great to open up the form, but only to the first entry. The way I have it built from the main page is so that I can enter a given number (AccNum) and go directly to the relevant entry. So, if I want to look at AccNum 1234, I can just enter "1234" and go directly to that entry...

Okay- here's what I'm trying to do. I have a form (frm_main) with an unbound text box (AccessionQuickLookup) that I want to use so I can type in a number (AccNum), and have the relevant information for that number come up in the form frm_edit_seeds_sub3. Is that enough information? :-/ Sorry to...