Search results

I have a series of If statements that run Before Update on a form, to check that required fields have been filled in. I need the code to stop running when any If statement is true (i.e. the validation fails), to give the user a chance to correct the error before the rest of the validation...

I want a field in my table to list the name of the person who created the record. I've been trying to do this using the fOSUsername function, by copying and pasting that code into a module and then setting the default value of the field to =fOSUsername(). But, this isn't working because I get...

I want to keep a record of who adds records to a table. I've created a field called "CreatedBy", and set its default value to =fOSUserName(). I've got code to get the UserName currently logged in to the OS from here: http://www.mvps.org/access/api/api0008.htm. I copied this code, created a...

I am trying to make an append query to select records from one table based on certain criteria, and then insert the results into another table. I first created a select query to get the required data and then conveted this into an append query. However, when it runs, I get the following error...

I am building a system to manage the allocation of materials/stock to events. I know how I want this to work from the front end, but am not sure how to configure/develop it, so am hoping someone can help me. First some background. The system is going to manage a number of different types of...

I am building a database to manage stock items and track orders. It needs to keep track of sales and the number of items currently available for sale. I looked at the Northwind (2007) sample, and it seems that it calculates the number of items in stock using a query that sums the quantity...

I have three tables: Centres Contacts Centre-Contacts where Centre-Contacts relates Centres and Contacts by ID numbers. More than one Contact can be assigned to a Centre, and I want to output a list of all Centres and their contacts. Of course, I can do this using a query by pulling all...

My database runs on a Terminal Server. Having just upgraded to Office 2007, Access is now prompting users when they log in that the database may be unsafe. I've created a self-signed certificate, and if users click the option to install this, they can then open the database and it works fine...

We're recently upgraded to Office 2007, and are running a database I built in Access 2003. In Access 2003, the toolbars were all hidden when the database loaded, so that users had to use the functions provided on my forms only. In 2007, most of the tabs on the ribbon disappear on load, but...

I have a form with a combo box on it, linked to a field which contains data in "Yes/No" format. I want an IF statement behind a button which will do one thing if the value in the combo box is yes, and another thing if it's no. Can anyone tell me how to write a statement that says "If the value...

Does anyone know where the Compact and Repair feature is to be found in Access 2007? It was on the Tools menu in Access 2003, but I can't find it in 2007! Thanks, Gary

I'm building an order entry system. tblOrders contains one record for every order, and lines within each order are stored in tblOrderDetails, related to tblOrders by the OrderID. I've created a form to allow order entry (frmOrders). The form is based on tblOrders, and displays related records...

Is it possible to reduce the line spacing of text in reports generated by Access? Thanks, Gary

I'm building an order entry database. It has two tables (amongst others) called tblOrders and tblOrderDetails, related together on the OrderID field. For every order, there is one record in tblOrder, and as many records in tblOrderDetails as there are individual lines in the order (so, if, for...

I have two subforms on two tabs on a form in my Database. I need these subforms to update (requery) when the tab they are on is clicked, so that any changes made on one tab will be reflected on the other, when it becomes the active tab. Please can anyone advise me how to do this? I have tried...

I have developed a database in Access which has user permissions implemented. These are set so that only Full Data Users have permission to delete information. However, it has come to my attention that users can get around this by creating a query and then deleting records displayed in its...

This is a really simple question, I'm sure, but how can I specify which of the fields is active (i.e. has the cursor in it) when a form opens up? Thanks, Gary

I have a form to display records in my database and it has a delete button to delete the active record. My database uses Access user accounts for multiple different people. The delete button works when I use it (I'm the administrator), but when anyone else tries to use it, they get the...

I have a form with a button on it. When the button is clicked, the form it's on closes, and a different one opens up. This second form has a close button, which just closes it down. I want to modify the close button on this second form so that, when it's clicked, it closes the second form and...

I have a database which has a table of contact details. There's a separate table which contains related information about Appointments each of the contacts makes. There are then two forms: one which allows entry/viewing of Contact details and one which allows viewing of appointments by...