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 derfloh 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. LittleMan22

    Merging the value from one query into another...

    In other words this is what I want to do: I need to use the value that is retrieved from one query in another query. Here's the first query: query1 = &quot;SELECT * FROM AllBands WHERE RateInfoID=2 AND Plan=&quot;&Form_Plan&&quot; AND MinAmount <= &quot;&Form_Amount&&quot; AND MaxAmount >...
  2. LittleMan22

    Merging the value from one query into another...

    I have a form on a web page that transfers values to another page to query an Access database. The first query uses form fields and returns a value called 'band' from the AllBand table (see below): <% Option Explicit %> <html> <head> <title>Bands</title> </head> <body> <h2>Quick...
  3. LittleMan22

    Cell Intersections and the web

    Hi all, I need some help with calling a value from a database on the web. I have a database called TPG stored in the fpdb folder on my web. I also have a page (www.presidentsgroup.ca/quickquote2.asp) where the user will have to enter information, and based on this information there will need...
  4. LittleMan22

    Access linked Website

    I have a question for you guys then... How do you make buttons in FrontPage that when you hover over them (or click on them) they open a subset of choices. Kind of like the programs window that appears when you press 'start' in the bottom left corner of your windows desktop.
  5. LittleMan22

    Access linked Website

    Currently we have an Access database full of client info. As it stands right now when a client applies for insurance we send them out the application and when they send it back we enter the information manually into our program. We've begun to devise it such that we can ask the questions over...
  6. LittleMan22

    Daytimer 2000

    Hey guys, Thanks for the help. I actually found the file on an ftp site and downloaded it. The only problem that I'm having now is that when the trial version expired it corrupted my existing database (i.e. changed the extension from *.efl to *.dl_). So I can't get it open. I need to...
  7. LittleMan22

    Daytimer 2000

    Hi guys, Kind of a weird question for an Access forum, but you guys have helped me out a lot in the past so I'm gonna try my luck again. I have all of my Christmas labels stored in a program called Daytimer 2000. I had '99, deleted it off my computer and loaded the trial version of 2000 last...
  8. LittleMan22

    Invalid Procedure or Call Argument

    The problem occurs when the recordset is empty. How can I fix this?
  9. LittleMan22

    Save Record Error

    Does anyone know why I'm getting this message (if so how can I get around it): This record has been changed by another user since you started editing it. If you save the record you will overwrite the changes the other user has made. Copying the values to the clipboard will let you look at the...
  10. LittleMan22

    Invalid Procedure or Call Argument

    Hi what's wrong with my code: Dim rst As Recordset Dim strComment As String Set rst = CurrentDb.OpenRecordset(&quot;CurrentClientApplicationDataPolicies&quot;) With rst Do Until .EOF strcomment = strcomment & !Carrier & &quot; &quot; & !PolicyNumber & &quot; &quot; & Format(!Amount...
  11. LittleMan22

    IFF Statement

    Hennep: worked perfectly. I have another question for you guys too. I used this formatting on the fly in another instance: Select Case strField Case &quot;Policy Adjustment&quot; Select Case varFieldvalue Case &quot;Replace&quot; Fdf_Output.FDFSetValue &quot;AmountReplace&quot...
  12. LittleMan22

    IFF Statement

    Thanks guys, It worked beautifully. One more thing while I have you here... How can I get the fields to format within this code? For example, when I call their values from the recordset a field like AMOUNT is 1000000 wheras I would like it to show up as $1,000,000. Is this 'on the fly'...
  13. LittleMan22

    IFF Statement

    Lightning: It woouldn't work (I'm assuming, like you said, because of the EOF propoerty within the expression). Paul F: That doesn't seem to do it either. I'm not exactly sure where that bit of code would go within my current code. I've tried it in a couple of places but to no avail. Can you...
  14. LittleMan22

    IFF Statement

    Currently I have the following: Dim strComment As String Dim rst As Recordset Set rst = CurrentDb.OpenRecordset(&quot;CurrentClientApplicationDataPolicies&quot;) With rst Do Until .EOF strComment = strComment & !Carrier & &quot; &quot; & !PolicyNumber & &quot; &quot; & !Amount &...
  15. LittleMan22

    Continous Field

    Hi, I have a query who's purpose is to 'look-up' all of the currently displayed client's existing policies. It lists these under a continous field (POLICYNUMBER). What I want to do is pass these values into a single field on the main form of our database. I can get the first policy to pass...
  16. LittleMan22

    DLookup

    Let me read up on a listbox...I don't even know what it is/does??? It might serve our purposes as long as it is able to compact the various fields into 1 field. Ryan.
  17. LittleMan22

    DLookup

    Some more info: What the query &quot;CurrentClientApplicationDataPolicies&quot; holds is the current policies for the client (that is the client whose record is currently displayed). It's designed to only have 3 visible fields (policynumber, amount, carrier). And the average client only has...
  18. LittleMan22

    DLookup

    Jon, The query is written to only hold the current client's policies so the displayed policies are automatically related to the specific individual in question. Ryan.
  19. LittleMan22

    DLookup

    Hi, Here's some code that I have written right now: Private Sub Form_Load() Dim VarP As Variant Dim VarQ As Variant Dim VarR As Variant VarP = DLookup(&quot;Carrier&quot;, &quot;CurrentClientApplicationDataPolicies&quot;) VarQ = DLookup(&quot;PolicyNumber&quot...
  20. LittleMan22

    Calling a Field from a Query

    The problem is that the field that I want to bring in isn't in the recordsouce...and it would be really complicated to link it together (they are big and distinct queries). The bound textbox (remarks) is part of a form that has the question &quot;does the client have any existing...

Part and Inventory Search

Back
Top