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...
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...
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...
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...
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...
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...
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.
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...
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...
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.
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...
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...
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.
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.