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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by chrisbee

  1. chrisbee

    Get Weather information into Access

    Thanks for the idea..thats kind of whaqt I want to do - but I have no idea how to achieve it. My VBA programming is pretty good for notmal Access Database applications but droppingout and reading HTML coded....no a clue. I have looked at some web scrubbers to try to get the information and read...
  2. chrisbee

    Get Weather information into Access

    Hi, I would like to find a way of getting UK weather information for a lat/long location - read it into Access and then be able to send an email with a very simple forcast for the day. The easy bit I am fine with (sending the meail :)) ....but I am having trouble getting my head around how to...
  3. chrisbee

    One Scanner TWO Pcs

    Hi - I would like to use one barcode scanner to send the same data to TWO different programs - I guess running on TWO PCs for ease of implementation. The scan as to be processed in real time - not batch fed. Application. I have a stock checking in system belonging to a customer, but want to be...
  4. chrisbee

    Color Activex Calendar Control in Access Form

    Elegant - will do the trick thatks ;)
  5. chrisbee

    Color Activex Calendar Control in Access Form

    Hi The ActiveX (MSCAL.Calendar.7) Calendar Control. What I am trying to do is change the colour of all the Saturday dates - or better still only allow the Saturdays to be clicked on. Do I have a hope?
  6. chrisbee

    Applying Dbase changes automatically

    robocopy Simple and quick
  7. chrisbee

    Group records by more than one field

    Simple Genius Thanks
  8. chrisbee

    Group records by more than one field

    I have a report that shows names and addresses and consignment numbers. The names and addresses come out of a PAF program so are the same for each individual. Is there any way I can get a report to show all of the consignment numbers for one address - instead of printing them all out seperatly???
  9. chrisbee

    Why does this work? But THIS DOESN'T ????????

    short PC_RapidAddress( char *addr, char *hitsstr, char *recnostr, char *dpnostr, short numlen, char *pcd, short pcdlen, char *prem, short premlen) Parameters addr Input premise (optional) and postcode (mandatory) hitsstr Buffer into which a...
  10. chrisbee

    Why does this work? But THIS DOESN'T ????????

    It just says - Postcode and premise found ....but if EXECTLY the same data is entered in quotes as opposed to a string, it finds it...and the string has retained its value at the function!????
  11. chrisbee

    Why does this work? But THIS DOESN'T ????????

    Hi I am calling a posicoding function from an Access Form. To get an address I need to present part of the address to the function...i.e.TEKAPO, JE3 2EN as in.... rc = PCUTILS.PC_RapidAddress(Nz("TEKAPO, JE3 2EN", ""), recno, dpno) That works just great.. So why doesn't this..... Public...
  12. chrisbee

    Speed Up a Backend - Front End Database.......???

    I appreciat ethat the network can be a problem -but 50% of the users are Remote Desktop - - so limited to the ability of the server and the conection - however - they currently have the best connection....all I THINK I want to do is link the main table through an SQL connection.....however I...
  13. chrisbee

    Speed Up Access Backend / Frontend configuration - Is SQL the ansa?

    I have a databse - backend approx 35000 reocords 50 fields per record. The front end is stored on all the workstations that links to the Backend over the network - using simple linked tables. How can I make this as quick as possible - would convertinf the table to SQL and linking that to the...
  14. chrisbee

    Speed Up a Backend - Front End Database.......???

    Pikkunero I seriously hope not - its not the moveing the data that worries me - more the clever functions that Access uses to qualify the data etc. I am sure (from the little I understand)- that SQL Server should solve the problem as it can deal with huge databases...I just need some pointers...

Part and Inventory Search

Back
Top