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 Rhinorhino 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
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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?
  4. 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???
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. chrisbee

    Automated call to tel numbers to request info? Possible or not?

    Hi Is it possible to set voicemail pro up so that it call a database of numbers at a certain time - say 7pm, plays a message if the phone is answered and then recoreds the responce. Thinking behind this is we deliver to customers homes - but most are not in until after work - I would like to...
  12. chrisbee

    Voicemail Pro - Any way for supervisor to see all messages

    Hi Is there a console or similar that will display all of the extentions and the number of voicemail messages for them? If not is there a way of achieving the same buy setting up PhoneManager Pro with access to all groups or something???
  13. chrisbee

    Windows CE 2.11. Symbol 2700 - Need to manipulate Access Database!!

    Hi Does anyone know of a product to run on a Symbol ppt2700 WindowsCE 2.11 MIPS processor? I want to sync an Access Database table to and from the devise for data capture but POCKET ACCESS is not installed so I am at a bit of a loss - capturing signatures is also a requirement. Any Ideas?
  14. chrisbee

    How do I use a variable as a form name in a setfocus statement

    Hi I have several tables which hold the postcoades for different areas. Each Two Letter Prefix is a unique table. I have a variable USEPOSTCODE which decides which table to use....but I want to perform the following:- USEPOSTCODE="POSTCODEPO" Forms!USEPOSTCODE!postcode.setfocus...
  15. chrisbee

    Moveing an image from OLE to disk and generate filename and path

    I am using a Symbol scanner to collect delivery information including a signature - all works great - on the sync the tables are updated. But for various reasons (DB size and ability to display signature via an ASP page)I want to store the signature in a seperate directory and create a link to...
  16. chrisbee

    Voicemail Pro - Argh! Any Sample scripts out there???

    Hi I have just got the IP 403 and VMPRO - the 403 is excellent and a massive improvement on the Mitel 3100 we had - but I am a little stumped by the VM Pro. So far we only have 3 extentions (500,501,502) and VM Lite works fine. The VM server and key server are running fine but I can't seem to...
  17. chrisbee

    Is it possible to use VPN to work as if on LAN - simply

    I know what VPN is all about abd I can connect a VPN and ping the other computers (i.e. 192.168.1.5), I can connect with the names (i.e. Dell1000), I can browse each computer by typing either the name of the IP - BUT I cannot get it to work as if I were on the LAN. i.e. I cannot click 'Computers...
  18. chrisbee

    VPN - why can I see individual computers but not the whole workgroup

    VPN in fine can see computers by IP or Name but If I click on network....just sats server unavailable.... I know you guys have probably seen this question 1000000 times - but please help
  19. chrisbee

    How do I import all *.csv files in a directory with transfertext?

    I have a database that is in three sites, I want to transfer information to and from sites via an FTP site, but how do I import ANY and ALL files that fulfil the naming criteria i.e. JER?????.csv
  20. chrisbee

    How do I use CNTL in a replace statement

    I have an address field which gets its data from a POSTCODE (ZIP) program:- "Tattoo Studio","","","",""," ","6 Grand Parade","High Street", How do I tidy this field up to remove the blank fields (easy Find and...

Part and Inventory Search

Back
Top