Search results for query: *

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

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

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?

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???

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

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

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

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

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

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

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

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???

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?

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

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

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

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

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

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

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