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: chrisbee
  • Order by date
  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 ????????

    Its ok SOLVED IT!
  10. 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...
  11. 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!????
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. chrisbee

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

    Hi Both Access 2003 - all I did was split the tables out ont a seperate database on the server (which is a pretty quick dual Xeon) and link the F.E. database on the workstations
  17. chrisbee

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

    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...
  18. chrisbee

    SQL Connection strinf - Spped IMPORTANT

    Hi - I currently run an access database with what is really a flat table (55 fields) which grows by 10000 records a month until it reaches around 60000 when it auto archives off records that are more than 6 months old - very few relationships We currently just use Access 'out of the box' and...
  19. chrisbee

    Access front end to SQL backend OR Remote Desktop

    First of a few questions to come....! Does anyone have any experience of the following.... I have an access database that links to some SQL tables via SQL server. We have 2 remote offices on ADSL usinf sonicwall VPN...currently we use Remote desktop to use the database over the WAN....would...
  20. chrisbee

    Sending HTML Formatted email with SendObject

    Hi I am using DoCmd.SendObject acSendQuery, "Email Carded", acFormatXLS, EmailAdd, , , Subject, MessTxT, False to send an attachment .xls spreadsheet to various addresses. Is there any way I can 'sex up' the email that gets sent by making it HTML...maybe adding some banners etc.??? I have...

Part and Inventory Search

Back
Top