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!

Register Log in
  • Congratulations derfloh 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. fourofclubs

    Bookmark after submit

    G'day all, Here's what I'm trying to do. I've got a form with a dropdown list on it. Once it is changed, the form submits, and the page is reloaded. I've got a bookmark on a different part of the page that I want to go to after this submit. If anyone knows how to do this, I would be very much...
  2. fourofclubs

    How to display 2 fields in 1 combobox?

    You can do it using the combo box in MS Forms 2.0 Object Library. Make a combo box, change its ColumnCount property to 2, and then add items in code using: dim Index as Integer ComboBox1.AddItem staff_no, Index 'puts the staff_no into column 0 ComboBox1.List(Index, 1) = staff_name 'puts the...
  3. fourofclubs

    Blank Reports

    Well, thanks for all the tips. I found a pretty good solution in a roundabout sort of way. It took some work, and was a bit of a hassle, but I realized I could move the table update to a different module (one that runs a lot sooner), and that eliminated this weird timing thing. Seems to be...
  4. fourofclubs

    Blank Reports

    Alright, I've got a 'solution'. It's really quite terrible, and makes me cringe just to look at it, but it seems to be working. I just stuck a boolean in the report that's true if the report has no data. Then in the module, I just loop through opening and closing the report until it's got some...
  5. fourofclubs

    Blank Reports

    Well I have stepped through the code, and when I do that, I can't see any problem at all. The record is properly added to the table, rstArchive.ID contains the correct value, and the reports all print out fine. It's when I let it run that I see blank reports. If you want the whole code, here it...
  6. fourofclubs

    Blank Reports

    All the code I'm using to update the table and print the report is in the same module. I add a record to the table, update it, and then print the report using: DoCmd.OpenReport "rptLIRTruSpec", acViewNormal, , _ "Nonconformancetbl![TruSpecID] = " & rstArchive![ID] The...
  7. fourofclubs

    Blank Reports

    That's exactly what it sounds like. Great! But shouldn't the update method unlock the record? I'm not quite certain how to make sure it's unlocked. Thanks, Brad.
  8. fourofclubs

    Blank Reports

    Hi, thanks for replying, No, it's not an overflow blank page, the report prints with all the labels and everything, but there isn't any data. This, I would think, would mean that the recordset the report is based on is empty, but I'm sure it's not. This is basically what I'm doing: 1. Add a...
  9. fourofclubs

    Blank Reports

    G'day, I've got a rather odd problem involving printing reports. I'm adding a record to a table and updating it, then trying to print a report based on the new record. Should be simple. However, I seem to be getting a few blank reports mingled in with the proper reports. I've checked out the...
  10. fourofclubs

    printing data reports

    G'day all, I've got a data report built that I really don't want to be printed (big security issues connected to that and all). I'm wondering if there's a way to prevent anyone from printing or saving this report. Any help will of course be greatly appreciated. Thanks, Brad.
  11. fourofclubs

    Adobe Acrobat Automation

    I'm not sure exactly what you want to do, but you could check out the acrobat developer forum on Adobe's website: www.adobeforums.com/cgi-bin/webx
  12. fourofclubs

    Check box question

    Thanks for your help, I've managed to get it working (though I'm sure there has to be a better way). I tried using Private Sub chkClosed_Click() Static bGetOut As Boolean If bGetOut Then Exit Sub bGetOut = True chkClosed = (chkClosed + 1) Mod 3 bGetOut = False End Sub The problem...
  13. fourofclubs

    Check box question

    Hi, thanks for replying. I am aware that I can set the value property to 2 at run-time, but there are certain problems that arise when I click on the check box. I'd like to be able (when the box is clicked on) to cycle through the three values. From what I can tell, when I click on the box...
  14. fourofclubs

    Check box question

    G'day, I'm looking to have a check box on my form that allows you to choose one of three values, (0-unchecked, 1-checked, or 2-grayed). I can set it to grayed initially, but once it is clicked on, it can't be grayed again. Any thoughts? Thanks, Brad.
  15. fourofclubs

    Data filter

    Thank you very much, seems to be working. Brad.
  16. fourofclubs

    Data filter

    I thank you for responding. I beleive I've tried what you're suggesting however. This is the code I'm using. datActivities.Recordset.Filter = "[Project Number] = " _ & datProjects.Recordset![tblMainProject.Project Number] datActivities.Recordset.Requery datActivities.Refresh I've...
  17. fourofclubs

    Data filter

    This should (in theory) be pretty simple, but as of yet, I've had no luck. I'm just trying to filter the records in a data control. I've tried using the filter property of the recordset, but this doesn't seem to do anything (and I haven't found an applyfilter method or anything resembling one...
  18. fourofclubs

    Problem with Adobe ActiveX

    I'm trying to display a pdf on a form using the Adobe ActiveX control (in MSAccess 97). I'm using a check box to control whether the pdf is displayed or not. The code in the click event for the check box is as follows: If [chkShowPDF] Then [PDFframe].src = [PDFName] Else [PDFframe].src...

Part and Inventory Search

Back
Top