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: *

  • Users: pnabby
  • Order by date
  1. pnabby

    Updating a table from a query with an expression

    ...example I could have 2 crab cakes, 2 pecan encrusted groupers, and 2 flounders on one ticket. I need a quantity total for each item. Then I need a ticket total with tax. I cannot do an update query, since it says the expression I defined Price: [Qty] *[Price] is not updateable. Any...
  2. pnabby

    Updating a table from a query with an expression

    ...new tables where the servers can enter the food items from a form and have it do a quantity total (i.e., for example 2 bowls of she crab soup is 2*4.95 for a quantity total of $9.90). Then I want to add the whole ticket up and add tax. Then I want this total to go into the restaurant sales...
  3. pnabby

    Arggghh--I've been hijacked

    ...- C:\WINDOWS\System32\Shdocvw.dll O12 - Plugin for .spop: C:\Program Files\Internet Explorer\Plugins\NPDocBox.dll O15 - Trusted Zone: *.05p.com O15 - Trusted Zone: *.awmdabest.com O15 - Trusted Zone: *.clickspring.net O15 - Trusted Zone: *.05p.com (HKLM) O15 - Trusted Zone: *.awmdabest.com...
  4. pnabby

    Arggghh--I've been hijacked

    I followed your advice. Unfortunately, I cannot run Hijack This. Everytime I run it, Windows encounters an error and shuts the application down. Spyguard keeps telling me that my homepage has changed. Help!!!
  5. pnabby

    Arggghh--I've been hijacked

    My home page has been hijacked and the default internet home page just says about blank, but I cannot change it back. I am also being inundated with popups. PCCillian from Trend keeps telling me that I have the troj_uploader.f virus, and I keep quarentining it, yet I still keep getting it...
  6. pnabby

    Dual Monitor Support for a Dell 4600

    I have a Dell 4600 with the graphics built into the motherboard. Can I buy a graphics card that supports dual monitors and install it? Or is this not possible since the graphics are built into the mb? I have an extra 17" flat screen and I want to use it. Here are the specs for my computer...
  7. pnabby

    Dynamic List Box based on current record

    Okay, this is what I have: in the cboAccountNumber I have in the Row Source: SELECT tblClientInfo.intAClntAcct, tblClientInfo.chrLastName, tblClientInfo.idsSSN FROM tblClientInfo ; This displays all the information in the drop down box, however, it only returns the client number...
  8. pnabby

    Dynamic List Box based on current record

    That is in the row source for cboAccountNumber? That does not work...now nothing is in the list box.
  9. pnabby

    Dynamic List Box based on current record

    Now what if I want to show the last name, first name, and social security number in the list box. Sometimes your beneficiaries will have the same last name. After I select the beneficiary, I want it to update in the life insurance table, to name that person as the beneficiary for that policy#.
  10. pnabby

    Dynamic List Box based on current record

    You Rock!!!! Thanks, it works. That field is numeric.
  11. pnabby

    Dynamic List Box based on current record

    Okay this is what I have: cboAccountNumber combo box The Row Source is: SELECT tblClientInfo.intAClntAcct, tblClientInfo.chrLastName, tblClientInfo.idsSSN FROM tblClientInfo ORDER BY tblClientInfo.chrLastName; The After_Update Event Procedure is: Private Sub cboAccountNumber_AfterUpdate()...
  12. pnabby

    Dynamic List Box based on current record

    what should be lstBeneficiaries?
  13. pnabby

    Dynamic List Box based on current record

    Okay, I created a form with 2 combo boxes: cboAccountNumber & cboBeneficiary and 1 list box, lstBeneficiaries. The row source for cboAccountNumber is: SELECT [tblClientInfo].[intAClntAcct], [tblClientInfo].[chrLastName] FROM [tblClientInfo] ORDER BY [chrLastName]; In the combo box...
  14. pnabby

    Dynamic List Box based on current record

    This is what I have: tblClientInfo: chrFirstName chrLastName idsSSN (this is a primary key) intAClntAcct (this is a primary key) tblLifeInsurance: idsInsurPolicy# (this is a primary key) fidsAClntAcct (this is a lookup where the row source is:SELECT [tblClientInfo].[intAClntAcct]...
  15. pnabby

    Dynamic List Box based on current record

    Do I create the combo box in the form? Also, use both tables, tblLifeInsurance and tblBeneficiaries as the source?
  16. pnabby

    Dynamic List Box based on current record

    Thanks for the quick reply. I actually have not built the form yet. I have just done it in the actual table. Where is the AfterUpdate? I am sorry, I don't have much programming experience. Thanks for your help Frink.
  17. pnabby

    Dynamic List Box based on current record

    I am trying to create a form where the user will select an account number for a life insurance policy. When that is selected, I want a list box with choices for a beneficiary to be limited to a query that filters the beneficiaries table and displays only beneficiaries that are tied to that...
  18. pnabby

    How do I set up an XP machine to accept a vpn connection?

    I agree, but access to this machine will be primarily at night after the store has closed. He has nitwits who work for him and won't remember to log the computer off (while simultaneously not turning the computer off) so that he could RDP in.
  19. pnabby

    VoIP over Building to Building WLAN

    We are doing the same thing, except our sites are 2 miles apart. We are using wireless radio and we get a whopping throughput of 45Mbps. All of our phone lines are at one location and we are using data and voice over the same wireless connection. We use 3COM NBX 100 phones. Now I just need...
  20. pnabby

    How do I set up an XP machine to accept a vpn connection?

    Can anyone tell me if you can even do peer-to-peer access via a vpn????

Part and Inventory Search

Back
Top