Search results

Not at all - thanks for your help, both here and in my other thread about validation! :)

Thanks for all your replies. I moved the default value to the form control instead of the table field, and now it works :) Gary

Ah - sorry - ignore my last post about the validation not preventing the update. I'd inadvertently set Cancel = True to False! It's fixed now! Many thanks again for your help. Gary

Thanks, so much for this, Bob - much appreciated. Just one last thing. Now that this problem is fixed, my validation isn't quite working right. My error message correctly appears if there is anything wrong with the input (i.e. it's missing or numbers are equal to 0), but the record gets...

Hi Bob, Thanks for this. I'm attaching a zip file with a sample of my DB. I've removed some irrelevant tables, and filled the rest with dummy data. Please ignore the fact that the form isn't very pretty - it's work in progress and I'll make it look nice once it works! Thanks again for...

No. Essentially, I have four (relevant) tables: tblEvents tblMaterials tblCentre tblProgramme The main form has tblEvents as its record source. On that form, there is a combo box called "Programme" which looks up programmes from tblProgramme and stores the ProgrammeID from that table in the...

Yes and no! There is a subform on my main form, but it's tied to the primary key of the main form. The fields that are generating this error are just using other details to look up the values they list: they only update a single table.

Thanks rainman89 and boblarson. I've used both of these methods for different forms in my database, and they worked perfectly. However, I'm now having a problem on one of my forms. When the validation fails, my error message asking the user to enter the details appears correctly. However, I...

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

Thanks, David. I managed to solve this before I saw your post, by simply recreating the whole query. But, for future reference, can you tell me why changing the code as you suggest would have fixed the original query, and how you know to write it this way? Thanks, Gary

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

DCB, Thanks for your reply. There will not be a massive amount of data - probably 500-1000 transactions (incoming and outgoing stock) each year, so I guess that probably isn't overly large. However, the data need to be available for archival purposes for 5-8 years, and I don't know if...

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

I've just discovered this web page, which explains how to hide the ribbon on load. http://msdn.microsoft.com/en-us/library/bb258192.aspx It works, except that it also modifies the Office button, taking away the "Print" option. Does anyone know how I could modify this code to make Access hide...

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