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 Wanet Telecoms Ltd 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. billy71

    Retaining zero's in conversion of date to text to date

    How is your date set up in the Computer?. In the regional settings check the Format.
  2. billy71

    2 tables / 1 report

    I use something like this to include a Field from a non-linked table to insert information into a Text Box on a report. =Trim(DLookUp("[Field]","tblName")) Field is the field name in the "table that contains the field.
  3. billy71

    Have RecordsetClone Problem Finding Records

    I have used a Combo box with a Query input that has added the Last Name, First Name, MiddleInitial and suffix if any and also included the Member or Record number to the same lookup field. Adding the number to the search field will show them separate in the drop down. Simply adding the first...
  4. billy71

    Report won't print on legal size paper.

    I assume you have already done this. With the Report in design mode, click on File, Page Setup and on the Page tab select Legal.
  5. billy71

    how to avoid blank pages

    Following up on the above post. Have you tried this. With the report in design mode, click on file, Page Setup and check the margins on the left and right, you might change those to .25 each and see if that solves your problem.
  6. billy71

    How do I open a app

    This one opens an .exe program from a VB form with a command button. Private Sub Command1_Click() MyAppID = Shell("c:\Program Files\Your.exe", 1) ' Run All Reports AppActivate MyAppID ' Activate Microsoft End Sub
  7. billy71

    Running Access 97 after installing Access 2003.

    I don't know what is causing your memory error, but I was able to open an Access 97 database and by pass Access XP by changing the shortcut to something like this. "C:\Program Files\Microsoft Office 97\Office\msaccess.exe" "C:\your folder\yourDatabase.mdb" Office 97 is in the folder as...
  8. billy71

    UPDATING A RECORD

    Hello Bob Looks good to me. VB6 has a heck of a lot under the hood. Billyh
  9. billy71

    UPDATING A RECORD

    There is reference to adEditNone, adEditInProgress, adEditAdd and adEditDelete in the ADO help on MSDN disk 2. That doesn't mean it is avaialble for use with VB6 but as I have used only DAO I can't say for sure. Sorry if I have mislead anyone. I just looked at the help file
  10. billy71

    UPDATING A RECORD

    If you haven't solved your problem yet you might check the VB online help and look at .editmode. I have used indexed textboxes with bound columns and used locking to prevent input until a button was pushed to unlock when placed in .edit mode then lock again when .update or .cancle update was...
  11. billy71

    Win XP Home> cannot see network?

    On my XP Pro machine I ran the Network Setup Wizard and created a Diskette and set up my XP home computer that way. You might be able to run the Network Setup Wizard on the XP home machine and make it work that way, but diskette was easier for me.
  12. billy71

    VB6 Help doesn't work even after installing MSDN Library

    VB .Net is the new version. I think VB6 will be around for some time to come, however if you plan to do programming for a living .Net will probably be the way to go. I don't think learning VB6 would be a waste of time. What you might try is to uninstall VB6 and MSDN then re-install VB6 when...
  13. billy71

    Hyperterminal - where can I download it

    Click on Add/Remove Programs, Click tab Windows Setup, Click on Communications, Click on Details you should find it there. You will probably need the ME CD.
  14. billy71

    formatting a hard disk with windows 95 installed

    If you have the bootdisk or a windows 98 or ME bootdisk, boot up with it then at the A: prompt Enter C: then key format c: and answer Y this should format the Drive
  15. billy71

    Dell ethernet connection causes linksys to flash constantly

    Mine flashs all the time even when the computers are off. Cable hookup.
  16. billy71

    XP won't open fax Tiff

    I think Irfanview will do it. It is free and does a lot of other good stuff.
  17. billy71

    Sharing printer

    I have used a Desktop wired into a wireless router and laptops that belong to the same workgroup sharing the Desktop printer. If both are wireless I don't think it matters. Try to set up both in the same workgroup and make sure the xp firewall is not blocking you. If there is no security set...
  18. billy71

    Sharing printer

    If you have the computers networked it could be as simple as going to the Control Panel, Selecting printers, add printer, click next and there should be an option to add a network printer it will step you thru it. You might have to load the drivers on the laptop but I don't remember.
  19. billy71

    Convert an rtf File to an html File?

    Microsoft Word will do it. Just open it and SaveAs click the dropdown box below and find htm or html
  20. billy71

    Dell Laptop Blank Screen Problem

    Have you tried connecting a External Monitor? The screen may have went dead.

Part and Inventory Search

Back
Top