Search results

I am looking to migrate my split A97 db to AXP. However not all the computers on my network are up to running XP. Does anyone know if it is possible and/or advisable to access the new XP back end from the old A97 front end??? Any issues I need to take into account? TIA Chris

I have a form on my distributed database that has it's format changed based on certain record characteristics and I am getting a message or error (I am not even sure which it is). The message is ---------------------------------------------------------------------------------- <frmWhatever>...

Anyone know of an on-line (or other) reference, or have any advice on converting from DAO to ADO. I just need the basics in context of an Access XP application. Most of the stuff I have found so far is a bit out of my scope.. Thanks Chris

Anyone had a problem with using ApplyFilter in the Open event of a form. I am trying this for the gazillionth time and for the first time I am getting a problem returning records to the sub form. The form runs fine with no filter applied, but if I apply a filter, then no sub form records are...

I have a bunch of controls on my sub form that need to be requeried based on the value of another subform control. If I say Me.Description.requery in the after update of the Product control, then the sub form requeries all the sub form records. This is slow and I was wondering if there was a...

I have run up against this one a couple of times before and have never found a solution. Hopefully there is a wiser person than I who may have.... I want to copy the form's current values to a new record using a SQL Insert statement fired by a button on the form. I will have to trap for null...

I am really not sure what the Debug Menu command 'Complile All Modules' is supposed to do, however I am trying to use it as a way to test the integrity of the coding on my forms. Anyway the problem I have is with compiling parts of my code that have SQL strings. For example I have a number of...

I have a database that is used to create Purchase Orders, Quotes, Invoices and so forth. I have suppliers and customers in multiple countries and am required to show and manipulate multiple currencies. My usual M.O. is to bring a product price onto a form in it's native currency. From there I...

I have distributed my DB across the LAN at work. I have one user who intermittantly loses Logo graphics that I have encorporated into Report design. It is just one user and only some of the time. Also the Logo is very small and definately within the printable area of the Report. Pulling what is...

I would like to be able to E-Mail the output of some of the Reports I have made in Access97 without loosing the formatting of the Report. I think that I do not want to ask me Clients (the recipients of the Reports) to download software (Snapshot Viewer of Acrobat) in order to view my sales...