Hye,
Access97
Im scheduling a .mdb to run overnight using an AT Command the problem is that when the .mdb fails 'admin' is seen as locking my .mdb out, any ideas as to how I can stop this from happening (Im do not have admin privs)?
To get data from Access to Excel I tend to use:
rs.copyfromrecordset from within access
also, I have started using excel for chart creation as apposed to access as reports are very messy when dealing with charts.
Adam.
Hye,
I have written a program to transfer data from one oracle server to another, as part of my code i loop through each recordset deleting the records so that i can then add the new data in, the problem is this is a very slow process, can anyone think of a quicker way, an example of the code I...
Crystal 8.5
Access 97
Hi,
Im using the Crystal RDC via Access VBA. I need to refresh data in a Crystal report and then export it as a .txt file for import into my Access database, Im very new to the RDC and would like some help, preferably a solution.
Lets say the report is called...
Crystal 8.5
Access 97
Hi,
Im using the Crystal RDC via Access VBA. I need to refresh data in a Crystal report and then export it as a .txt file for import into my Access database, Im very new to the RDC and would like some help, preferably a solution.
Lets say the report is called...
Hye,
Im currently using Crystal to report from data on an oracle server. We use Citrix as our main route to the application server, when Crystal was installed on top of MSOffice it created problems with some of the registry settings, meaning that you cannot access the references section through...
Hye,
Im currently using Crystal to report from data on an oracle server. We use Citrix as our main route to the application server, when Crystal was installed on top of MSOffice it created problems with some of the registry settings, meaning that you cannot access the references section through...
This should solve your problem...taken from another page, this is what the person did to resolve the error:
1. I tried decompiling, it did not solve the problem.
2. Repair and Compact database options on the tools menu produced the
error "Operation invalid without a current index"...
In the instance above the SQL below taken from Access would work:
UPDATE [Table A] INNER JOIN [Table B] ON [Table A].ID = [Table B].ID SET [Table B].[Value] = [Table A]![Value]+[Table B]![Value];
I would probably use multiple forms closing each form and saving the data through code, as one form closes another opens writing to the recordset through dao. If you use workspace transactions (BeginTrans and CommitTrans), if the user does something which would mean all data should be removed...
Hye Hadi,
Im no expert in Crystal but the way I would do this is:
1) Get your field explorer up (where you select fields to drag onto your report).
2) Right Click on Formula Field and select new.
3) Give the first formula a name eg BEDTotal.
4) OK, Now you are in the formula editor, Type...
Hye,
Im pretty new to crystal although have been developing through Microsoft for a while. Im using Crystal v 8.0.1.0 and Access 97.
Due to the installation problems with Crystal on top of MSOffice I can't access the references section for MSAccess, to counteract this I am developing using a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.