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

  1. docjohn52

    Single user, designing module, err: database has been placed in a state by user 'Admin

    When I see this, it means I've got Access, and a table in design mode. Save the table layout and re-run... :-)
  2. docjohn52

    ISDN Clocking...

    Switchrooms in the US, now use satellite GPS satellites for timing, and are synced to what is known as System Network Clock, or snyc, ("Snik"). T1's DS3's, OCC, Digital Switching networks, all running in sync. While it is true, there is a master / slave end for a T-1, there is no sending...
  3. docjohn52

    Regarding Hunt Groups

    Depending on the equipment, it is possible to do a linear hunt to a second group, a rotary group will not. It is possible also to create a sub group, within a large group.
  4. docjohn52

    Hyperlinking and VBA help

    Create a table in Access for your hyperlinks. Use Dynamic SQL to query the database for the appropriate hyperlink.
  5. docjohn52

    Emulating user entering data into a web form and submitting data?

    The old VB6 used to support 'sendkeys' and apparently Excel 2007 still does... And according to MS "This function is used by the upgrade tools to emulate the Visual Basic 6.0 SendKeys method. In Visual Basic 2010, use the My.Computer.Keyboard.SendKeys method instead." You could do it... It...
  6. docjohn52

    Getting a reference to a textbox from its menu item .....

    I really miss control arrays...
  7. docjohn52

    Crystal Reports in VB6

    Crystal Reports indeed shipped with the "Pro" versions of VB5. Just add a reference to it. It's not a component. I think it was available earlier. You need to look up the VB reference commands. It's not the full version, but it does most of what you need. Don't get too crazy with SQL. It's...
  8. docjohn52

    winsock can receive messages, but can't send....

    the Server is the machine with "listen" running. that's the only diff. Once you're connected, it makes no diff, who's who. I used it on a LAN, but built it with the same machine, and you had to compile and run the other, then connect with the IDE version of the other, on the same machine. when...
  9. docjohn52

    winsock can receive messages, but can't send....

    I used to do this, it required a handshake front end. I used to send an ack, and stuff... I remember "chunks" Lemme look into it... been a while, but once I have it one way, it worked both, you may want to make sure your firewall or port forwarding in the router isn't killing it. btw, you can...
  10. docjohn52

    Giving Access program an expiraton time (like a demo version)

    You should hide it a little, I mean the load event is a little obvious, isn't it? Save it as a worksheet function or stick it in a module, and chain a couple of do-nothing calls to functions together, put a call to a gettime() function in the load event, then call something else in it... And...
  11. docjohn52

    EXCEL/VISUAL BASIC BUTTON COLOR

    grozer... Hi there from an ex-telephone grunt! (the CIRAS and CILLI codes gave it away.) :-) I did a pretty exhaustive search for you and it appears the only thing you can do is add a picture or icon to the button. "Face" won't do it, but I have learned alot about toolbar buttons, so thanks...
  12. docjohn52

    Mousepointer does not get back from vbHourGlass to vbArrow

    just for giggles try screen.mousepointer=0 jb
  13. docjohn52

    DAO behavior, something happened...

    ...Set wrkJet = CreateWorkspace("", "admin", "", dbUseJet) Set dbsDebit = wrkJet.OpenDatabase(DBname) Set Rst = dbsDebit.OpenRecordset("SELECT * FROM clients WHERE_ ClientLastName = """ + CustomerMaint.Text1(0).Text + """", dbOpenDynaset, ReadOnly) While Rst.EOF = False k = Rst.RecordCount '...
  14. docjohn52

    Multiple SQL Statments from Excel to Access

    ...looking for a numeric variable, and you could probaly replace text2.text with ltrim(str(val("123456"))) Set rst = dbsDebit.OpenRecordset("SELECT * FROM creditors WHERE clientID = " & Text2.Text & "", dbOpenDynaset, ReadOnly) This is the statement used to find an actual text string being...
  15. docjohn52

    How do you UNhide a table

    Found it, for all of you out there, Ck the FAQ's first! (And I even knew it!) Thanks John
  16. docjohn52

    How do you UNhide a table

    Can't find it anymore, using 2000... TIA John
  17. docjohn52

    Attaching files to email

    subject=Test&attachment=" & TempFilePath This looks like you're jamming everything into subject subject=Test, attachment=" & TempFilePath maybe semicolon? maybe just a space... John
  18. docjohn52

    For...Next

    'intRow = 44 this changes each loop - don't set it here intFirstRow =1 '? intLastRow=44 'these are all guesses intCol=1 '? For intRow = intLastRow To intFirstRow Step -1 intFound = Cells(intRow, intCol).Value 'now intFound will change each loop 'only fixed to here there are more...
  19. docjohn52

    Help me macro Excel problem

    ActiveSheet.PageSetup.PrintArea = "$a$1:$h$60" bResponse = Application.Dialogs(xlDialogPrinterSetup).Show If bResponse = "False" Then Exit Sub ActiveSheet.PrintOut Copies:=1, Collate:=True ActiveSheet.PageSetup.PrintArea = "$a$1:$AA$60" John
  20. docjohn52

    Search as You Type ~~ Narrow Down List

    Anytime, But I really should look at code b4 I post! The two lines... ListBox1.ListIndex = -1 z = ListBox1.Text ...Aren't needed and are really refuse lines, left over while I was playing... John

Part and Inventory Search

Back
Top