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 Shaun E 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...

    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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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 &...
  8. 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...
  9. 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...
  10. LittleMan22

    Calling a Field from a Query

    How do you call a field from a query? I want to set the value of one of my text-boxes on a form (field = remarks1) to equal the value of a field in a query (field = policyID) in the form's onload event procedure? Ryan.
  11. LittleMan22

    Recordsets

    Here's what I'm trying to do (this code needs to appear in the on-click event procedure of a button in a form). I need to a) open a recordset (Policies) b) Access searches for the entry (unique entries) that matches the policy ID# displayed on Forms!frmClients!subFormPolicies. c) Access...
  12. LittleMan22

    Bound Collumn Transfer?

    Is it possible, when you are using a combo box, to have the bound collumn set at 2 but then when you transfer the data to another field set the bound column to 3? i.e. can you have code that resembles the following: Forms!frmClient!Amount = Forms!frmClient!Trans!Amount(BoundCollumn2) Ryan.
  13. LittleMan22

    Saving Problem

    I'm trying to requery a subform and keep getting the message &quot;you must save current field before running the requery action&quot;. This is happening because before I requery the subform I'm passing a value onto it within a field called &quot;STATUS&quot;. How can I get around this error...
  14. LittleMan22

    With, End With

    Is it possible to have two sets of WITH commands? For example I want (and currently have) my first with set at Forms!frmClients!frmDataEntry but it would be great if I could put in another with to say Forms!subformPolicies. Is this possible? Ryan.
  15. LittleMan22

    Requery and Save Record

    Here's the deal... I have a main form (frmClients) with a command button that brings up a bunch of options the user can pick from. If the user picks the first one 'convert existing policy' it brings up another pop-up where they can enter data. When they close this pop-up they are given the...
  16. LittleMan22

    Me.Refresh?

    Here's what I'm trying to do: I have a main form which hold's our client's info which contains a bunch of pages (tabs) one of which contains the client's policies (this is actually linked via a subform called frmpolicies). On this main form I can access a pop-up that contains various fields...
  17. LittleMan22

    Passing Field Values

    Hi, I have 2 questions: a) I have a field on a pop-up form that calls a value from another form with the default of the pop-up set to: Forms!frmClients!pgeAdditionalInfo!MaidenName. It works beautifully, except when there is nothing entered in the MaidenName field on the origional form - in...

Part and Inventory Search

Back
Top