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!

  • Congratulations strongm 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. southbean

    Returns records for the previous year up to the previous Saturday

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

    Returns records for the previous year up to the previous Saturday

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

    Trouble with an Append query WHEREE clause

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

    Trouble with an Append query WHEREE clause

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

    Trouble with an Append query WHEREE clause

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

    CASE in Stored Proc

    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
  7. southbean

    CASE in Stored Proc

    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'...
  8. southbean

    Can't Change The Server Name in Parameter

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

    Can't Change The Server Name in Parameter

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

    Pass values from one page/form to another

    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
  11. southbean

    Pass values from one page/form to another

    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"...
  12. southbean

    Pass values from one page/form to another

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

    Pass values from one page/form to another

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

    Pass values from one page/form to another

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

    Pass values from one page/form to another

    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...
  16. southbean

    Pass values from one page/form to another

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

    Pass values from one page/form to another

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

    IIf syntax for Null and Return All

    Bingo! Thanks, dhookom! - tl
  19. southbean

    IIf syntax for Null and Return All

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

    Listbox Filter

    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

Part and Inventory Search

Back
Top