Search results for query: *

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

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

Elegant - will do the trick thatks ;)

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?

robocopy Simple and quick

Simple Genius Thanks

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

Its ok SOLVED IT!

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

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

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

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

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

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

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