Search results

Thank you so much! That's really helped me! Cheers, Adam

Hi Guys, I have been asked by my employers to create a document retention system. They recieved two documents from the customer which are scanned in as two separate PDF files. The PDF files are stored on the scanner units memory. The scanned documents are accessed from a web interface. The...

Hello, For the past few years I have been developing Access DB systems for my current employer, however IT have now implemented new rules and therefore I have to ammend the way I store the data. Currently I have a 'back-end' containing all the data tables, and a 'front-end', which the user...

Many thanks for your help Brian!!

Concatenating parts of a date query [SOLVED] Hi, I'm currently involved in a project to manage licences and boats on a waterway. The old accesse database was archaic in the way it worked so a complete redesign is in order. I'm stuck on a bit of VBA whereby I need to join two parts of the...

Hello, I've designed a system that allows the user to take campsite bookings. Once the booking has been taken, a report prints. I though I set the database up so that the records are locked on an individual basis, however when two or more people are using the system (i.e. taking a booking)...

Have you made sure that the sub form properties for Allow view PivotTable are set to yes? Simple I know but you'd be supprised how many people forget ;)

Hi, I'm regretting starting this project. It's such a pain! Background: I'm developing a campsite booking system for our large campsite. It works, I'm just enhancing it's usability now. The customer details are stored in tblCustomers with a customerID primary key. The actual pitch bookings...

Hi, I'm a bit useless with recordsets so any help would be greatly appreciated. I've developed a system where the user books in a campsite reservation. A booking reference is generated by taking the last reference in the table and adding 1 to it to form the following "cmp-bca####". This is...

Hi, I'm trying to load an ID number when one form closes to a loaded form. My thoughts are to do this on the "On Close" event but how do I access the already loaded form to enter the ID number in a field. Cheers, Adzi

Call me an idiot! I deleted part of a query that made the whole thing function - ooops! Cheers, Adam

The repair function didn't solve the problem and the backups arent working either - I was assured by a collegue that the backup was a previous version however the backup is a release of the most recent one... never trusting him again!! There is the backend system containing all the tables and...

Hi, I have developed a system for taking campsite bookings at work and the problem is that when the booking has been taken a report prints, basically the booking form containing all the details the customer has given. The report now isnt printing and I cant figure out why. The report data...

Hi, I've just got word from head office, that although the database system I've designed is held on a secure server in HQ, they want the credit card details encrypted now within the database along with the employee table. All this data is held in two seperate tables, within the split backend...

Hey, I don't understand why my DLookup action is throwing up a run-time 2001: "You Cancelled the previous operation" This line in question is this one; BookingRefABC = DLookup("[Booking Reference]", "tblCampingBookings", "CustomerID='" & Me.Text15 & "'") which comes from the following...

It errors whenever two people are accessing the database. If one person is creating a new record, and someone is just looking at the main menu form, then the system will produce a 2501 error.

It's actioned by the user pressing a command button. I have many comand buttons, and the script always halts at the same save action. It always presents an error message, no matter which command button is hit, and it only errors when there is more than one user using the front end system. When...

Every time it hits; DoCmd.Save I get the run time error.

This is what I have set. Can you suggest anything then that would solve my problem? The error occurs when the save command in my VBA is hit.

Hello, I have a database, which is split into frontend/backend using the split utility. I need to make it so multiple users have access. I though this was so, but everytime more than one person is using the system, a Run-Time error 2501 - the save action was cancelled. I thought I set all...