Search results

Hmmm...WHere are you holding the PersonID fields for the people selected to be in the mail group. If you save their PersonIDs into a recordset then you can append to your tblMailGroupMembers by using the intNewGroupID as a constant variable while using the "rst.movenext" in your recordset to...

It's just a round about way of doing what I already posted. There is no reason that you can't use that method instaead, but I don't think it gives you everything that you wanted. It would look like this: Dim Answer As String Answer = MsgBox("Every debt must have a debtor and every debtor...

I tried it again with the following as a test: If MsgBox("Is this working?", vbYesNo, "Question") = vbYes Then MsgBox "This works so I don't know what the issue is", vbExclamation, "Answer" Else MsgBox "This didn't work...or did it", vbCritical, "Wrong Answer" End If Worked fine for me. Can...

If Msgbox("Every debt must have a debtor and every debtor must have a debt.", vbYesNo, "Question") = vbYes Then Msgbox "You selected the correct answer.", vbExclamation, "Correct Answer" Else MsgBox "That is incorrect.", vbExclamation, "Incorrent Answer" End If

Just like any If statement, you can use the ELSE option. So if vbYes is not selected then the only other option is vbNo. So: If Msgbox("Every debt must have a debtor and every debtor must have a debt.", vbYesNo) = vbYes Then Msgbox "You selected the correct answer." Else MsgBox "That is...

Stupid question from me... :) Is [Response] the Criteria in your Query for a specific field? Or are you trying to pass 63 back to the Response field? If Response is a local variable in your Sub, then it's not going to pass anything into your query...it's going to hold the variable in the...

I see that the textboxes are in sets of three, but how many unbound textboxes do you have on that form? Do you know how many records will be in the recordset? Have you debugged and stepped through the process to see how the records on your form are changing?

Trying to avoid field by field approach That's why I was asking whether I could just dump an entire query into a bookmark. If you can pass fields, then why can I not pass an object. I mean..I can publish individually to Word, so why can't I publish my Queries into a Word template at the...

I don't know if this will work, but it should at least give you something to think about. First off...I don't know why your first statement says that you're checking to find the closest date field, [DepDate], using a text field called [LowWater]. You need to compare fields of the same type...

Is SSN being captured as a text field or a number? Also, you might want to check the number of """ you have on that second criteria statement. Numbers do not require " quotes and strings or text can be denoted with '" & StrSQL3 = "SELECT * FROM EnrollmentInformationTable " & _ "WHERE...

Okay, I can't seem to figure out how to pull this off and I've used publish to Word and Mail Merge before, but neither seem to provide a good answer... The issue is getting 32 Data Rollup Queries, which provides sums and counts of various different types of assets, into the same word document...

Wow, why are you outputting into a table and not simply running a query to find the desired information for reporting or form creation? I just ask this because if the data changes and you're constantly having to updated the "output table" or even worse...recreate it...the database may been to...

Thanks! Looks like some of the stuff that's posted out here, but with a few additional bells and whistles. I'm actually trying to dump entire recordsets at bookmark points. I can't imagine writing the code to individually populate 27-28 different recordsets (comprised of queries). Granted...

Have you edited any of the field names in the table that feeds that form. Does the "PrintFlag" field still exist. Because your recordsetclone is looping through to change all of the "PrintFlag" fields in the recordset to True. Although I have to admit that it seems strange to see rs!PrintFlag...

Hmmm would be nice, but when I click on your link..the sample code jumps from 1 to 4 to 10...if you've downloaded it, maybe you could share it here. ;)

It appears to be a hierarchy CAR has an ENGINE ENGINE has PISTONS CAR has a WHEEL ASSEMBLY WHEEL ASSEMBLY has TIRES, WHEEL, STUDS, NUTS So your tables should be established as such and you can just pass your primary key from the parent table to the child table. This will eliminate having to...

Are you saying that it is working only for the current record? Are you trying to loop through something because I don't see anything being looped through. Maybe what you need to do is declare the two parameters and then use a recordset to tests your CASE conditions for determining the...

DoCmd.RepaintObject for my form didn't seem to take, but the form.repaint worked like a charm. I guess I always used to use refresh to update everything...I'd never used repaint before, but it works great. Thanks! :)

Does your Query actually say [ScreenDateParm] in the Criteria or WHERE statement? Meaning that even if your form is filled out, the query does not execute properly? Your Query Criteria or WHERE statement should read [Forms]![frmEnterNS]![ScreenDateID] and therefore your declaration for the...

Bel, Why would you want then to update via a text file? Data validation will be risked and that will likely increase your rate or errors. I would suggesting finding another way to allow updated, even if it's through excel and you use data validation or macros to check the data types and...