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 derfloh 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: 35mph
  • Order by date
  1. 35mph

    TCP/IP Printer and DNS?

    Way to go, bcastner... but thanks to you others as well. We DID have DHCP enabled on our file server AND on our router. I think you all suspected that we had a DHCP conflict. We disabled DHCP on the file server (on the general theory that we might from time to time opt to down that machine...
  2. 35mph

    TCP/IP Printer and DNS?

    Thanks for the info, friends... Re Master Browser: Would I have Master Browser issues if all workstations on the LAN are able to connect to networkwork resources consistently and quickly? Otherwise, here is what I have done: Moved the printer's IP address out of the DHCP range... down to...
  3. 35mph

    Able to make Purchasing Receivings default to Shipment/Invoice?

    Is there a way to make the receivings entry screen in Purchasing default to "Shipment/Invoice" instead of "Shipment?
  4. 35mph

    TCP/IP Printer and DNS?

    Sorry about the perhaps elementary nature of this question, but I'm no DNS expert. Our new HP printer takes a long time to be "found" on our network... even though we have assigned it a static IP. Here are the particulars: Our LinkSys router is set up as follows: IP: 64.xxx.xxx.236 Mask...
  5. 35mph

    Business Inkjet 2250 driver for Server 2003

    Just checking... did the XP driver work? Should it?
  6. 35mph

    Another VBA Toolbar User Date question

    David, once again, you are the man. I got around the last problem I had by using a BeforeModal Dialog section... I'm braindead right now, so I'll try this a little later, but THANK YOU for your help with this. It looks like just what I need.
  7. 35mph

    Another VBA Toolbar User Date question

    Man... it just doesn't end... now, using that solution above, that has the effect of adding a (blank) record, so when I'm ready to close the PO window, I'm asked if I want to save it or delete it...
  8. 35mph

    Great Plains and WennSoft....Pitfalls????

    Here's something to be on the lookout for... not specifically with WennSoft, but with ANY job costing system: How tough is it to set up a job? Many users want a job costing system, but for small and/or unique jobs, it takes a lot of work to set up the job, steps, resources, bugdets, users...
  9. 35mph

    Another VBA Toolbar User Date question

    Well, here's what I did... surely there's a more elegant way? Private Sub Save_AfterUserChanged() If Me.PONumber = "" Then Dim OrigDate As Date UserDate.Open OrigDate = UserDate.AccSysDate UserDate.Close Me.OldDate.Locked = False Me.OldDate =...
  10. 35mph

    Another VBA Toolbar User Date question

    I'm clear on using 7.5 to get the toolbar objects for 8.0 (thanks, David), but when I use the toolbar to get the Great Plains User Date, it's called ZoomButton and doesn't seem to work. A. Is that the field I should be using, and my syntax is simply wrong? B. I tried using the 8.0...
  11. 35mph

    Please help with INSERT

    Thanks for your reply... First, the schema you wrote is not exactly correct. It is: DB1.tbl Col1: primary key integer Col2: Col3: Identity DB2.tbl Col1: primary key integer Col2: Col3: Identity Yes, I must leave the schema as it is...
  12. 35mph

    Change default using VBA

    We have used VBA to lock the PO date in Transactions > Purchasing> Purchase Order Entry, so that the user can't change the PO date. It always defaults to the Toolbar date... Now, if a user opens an OLD PO it (correctly) shows the OLD PO date... and that's what we want... and if they make a...
  13. 35mph

    Copying GL Accounts from One Company to Another

    barbola, admittedly I may be missing something, but your idea didn't work for me because of primary key constraints... the existing records kept getting in the way. I solved this problem by exporting all the data to Excel, combining the data, massaging the records, deleting the data in the...
  14. 35mph

    Please help with INSERT

    Yes. No. I basicaically got around this by exporting the data for these tables from DB1 and DB2 to separate Excel spreadsheets, leaving COL1 the same for Excel.DB2, and just re-numbering COL1 in Excel.DB1, starting at the next highest number above that which existed in Database.DB2... then...
  15. 35mph

    Please help with INSERT

    We have two databases, almost identical, and we are trying to copy data from Table1 in Database1 to Table1 in Database2. DB1..TBL1 has these columns: Col1: primary key integer Col2: text Col3: Identity column DB2..TBL1 has the same structure, and ALSO already has data in it, that we want to...
  16. 35mph

    Copying GL Accounts from One Company to Another

    We need to copy gl accounts from one company to another... this would be pretty simple if accounts did not already exist in the destination company... which we want to keep... but consider this sql statement: insert into THREE..GL00100 select ACTINDX, ACTNUMBR_1, ACTNUMBR_2, ACTNUMBR_3...
  17. 35mph

    How simple to disable Terminal Services TEMPORARILY?

    I'm basing that on looking at two different Terminal Server machines... one has TS in APP mode, and we CAN'T disable it there or stop the service (without going into Computer Mangement)... and the other has TS in RDP mode and we CAN stop the service in Services....
  18. 35mph

    How simple to disable Terminal Services TEMPORARILY?

    Yep... I saw that too... it IMPLIES Terminal Services in RDP mode... I think if you have TS in APP mode you can't disable it in Task Manager, or in Services... you've got to "remove" it under Computer Management... and that's my question: if we do that in Computer Management, what will I be...
  19. 35mph

    How simple to disable Terminal Services TEMPORARILY?

    SCC is a tool that is used to manage Symantec Antivirus Corporate Edition... from SCC you can schedule scans, virus updates, program updates... all from one machine... hopefully, the server, in our case.
  20. 35mph

    How simple to disable Terminal Services TEMPORARILY?

    Well, that's the million dollar question...

Part and Inventory Search

Back
Top