Search results for query: *

Hello, Thank you BOTH for your responses! Lbass, I tried your solution and it worked GREAT! Thanks a lot! - LM

Hello All, I'm trying to create a formula that returns records for the previous year up to the previous Saturday. I have two date formulas: StartDate: CurrentDate - 366 EndDate: {table1.DateField} - (dayofweek({table1.DateField},crSaturday)-1) In my record selection formula I have this...

Golom, Sir, I am in your debt. That worked perfectly! Thank you very much!!! - lm

boblarson & Golom, Thank you for your replies! I've tried both and have not had success. There are two records that meet the criteria: Record #1: A new record. Record #2: A record that has a greater DonateDate than the Max date of the matching (EmpID) record in the table. However, using...

Hello All, I’m having trouble with an Append query. Specifically in the WHERE clause. Every week I need to append records to Table01 from Table02. Table02 is a linked table from another DB that contains records of employee donations. Table01 tracks the donations in my Access DB. To eliminate...

Hello RiverGuy, Thank you for your reply! I now get data returned! Excellent! However, I only get data for 'Value1', even if I select 'Value2'. Any thoughts? Again, thank you very much for your reply! - tl

Hello All, I’ve been hacking away at a stored procedure for a while with no success. Time to ask the experts. I have a form that uses this query to pull two values from a string. User chooses one value. SELECT DISTINCT Field = CASE WHEN SUBSTRING(Field, 1, 2) IN ('A1'...

RSGeek, Thank you for your reply. I have tried that. However, it did not resolve the issue. I uploaded the same report twice (modifying the names: Report1_PROD, Report1_TEST) with one using PROD as a data source the other usein TEST as the data source. Same result. In fact, the grayed-out...

Hello All, I've uploaded several reports to my BOE (11.5) via the CMC. No problem there. The reports were developed to use either a TEST or PROD database (SQL Server 2005). Most of the reports use dynamic parameters. However, when I click on the parameter value link to select new parameters...

Hello Foxbox, Brilliant! This dolt finally gets it! Now I just need to carefully work through implementing it on my pages. Again, I can't thank you enough for patiently walking me through this. I really learned a lot! Thanks again! - tl

Hi Foxbox, Thank you for your reply! Unfortunately, that sounds like it's a little over my head. I was looking at Hidden Inputs and wondering if that would work for this issue. <input type="hidden" name="last_name" value="<% response.write last_name %>"> <input type="hidden"...

Hello Foxbox, Thank you very much! That worked! I now have the value passing from Form1.asp to Form2.asp. However, that has presented me with another issue. I'm using Response.Write(Request.QueryString("unique_id")) in a form in Form2.asp to display the value passed from Form1.asp. On that...

Hello Foxbox, Thanks very much for your reply!!! I think you've put me on the right track! And, I'm getting close! However, I'm getting an error message: ADODB.Recordset error '800a0cc1' Item cannot be found in the collection corresponding to the requested name or ordinal. I did some...

Hi foxbox, Thank you again for your reply! This does not have to be a dropdown (SELECT) list. If I could display query in a table that would be fine with me. Anything that works! In fact, would I be able to display results in a table and have the "unique_id" be a hyperlink? Would that pass...

Hi BigRed1212 & foxbox, Thank you BOTH for your replies!!! I tried your suggestion foxbox but realized that I can not use the 'Post' because there are too many records (over 100,000) and the page just times out trying to load. I have to use the 'Get' method. You are right, BigRed1212, it...

Hello foxbox, Thank you very much for your reply! However, I'm not that good with ASP so forgive me for having some difficulty understanding it. What my 'Form1.asp' does is populate a dropdown box with values %LIKE% what is typed in the txtSearch textbox. I'm not sure what Form2.asp does in...

Hello All, I’m struggling to find a way to pass data from one page to another. The code to my input form is below. This works fine. <script type="text/javascript"> function GoToForm2() { parent.location = 'Form2.asp' } </script> <Form action="Form1.asp" method="get"> <p>...

Bingo! Thanks, dhookom! - tl

Hello All, It seems simple enough but I can’t seem to get the syntax to work. This is what I’m trying to do: I have a form with a text field in which a user can either leave blank or enter a number. This will be used in a query criteria. If left blank return all records. If populated, then...

Yeah, I thought it might come to that. Not sure if I am up for that level of coding. My ASP is weak as it is. I tried to craft an 'OnClick' event using a button/icon. But I was not successful. Is that the only way? Thanks again for all your help! -tl