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 = "SELECT * FROM AllBands WHERE RateInfoID=2 AND Plan="&Form_Plan&" AND MinAmount <= "&Form_Amount&" AND MaxAmount >...
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...
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...
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.
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...
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...
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...
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...
Hi what's wrong with my code:
Dim rst As Recordset
Dim strComment As String
Set rst = CurrentDb.OpenRecordset("CurrentClientApplicationDataPolicies")
With rst
Do Until .EOF
strcomment = strcomment & !Carrier & " " & !PolicyNumber & " " & Format(!Amount...
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 "Policy Adjustment"
Select Case varFieldvalue
Case "Replace"
Fdf_Output.FDFSetValue "AmountReplace"...
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'...
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...
Currently I have the following:
Dim strComment As String
Dim rst As Recordset
Set rst = CurrentDb.OpenRecordset("CurrentClientApplicationDataPolicies")
With rst
Do Until .EOF
strComment = strComment & !Carrier & " " & !PolicyNumber & " " & !Amount &...
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...
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.
Some more info:
What the query "CurrentClientApplicationDataPolicies" 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...
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.
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("Carrier", "CurrentClientApplicationDataPolicies")
VarQ = DLookup("PolicyNumber"...
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 "does the client have any existing...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.