Search results for query: *

You are correct t6id is the common field in both tables. But when I used the sql it err'd saying you must use an updatable query. Is the select count the way you count unique records? the reason I ask is cause after I count the unique number of users, I then have to count all the encounter...

I have a table that has multiple pID (patient Numbers)in a table called [Voucher Table 6 Codes], I have another table called [Voucher Table 6 Codes UDS]. I am trying to count the number of unique pID's in the first table and update the [...UDS] table with the number of pID's in a field called...

You the man Bob, Worked perfect. I appreciate your help

Bob, I was getting a sytax error, so I added another ) to the end of it and it ran the update, but now it is saying that a person born on 9/8/1969 is -139 years old and a person born on 5/30/1969 is also -139 years old, so not only is the age incorrect it is not using the 6/30 as the age os of...

Bob, I've tried it both ways you have above and I keep getting a syntax error. My situation is more closely suited towards your 2nd code since I have them enter the year like 2003 or 2004 in the unbound text box [UDSyr] on the [UDS Report Form], then they push a setup button which uses this...

I am trying to calculate a persons age as of June 30, [UDSyr]. The [UDSyr] field is entered on the report form in an unbound text box and is used by several other queries. My age calulation was: UPDATE [UDS Age & Gender Table] SET [UDS Age & Gender Table].Age = DateDiff("yyyy",[DOB],Date())...

Right, I have a button to run the report on the form. I have them click in the field that they wish to sort or filter, then when they have the information the way they want it, they click the run report button (on the form)and it pulls up the report using the parameters (filter & Sort) that...

Yeah, I tried that also, but it still isn't recognizing the OrderBy parameter. But I set it up again so I could let you look at it and see if I'm just missing something. Private Sub Command47_Click() On Error GoTo Err_Command47_Click Dim stDocName As String stDocName = "Select, Patient...

I am trying to send the Form's Orderby and Filter Parameter to a report. I have got the Filter parameter to pass to the report, but I can't figure out how to pass the OrderBy parameter. Here's what I have so far: Private Sub Command47_Click() On Error GoTo Err_Command47_Click Dim...

Does anyone know if it is possible to use a validation rule or option box? or will it require VB coding?

Actually, I got it to work now, so thanks anyways. I'll hang on to this bit of code for a while, it's a good thing to know.

Hey Roy, I am trying to do the same thing that tracy1234 is trying to do (Let them use access filter on the form, then be able to print those results into a report) I modified the opening statement as follows: Private Sub Command47_Click() On Error GoTo Err_Command47_Click Dim stDocName...

I have a continous form that has 3 fields, Begining Date, Ending Date, and a check box for selected. I have a global function (thanks to Bob Scriver) that will read what the beginDate and EndDate are from the TimeTbl and filter different forms. Is there a way to make this form act like an...

Bob, Sorry it's taken so long for me to get back, other duties prevailed, but what you gave me works perfectly and I really appreciate your help. And Thanks PHV for reviewing this msg as well. I did catch that and had already fixed it, but it's nice to know others are watching too.

I have copied and pasted the Global code in your first response under Module 2. I also modified the sql to what you have above, but it gives me a Complile Error:syntax error and takes me to the module for debugging. The "Function BeginDate() As Date" is highlighted in yellow and the "End Date"...

Bob, I need for the query to return 0 if the voucher date is not within the current calendar year, The following Sql is executing that perfectly, so how do i subsitute the info you gave me above so that in my query I can remove the Between #date# And #date# and have it look it up? below is my...

I have a table called TimeTbl that has 3 fields: BegDate, EndDate, SelectDate. BegDate has the beginning date of the calendar year, EndDate has the Ending Date of the Calendar Year and The SelectDate is a Yes/No Field to specify which calendar year you are working in. I would like to make a...

I took a look at http://www.tek-tips.com/faqs.cfm?spid=702&sfid=3619 and that is a great tool for report flexibility, but I don't see any way to make it work with a subform? See when you open the form, the subform has 3 columns that looks kinda like this: Pharmacy Dental...

Our company has a program that is funded by the Government, that basically will pay upto $200 towards Health care, $75 towards Dental care, and $75 towards Rx, per year and per Migrant farmworker. The company has a fiscal year from 7/01 to 6/30, which each 7/01 each migrant farmworker is then...

That worked perfect. I really appreciate your help.