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

    I did not write any programs per say against the Restaurant Transactions Table. However, my reports already have the math with the sums by server and I have other Tipout reports that get this data as well. I built another table, called PLU table, that has all of the PLU #'s with prices and...
  2. pnabby

    Updating a table from a query with an expression

    I know that it is bad form to put calculations in a table, however I have a good reason. A long time ago I create a "Restaurant Sales Transactions" table so that I could put each unique ticket number and the total sale in. All of my reports are generated from this table the way it is. Now I...
  3. pnabby

    Arggghh--I've been hijacked

    I finally got it to run. Here it is: Logfile of HijackThis v1.99.0 Scan saved at 12:39:57 AM, on 12/22/2004 Platform: Windows XP SP1 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP1 (6.00.2800.1106) Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe...
  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