Search results

I am in the process of building a stand-alone version of our company's quotation package for distribution to our sales force. The system currently reads the required data from an internal Oracle database but I am changing it to read from an Access database. The issue I want to solve is that the...

DLL/COM Add-in - Creating in VB 6 I have written quite a few useful functions that I use across a number of different databases and applications and I'd like to write them as a DLL add-in in VB that I can then call from each of the other apps. I have no experience of doing this and was...

I have an application that has been working for over a year with no issues and in the last month or 2 it has been causing 3075 errors on some PC's related to the use of the Date() function in sql statements. The application is in 97 and 2000 and the error has occured in both versions. The...

I'm creating forms to allow users create queries on the fly allowing them to select the fields they want to appear. When they select the fields it creates the SQL and then uses this to create a querydef which then open to display the results. I want to have the number fields formatted as...

I have read through most of the 'Record Locking' posts I could find but still would like some clarification on my issue. I am creating a database for tracking staff absences. The HR department want it to be possible for each staff member (over 500) to enter details of their absences and then...

Does anyone out there know why the following is happening and if there is any solution to fix it? Over the last 6 months or so various reports on different Access 97 databases have been giving a similar error and nothing we do seems to fix it. What we usually end up doing is restoring a...

Essentially what I need is to be able to delete records from an Oracle table using A97. I know that it must be something simple but I just don't seem to be getting anywhere. I need to run a delete query on a table and then an append query to append the records for the run week. Each week...

I have been given responsibility for introducing a version control system for all the Access applications we have (97 and 2000) and was wondering if anyone had any particular product they use that they would recommend. I have searched on the net and found a few possibles but am interested in...

Just wondering if the following is possible and if so how to do it. I have a form that has multiple fields that have default values. These values will be fixed for a quarter and then will change. Currently the users contact me to change the defaults every quarter in the design view of the...