Recent content by BenJones

Hi, I'm a bit puzzled with this so hopefully someone can help me out. I have a database that has around 20 users who key on their vehicle orders. The main orders table has a number of fields. I have started to notice that the 'Order Date' field that gets populated on completion of the record...

That's it! Cheers, just what I was looking for

I'm trying to make a quiz database using access 97. I need a bit of advice. Do I need a seperate table for quiz questions and answers or should I put the correct answer with the question in the question table. Bearing in mind the quiz is going to be multichoice. Any help would be...

Thanks... So in my query I would need a DSum that says TotalFacility - AgreementAmount Would this be a running deduction total though?

I have created a database that hold customers and their agreements. I have a preset facility amount (the total the cust can borrow) and wish to deduct each new agreement from this amount and display the running total. I have created a module to do this but it only deducts the total of each...

I have a series of Access 97 databases and an office of staff in excess of 80 users. Recently we have seen problems with the Workgroup file we have created as too many users were accessing it at once. Does anyone know the maximum user number for these files?

Thanks That did the trick

I have a Access 97 database which transfers data in a specified format to a txt file. I want to provide a button on an access switchboard which can launch the txt file for the user to see the data they have just transferred. Can anybody provide me with a line of VBA code which will do this...

I am trying to export a table to a txt file using only VBA. Whereas I have managed to do this I am having problems getting the field formats I want (again using only VBA). When I use the TransferText command I know I can call a specification name, does anyone know how to create their own...

I have a database with a table I wish to export as a txt. This file will then be uploaded to a mainframe system. In order for the mainframe upload to work I must get the table fields formatting exactly right (for instance, a number of fields must start with 2 zeros and always be right...