Search results

I have a form (frmStatus). It’s in continuous forms view. It pulls information from tblTypeOfStatus. I have a total of 15 statuses, but for the sake of making stuff easy lets say 5. What current happens: I select one of the five, and that value is stored fine, and the form creates a new combo...

Currently we only use the database to store information about bookings that have actually been booked. And anything that has yet to be booked remains on paper and in a folder. Ideally we want to move to a paperless system, so as soon as we get the booking (via email/fax/telephone) it goes onto...

We have frmBookings and from this, we run a report (rptBookingsByDate). As you would expect it lists all the bookings for the entered date. The report shows a variety of information such as Venue, Contact Person etc etc and a Reference number. What we normally do is just look at the reference...

Simpler way to use the same code in different places? I find myself using the same piece of code in different places. Just wondering is there a way I can store the code, and call it later? So for example, I have alot of Date fields on my forms... And I'm using the following code in...

No idea where to post this, please move if in wrong place… I need a method to track what users do in the database. Nothing too detailed. Just something, that makes a log like: This only needs to be seen by a few select people. I plan to implement User Level Security, so everyone will have...

I need my form – frmFinance – to automatically select between two different values depending on what value is in another txt box. However, sometimes this value needs to be manually edited (in very rare cases, say less than 5% of the time). frmFinance is based on a qry; qryFinance. This pulls...

I was tasked with finding out what is the average time “Int X, Int Y etc etc” did in all of the five weeks in October 2007. I was able to narrow down most of the records (from a 6500+ record DB) using a simple query. Gives… (Coloured blocks represent a single interpreter) But what I...

Just wondering, is it better to have Access write the code for you, or to write it yourself? Case in point: Quit button. Mine: Private Sub cmdExit_DB_Click() DoCmd.Quit End Sub Access: Private Sub Command60_Click() On Error GoTo Err_Command60_Click DoCmd.Quit...

Been googling for a while now, and I can't find any examples of what I want. I have a form (frmBookings) and on this form there is a field (txtDateOfBooking) where a date is entered for whenever the person requires our services. Now I need to check whether the date entered falls on a Saturday...

I’ve successfully managed to implement Cascading Combo Boxes into my new database. Quick overview: cboOrg is the main combo box cboDept values are dependent on cboOrg selection. Now all this works fine. However, I need to add one value (let’s call this ‘Dept X’)’ to all the Organisation...

We currently have a database that we use a work, while it does its purpose, the database design is not the best, nor does it follow best practices in my opinion. Therefore, I am in the process of redesigning it from scratch. While I can do this, I need a little help here and there. I should...