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 Mike Lewis 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. OwenHall

    Changed XP Pro domain to a Workgroup, now can get into PC

    I was trying to connect my desktop PC to my laptop using Wifi and changed the network from a domain to a workgroup. I restarted the PC and now it will not let me get passed the login stage because it can not verify my password on the network that I created because it does not exist. All I want...
  2. OwenHall

    Join two XML files with Xpath

    I am in need of some help with regards to joining two seperate XML documents together with a common identifier. I am usng xPath and DOM to open files up. The relationship is based upon Customer Codes that are present in both files. xml file 1 contains custid custname 123456 Ron Weasley xml...
  3. OwenHall

    Command button Printing

    I need to print a form to a printer whenever a new record button is pressed. It has to be a specific printer. Does anyone know what code to use and controls?
  4. OwenHall

    Use Keyboard through Serial Port on Laptop

    Someone spilt coffee onto my laptop keyboard and now it is not working (The top row 1-9 kind of works). I tried to put a keyboard into the PS2 port but this is not working either. Can I use the keyboard through the serial port (using a PS2 adapter), and if so what settings do I need to use to...
  5. OwenHall

    $format parameter not working

    I have, as I said it used to work on my win98 pc. I was thinking it might be something that I have to add, like dbase extensnions in Data Sources (ODBC)
  6. OwenHall

    $format parameter not working

    I have tried to create a report which has a date formated to the a long date using "=Format$([Date],"Long Date")". But every time when the report is opened it asks for the $format parameter. I have used $format before on my Win98 pc, but since moving over to Win2k, I have had this problem. Can...
  7. OwenHall

    $ Format parameter request

    I've tried different variations on the format front but to no avail. What should I check in my references?
  8. OwenHall

    $ Format parameter request

    Thats what I am doing at the moment, but I was curious as to how "format$" worked on Windows 98 and not Windows 2000. I thought someone may have an answer as to how to get it working under the Windows 2000 operating system.
  9. OwenHall

    $ Format parameter request

    I have tried to create a report which has a date formated to the a long date using "=Format$([Date],"Long Date")". But every time when the report is opened it asks for the $format parameter. I have used $format before on my Win98 pc, but since moving over to Win2k, I have had this problem. Can...
  10. OwenHall

    Query Linked to Form showing #Error

    Still need help on this one. When I say the SQL is Blank I mean that when it is run the result brings back nothing under the field names.
  11. OwenHall

    Query Linked to Form showing #Error

    I tried it out but could not get it to work. I kept getting errors when trying to open or load the form.
  12. OwenHall

    Query Linked to Form showing #Error

    Thanks Tiny, I shall tru this out and see what happens.
  13. OwenHall

    Query Linked to Form showing #Error

    On my Access 97 form 'frmGroup' I am populating text boxes using a subform 'frmSelections', who source is a query 'qryProductCostTypeA'. When qryProductCostTypeA is empty, frmSelections comes up blank and so the textboxes on frmGroup are populated with the '#Error' message. An IIF statement...
  14. OwenHall

    Time Calculation

    Expr1: Format(Sum([TimeAllocation])," hh:nn:ss") I forgot to mention that the time allocation was to be formatted to hh:nn:ss. This works, but the SUM does not. Any more tips?
  15. OwenHall

    Time Calculation

    I have a subform/table with two fields. One is a URN (Sales EstimateID) and the other is set to date/time (TimeAllocation). I want to get the sum of all the records within the 'TimeAllocation' field for each 'Sales EstimateID' but I don't want to have a decimal figure returned. Can anyone help?
  16. OwenHall

    Use MS Access 97 Text Box to connect to the Internet

    I want to connect a text box within MS Access 97 which will update/forward details to an internet site. I know how to get Access to go to a web page, but I want access to be the web page?!?! Hope I can get help. Owen Hall
  17. OwenHall

    Text box pasting

    I am having problems pasting text into a textbox. I have a code which is entered into a text box and when a command button is pressed it pastes the text into the text box. Which is easy. BUT, I want it the paste the text in, then when another code is entered and command button pressed the text...
  18. OwenHall

    Making forms open to fit screen size

    One of ways inwhich I open my forms and reports in Access (to full screen) is to use the below code in "On Open" Docmd.maximize To reduce the size of the screen when you exit (handy for dialog box forms/switchboards is the following code entered into "On Close&quot...
  19. OwenHall

    Changing a Main Forms' Sub Forms with VBA

    I am trying to develop an MS Access form with several sub forms. I wanted to use a single master form and have several child sub forms as sources. What I need to know is how to do this. The plan is to have the user enter a code A,B,C,N in a text box...

Part and Inventory Search

Back
Top