Recent content by ShannonSkipper

Which version of Norton Firewall are you running?

If you have Norton Firewall 2005 the following should establish appropriate firewall rules... Courtesy of Norton: How to scan for Internet-enabled programs and apply firewall rules using the interface: Before running a program scan, it is a good idea to remove all existing program rules. This...

Yes, the underlying table of frmActionNotesFull has a Foreign Key referending the Primary Key of frmDemographics.

Great idea. But how do you get the 1/4 screen memo to show the correct record? Do you use WhereCriteria? How? Thanks, A very lost noob named Shannon

In my form frmDemographics there is a subform named frmActionNotes. For each record in frmDemographics there is an action note. The subform within the form works well, but I need to be able to open the the content of the subform in a new window. I am able to open a form (named...

I have a query that calls up the following module:Public Function SendSubscription(StartMonth As Integer, Frequency As String, CheckMonth As Integer) As Boolean Dim F As Integer Select Case Frequency Case "Monthly" F = 1 Case "Quarterly" F = 3...

The Record Source property does point to my query - but instead of bringing up the form to enter parameters it just prompts me for the parameters one at a time. Any way to get the report to open the form to prompt for the parameters automatically? Thanks, Shannon

I have a form that gives the parameters to a paraemeter query. What I want to do is make a report from the results of the parameter query. How do I tell the report that I want it to use the results of the query? Thanks, Shannon

Resolved the final problem - Thank you all so much for your help!!!

Works perfectly - Thanks!!!

You only need one table. Build a form with a combo box so you can choose which county (or counties) from the list. Then design a parameter query to read the criteria from the information on the combo box. A detailed tutorial on how to do this is available at...

When I put a Date in a field called sDate I want a field called StartMonth to automatically set its value to the coresponding Month as an Integer. So if the sDate value is 9/12/1999 I need the StartDate value to be set to 9. Should I use an "on lost focus" event procedure? Any ideas? Thanks...

Thanks so much guys - it works! I am thrilled! The only thing that isn't working perfectly is it is prompting me for the parameter value of the StartMonth instead of getting it from the StartMonth Expression in the query that pulls the Month as an Integer from the Date field (now named sDate...

P.S. - I think I wrote my query wrong. I put in the expression, "Month([Date]) AS StartMonth" and then refer to that expression in the SQL statement, "WHERE SendSubscription([StartMonth],[Frequency])=True". Why is it asking me to enter a parameter value-isn't it supposed to be getting that...

After changing "date" to "VBA.Date" when I run the query a window labeled "Enter Parameter Query" pops up like before asking for the StartMonth. When I put a number in and hit enter I get an error window that reads: "data type mismatch in criteria expression". Thanks for your help, -Shannon