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

    Insert formula by VBA gives #NAME!

    Hello folks, I have a problem with formulas that I insert in a worksheet. It appears that there is a #NAME! error that results from that insertion. I checked my formula over and over again, there is no error. And when I go in a cell where a formula was inserted and I press Enter, I see the...
  2. FredGexel

    Add Invoices(Form) and Items(sub-form)

    Hello, I made a form thats used to input invoices and in that form, there's a sub-form containing the items of the invoice to add. How would i do to add items with the invoice_id of my invoice in the Form and not an empty invoice_id. Regards, Fred
  3. FredGexel

    HELPPP ! Add data to 1 table using both form and sub-form.

    Bahhh... forget about this post, i'll just re-analyse it and make 2-3 tables ... *sigh*
  4. FredGexel

    HELPPP ! Add data to 1 table using both form and sub-form.

    Hello ! Here's my problem, I got a table called INVOICE containing all information of an invoice. So if i got 4 items on an INVOICE, i got 4 lines in my table (i know its not really well analysed but i got to deal with what was given to me...). And I'm making a form to INPUT invoices and what i...
  5. FredGexel

    Data connection parameter ?!?

    anybody ?!
  6. FredGexel

    Looping through html input fields ?

    Tks a lot !
  7. FredGexel

    Data connection parameter ?!?

    Hello ! I was wondering if anyone would know how to connect to different tables with the same structure using only the table name as a parameter ? Thanks
  8. FredGexel

    Looping through html input fields ?

    Hello folks, I had a question concerning a form validator. Here's the context: I got a Html form with 7 fields (hr1 , hr2 , ... , hr7) and I want to validate em in only 1 loop. How would you do it ? for(w=0 ; w<7 ; w++) { m = &quot;hr&quot; + w ... somevar = document.form.m.value...
  9. FredGexel

    reload a frame from another one ?!?

    Wow tks ! thats a fast reply :)
  10. FredGexel

    reload a frame from another one ?!?

    Hello folks, I'd like to know if anyone knows how to reload a left frame on the event of a submit in a right frame location.reload will only reload the current frame... i only want to reload the left frame of the browser. Thanks !
  11. FredGexel

    Range date selection with 2 params... not like SQL between ?!?

    OHHHHHH.... No prob, i got it :) Was a stupid mistake ...
  12. FredGexel

    Range date selection with 2 params... not like SQL between ?!?

    Hello C.R. users, I was wondering if anyone knew how come the IN TO Crystal Reports statement wont do like the Between SQL statement. here's my selection: ==================== if IsDate(CStr({?date_from})) = True and IsDate(CStr({?date_to})) = True then {temps.temps_date} in...
  13. FredGexel

    Ranged date selection with 2 params... not like SQL between ?!?

    Any suggestion ? Anybody ?
  14. FredGexel

    prompts &amp; refreshes

    I had the same problem that you have (a text box and not a drop-down list) and i didnt find how to resolve. but if its only because that you dont want to lose whats in your explorer window where you call your report, theres something i could suggest you : --Put that in your <HEAD> tag-- <script...
  15. FredGexel

    How do I declare a variable in Crystal?

    Dont you want to affect that formula to a field or something ? : Sum ({@AvailableBudget}, {tblSubSection.SSName}) / Sum ({@YearlyBudget}, {tblSubSection.SSName}) * 100 Wouldnt it be : FIELD = Sum ({@AvailableBudget}, {tblSubSection.SSName}) / Sum ({@YearlyBudget}, {tblSubSection.SSName}) * 100...
  16. FredGexel

    prompts &amp; refreshes

    Hello ! Here's my suggestion. Go to www.recrystallize.com and download the demo version ! It's the best tool i've seen to put reports on the web. It's a wizard that will help u generate (in less than 3 minutes !) the pages of code needed to take the parameters in a HTML form (not as a prompt in...
  17. FredGexel

    Ranged date selection with 2 params... not like SQL between ?!?

    Hello C.R. users, I was wondering if anyone knew how come the IN TO Crystal Reports statement wont do like the Between SQL statement. here's my selection: ==================== if IsDate(CStr({?date_from})) = True and IsDate(CStr({?date_to})) = True then {temps.temps_date} in...
  18. FredGexel

    1 Parameter, multiple fields... can do ?

    Tks a lot !
  19. FredGexel

    1 Parameter, multiple fields... can do ?

    Hi there folks, I'd like to know if any of you know a way to do what i'm looking for. Here's the pattern. I got an employee table with a first_name field, a last_name field and an ID. Is it possible to make that the parameter is a combinaison of both names (last_name, first_name) w/o...

Part and Inventory Search

Back
Top