Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. osp001

    Putting .pdfs in an Access report

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

    Really simple query statistics question

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

    Basic question on using a form to control a query

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

    Tricky form problem- "freezing" fields

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

    Tricky form problem- "freezing" fields

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

    Simple way to make changes using a form

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

    Adding new fields to a locked table

    Well, shoot. That was easy. Thanks!
  8. osp001

    Adding new fields to a locked table

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

    Changing focus with button press

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

    Lightening video in PowerPoint presentation

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

    Help loading Homesite website

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

    Help loading Homesite website

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

    Lightening video in PowerPoint presentation

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

    Can't get look-up to work!

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

    Can't get look-up to work!

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

    Can't get look-up to work!

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

    Date stamp

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

    Word: Two-page spread option?

    I'm using Word 2002, and the only options I'm getting in the "Zoom" tab are 500%, 200%, 150%, 100%, 75%, 50%, 25%, 10%, and "Page Width." Am I missing something, or does Word 2002 not have this option?
  19. osp001

    Word: Two-page spread option?

    Sorry- I've been a bit spoiled, using Quark. The net upshot is that Quark allows one to view two pages at once- the left-hand page (even number page) and right-hand page (odd number page) at the same time. Scroll down, and get the next spread. Is there any way to do this in Word, or am I just...
  20. osp001

    Word: Two-page spread option?

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

Part and Inventory Search

Back
Top