Search results

I'm using Access 2007 and the attachment data type on a form, but it would be nice not to have to browse to the file I want each time. Is there a way to automatically retrieve the file I want for the attachment based on the file name being written in a different field on that form? For...

So i have this code that adds a new entry to my combo box list, and it works great for text data types. I want "length" to be a number type, but I don't know what to change about the syntax to make this work. Private Sub Length_NotInList(NewData As String, Response As Integer) Dim strTmp...

I'm not sure if this is the cause of my troubles, but I have my suspicions: I deleted relationships so I could change the type of my primary key field from autonumber, to number, and then back to autonumber again, so it would reset the autonumber count from one. Whatever the cause, it has...

I have a form where I want an error message to be displayed if there is a duplicate (considering the data in about 10 fields). I would like it to allow me to leave these fields blank though, and it can count blank fields as being identical too, or just ignore them. The thing is, I don't want to...

I am making a QBF and I used the format on the ms access website to specify the criteria that will search for the filed on the form: Forms!FormName!ControlName Or Forms!FormName!ControlName Is Null This does what I want and works for a few fields, but the Or section automatically separates...

How can a user delete a record? I want to restrict user access to the form level, but htey need to be able to edit and delete records I tried putting a command button on my form that could delete the record, but this failed to update my tables. What's worse, it only deleted the record from my...

My database has a table called part numbers with a list of all part numbers, as well as the type of part. The part number is the primary key and should only correspond to one part. Then I have two (and eventually there will be more) tables that contain information for each part type. One is...

I don't know why, but I have created an index and now can't set any of the properties for it. It has multiple values, but I have tried setting indexes with one values, and still the properties options are greyed out. There is no place to enter yes/no for uniqueness. Any suggestions as to what...

error message for duplicate entry I have two primary keys and when duplicates are entered in the form, it is not allowed. I would like to display a custom error message that gives the user the option to go back and change the information they entered, or to be taken to the form with the...