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 TouchToneTommy 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
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. pnabby

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

    I have read and understand how to set up a vpn client, but I don't know how to set it up on the other end. I have a small workgroup network - 1 xp pro and 1 win2k computer connected via a dlink dwl-900ap+ router (since sometimes a laptop is on the network). I do NOT have a server. I paid for...
  6. pnabby

    I believe this is a DNS Problem

    I haven't gotten anyone to respond to this problem. Any suggestions would be helpful as I know little to nothing about DNS. thanks. We have two domains, domaina and domainb. Domainb is a child to domaina. When I am logged onto domaina from a workstation, I can go to network neighborhood and...
  7. pnabby

    Error when trying to connect to a different domain from a workstation

    We have two domains, domaina and domainb. Domainb is a child to domaina. When I am logged onto domaina from a workstation, I can go to network neighborhood and see domainb. I can double click and see all of the computers on domainb. However, if I try to access any computer (including the...
  8. pnabby

    DNS error

    I keep getting this message every 15 minutes in DNS Server section of the Event Viewer in Windows Server 2000: Event Type: Warning Event Source: DNS Event Category: None Event ID: 5504 Date: 10/26/2004 Time: 12:16:46 AM User: N/A Computer: Description: The DNS server encountered an invalid...
  9. pnabby

    Password changes to the domain's default group policy

    We recently decided to implement a more secure network, which involved changing everyone's passwords and adopting a stricter password policy. The previous IT admin did not have any group policies in place. We have domains a, b, & c on servers a, b, & c, respectively. Domain a is the primary...
  10. pnabby

    Help -- I need to go to the beach this weekend...

    and I can't if I don't fix this problem. We are running Server 2000 and Exchange 2000 and the prior IT Administrator had our mail relay set up to allow computers to relay through the SMTP virtual server "All except the list below" (which was blank) and to "Allow all computers which successfully...
  11. pnabby

    Prevent users from adjusting date/time.

    How do I set up a group policy to prevent users from adjusting the date/time on their individual workstations. I want the server time clock to update all of the workstations. Is this possible? We are using atomic clock to keep the server time correct. Any help is definitely appreciated...
  12. pnabby

    Importing a CSV file in lieu of an XLS file

    I finally figured out how to write the macro and use a command button in an Access form to run the macro and import data from an Excel spreadsheet into an Access table. I have 2 remaining issues. 1. Originally the data is updated and downloaded into a CSV file, and I would prefer that the...
  13. pnabby

    Replace a blank field with text

    I added another column to an existing table and I already had several thousand records. These are stock tickers and I just want to add the word NASDAQ in this field rather than it being blank. I can't remember how to do this in the Search/Replace function. Any suggestions?
  14. pnabby

    Querying on the Long Date

    I have a restaurant database I built in Microsoft Access. I just changed the date format to see the days of the week and I have another field that indicates Lunch or Dinner. I need to run a report to look at the lunch performance by specific days of the week. I have tried query parameters...
  15. pnabby

    Do I need a static IP to remotely access a peer-to-peer network?

    I have a peer-to-peer network (2 clients) at a business that I need to regularly access the Quickbooks files. I also have a peer-to-peer (2 machines) network at home. I have a cable modem at home and I am in the process of installing a cable modem at the business. Do I need to pay the extra...
  16. pnabby

    Does anyone know how to take negative values in a field & convert

    them to zero? I have some values that are zero and some are positive, however I have a few that are negative. These values were taken from Quickbooks inventory availability and the cashiers have inadvertently allowed negative availability. I am looking at the average of a bunch of values to...

Part and Inventory Search

Back
Top