Search results

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...

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)...

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

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...

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...

Hi, I'm still working on a single project (and have been for the past year?) which is starting to annoy me greatly. Basically; I have a recordset setup to update the data in a table after an append query copies the record accross to an archive, but setting the recordset to update the right...

Hi, I'm developing a form, and when the user enters a text box, a reference code start is automaticaly entered of CMP-BCA so the user can enter four digits, however I want the Carrat/Cursor/Text Pointer to move to the end of this, i.e. after the A Is there any way to do this?

Hi There, I'm developing a bookings system for work. The outcome is a report of the booking confirmation. I've found software that will "print" to Adobe PDF format however, is there any way to attach the specific confirmation report to a standard email and then send to the customers supplied...

I've got a database with ~420 records containing multiple choice answers from a surevey we conducted over the christmas time. I've really just only got round to compiling the data so I can hand it in to head office. So basically what i've done is created a query for each of the questions (7 in...

Hi, I have an arrival date and a departure date and I need to work out if the current date is within the two dates. It's a criteria for one of my fields on the query I'm using as the backbone for a list box. Any help greatly appreciated :D Thanks, Adzi

Hi, Basically i'm in the process of creating an bookings system for where I work and I'm having a little trouble. I'm not new to VB, but then again I'm by far, no means and expert. So a little help would be really appreciated. When a camping reservation is taken, the customers details are...

Hi, I need a little help with my Query design. I have an Arrival Date and a Departure Date for campers checking in on a campsite. I need to produce a report for the warden to have to check who's on site. So far, the best way I though was using a new field in the query for "On Site" (which...

Hi there, Im working hard on this database for work, but i've run aground on this problem. Im not even sure if its possible... A permit number is typed into a search box. The comand button takes the search term (the permit number) and locates the record. A vbYesNo msgbox confirms the checkout...

Hi there, I have a database that i'm looking to password protect with a user login form. The users are all on a combo box which is being gathered from a table. The table also contains the passwords. A query fetches the username and password from the table by the criteria set to the combo box...