Search results for query: *

tblPricing PricingId - Prine Key PropRef - Foreign Key PropPrice - Currency DatePublished - Date For a given [PropRef] there can be none, one or many record in the table. I need a query that will produce one record per [PropRef] with the value in [PropPrice] which is the most recent ( according...

I have an Access97 database and I'm exporting data using TransferSpreadsheet to a pre-exising excel file. The file needs to have protection on it when users are working on it but, of course, with protection activated I cannot export ( Can't delete the old data before adding the new ). So I...

I just know this has been discussed before - but I'm having no joy with searching for solutions - so here is the problem. tblItem contains records of items which can be parts of Collections >> tblCol. Relationship is many to many so I have tblItemCol ItemRef FK to tblItem.ItemId ColRef FK...

I have a client who still used Access97 ( Due to a compatibility issue with their client ) and I need to send a report as an email attachment which includes images of company log etc. Using :- DoCmd.SendObject acSendReport _ , "rptEmailLetterSingle", acFormatRTF _ ...

I'm an Access database developer and a client has been running my apps on Windoz 2k - 2k3 for years but they can't get 2k3 licences anymore so we need to get them running on Vista Standard structure is Access front ends all resident on user's local machines using ODBC to MySQL BackEnd on the...

I'm an Access database developer and a client has been running my apps on Windoz 2k - 2k3 for years but they can't get 2k3 licences anymore so we need to get them running on Vista Standard structure is Access front ends all resident on user's local machines using ODBC to MySQL BackEnd on the...

Does anyone know of a utility that will convert SNP files to PDFs ? I know SNP is the Microshaft inhouse version of PDF - I was just wondering if someone has written a converter to change the format to the more common reader type. G LS spsinkNOJUNK@yahoo.co.uk Remove the NOJUNK to use.

I'm following the code supplied in the help file that has worked on many other dbs, but I can't get it to work on this one ( Access 2002 is it matters ) ... ChangeProperty "AllowBypassKey", dbBoolean, False ... Function ChangeProperty(strPropName As String, varPropType As Variant...

I have an Access 2000 database that is stored on a server. When it is updated there is a utility that tell users who then copy it to their local machines and run the app from their C:\Program Files folder. This has been working fine for a long while. Until this week one user gets a new PC...

I have an Access97 database that has been running fine for years on many machines ( Win98, 2k, XP ) however, one user has just got a new machine ( Windoz XP ) and now she is having problems. On one form the RecordSource is like "SELECT * FROM tblOwnerDetails ORDER BY Left([FileRef],3)...

I have recently been updating a database I developed just over a year ago. In BOTH there is the following sub:- Private Sub ViewYoungsters() Dim strSQL As String Dim cqd As clsQueryDefs Set cqd = New clsQueryDefs strSQL = "SELECT CName, CRef, LastName, FirstName, UserName, DoB, " _ &...

I'm sure this one has been covered before - but I can't seem to fine the right key words to search on tblA AId FieldA1 etc .. tblB BId ARef BDate FieldB1 etc.. tblA on the ONE end tblB on the MANY end tblA.AId = tblB.BRef I want to return all records from tblA and just the latest record (...

I have installed MySQL on a remote server on our network running Windoz 2000 Server. However it reports that something else is using Port 3306 and refuses to start. Details : C:\ .. .. \bin> mysqld --console Can't start server: Bind on TPC/IP port: No Error 051128 9:14:34 [ERROR] Do you...

I have a series of MSAccess Front End applications that are distributed across 6 sites over a WAN ( VPN ) ( Front up for a MySQL dataengine ) To speed up logging on to the MSAccess databases I have distributed the .MDW file to each of the local servers and the users then open their Access front...

In an older version of MySQL that defaulted to MyISAM table types I could simply copy the contents of the MySQL/Data/DbName folder to a similar folder on another server and the MySQL on that server would, following a reboot, see the entire database. Using the 4.1.12 version of MySQL the default...

Over recent weeks a client of mine has been experiencing all sorts of MSAccess problems in applications that have previously been working fine. These problems have ranged from : Printing problems to Local ( rather than network ) printers RunTime error 2486 "You can't carry out this action at...

I have a number of MSAccess front end apps with data on a MySQL server database. The Roleup patch 1 for SP4 has caused all sorts of mayhem among these applications. Printing problems, Form Closing problems, Can't update combo boxes etc. I have narrowed the cause down to the one specific...

But I'm not using Transactions ! I have a fairly simple Front end database connected a MySQL back end. Connection via ODBC Some ADO recordsets for populating forms and writing data and PassThrough queries for other things like populating combo box rowsources etc. This has been working fine...

I have a couple of applications built as A2k front ends connected to back ends on MySQL On most machines they work fine. However, on some machines they lock up all over the place. On a problem machine recently I opened the database in design mode. Opened a report in DESIGN mode. Without...

I have two tables that are Import Quarantine tables populated from CSV files. The tables are linked in a one to many relationship - but as I can't trust the validity of the data I cannot guarantee the referential integrity. tblImportTest TestId field1 field2 etc. tblImportContent TestRef...