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 Rhinorhino 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. burcher

    DCount Update

    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...
  2. burcher

    DCount Update

    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...
  3. burcher

    Age asof June 30, ???? Calculation

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

    Age asof June 30, ???? Calculation

    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...
  5. burcher

    Age asof June 30, ???? Calculation

    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...
  6. burcher

    Age asof June 30, ???? Calculation

    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())...
  7. burcher

    Form's OrderBy to Report.

    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...
  8. burcher

    Form's OrderBy to Report.

    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...
  9. burcher

    Form's OrderBy to Report.

    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...
  10. burcher

    Create an Option Box or Validation?

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

    Just a Basic filter that's All

    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.
  12. burcher

    Just a Basic filter that's All

    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...
  13. burcher

    Create an Option Box or Validation?

    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...
  14. burcher

    Setting Global Date(s)

    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.
  15. burcher

    Setting Global Date(s)

    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"...
  16. burcher

    Setting Global Date(s)

    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...
  17. burcher

    Setting Global Date(s)

    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...
  18. burcher

    Filter or Global Variable?

    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...
  19. burcher

    Filter or Global Variable?

    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...
  20. burcher

    Problem Updating Count from Table 1 to Table 1

    That worked perfect. I really appreciate your help.

Part and Inventory Search

Back
Top