Recent content by sysr

Thanks you so much, it works great!!!

I don't use Access much and need a little help with a query. I have a Clients query with a list of IDs (identifying the client) and a Report query with a list of IDs (same ID# as client ID, and there may be some IDs that are listed several times). I want to see which Clients IDs are not in the...

Thank you so much. It looks like it works perfectly, I will run some tests.

I have Query A and Query B. In Query A, I have a list of people with Action Plans. Andy - Action Plan Bob - Action Plan Charles - Action Plan Doug - Action Plan In Query B, I have a list of all the Interventions. Andy - Short Intervention Bob - Short Intervention Bob - Long Intervention Doug...

I would like the appropriate option to be selected based on the current date. I was thinking that there would be an easy way to do this, I can't find it. IF DATE >= &quot;April 1&quot; AND <= &quot;June 30&quot; THEN ???(Option 1 would be defaulted) ELSEIF DATE >= &quot;July 1&quot; AND <=...

I would like the appropriate option to be selected based on the current date. I was thinking that there would be an easy way to do this, I can't find it. IF DATE >= &quot;April 1&quot; AND <= &quot;June 30&quot; THEN ???(Option 1 would be defaulted) ELSEIF DATE >= &quot;July 1&quot; AND <=...

The following code works great when there are records in the database, but when there are NO records I get an Exception error that I can't seem to fix. Any help would be greatly appreciated. 10 sqlStringa = &quot;SELECT OrganizationID FROM RegionalContracts WHERE Region=&quot; & &quot;'&quot; &...

Thank you, it was the &quot;&quot;, darn things!

How can I ask if a Recordset has data? (Also, should I be saying &quot;populated&quot;?) 10 sqlStringa = &quot;SELECT OrganizationID FROM RegionalContracts WHERE Region=&quot; & &quot;'&quot; & strSelectedRegion & &quot;'&quot; 20 Set ReportRS = Con.Execute (sqlStringa) 30 IF...

(I am using this in an ASP page) I am getting a recordset in line 10 and 20, but then I want to use the data in that recordset to create another recordset, is this possible? Also should I be using the SUM function in lines 60 and 70. (2 Tables: RegionalContracts and Reporting) 10 sqlStringa...

Thank you very much, you have actually cleared up a lot for me in your explanation. It sounds like the recordset returned is actually a mini-database (or set of records) taken from the big database and put in memory. I must then pull what I want out of this mini database (set of records - that...

I am developing an ASP page that is connected to an ACCESS database. I need to get a maximum value for a number field, add 1 to it and use that number as a key value to start the next record. 10 Set Con = Server.CreateObject(&quot;ADODB.Connection&quot;) 20 Con.Open &quot;accessDSN&quot; 30...

I am developing an ASP page that is connected to an ACCESS database. I need to get a maximum value for a number field, add 1 to it and use that number as a key value to start the next record. 10 Set Con = Server.CreateObject(&quot;ADODB.Connection&quot;) 20 Con.Open &quot;accessDSN&quot; 30...

I have tried: <%strName=RS(&quot;OrganizationName&quot;)%> <a href=&quot;&quot;&quot; & &quot;Report.asp?Quarter=1&Name=&quot; & strName & &quot;&quot;&quot;>%></a> Thank you for any help!

How do you pass a variable in a link? strName will not pass it's value with the following code: <%strName=RS(&quot;OrganizationName&quot;)%> <a href=Report.asp?Quarter=1&Name=strName>%></a> Thank you for any help!