Search results

You can use DLookup to check for the existence of a value and use an append query to add a value to the table.

You can set LimitToList = false and then use the beforeupdate event to check if the value they entered is in your table of acceptable values. Then you can do what you want from there.

Writer's Block - Training Tracking DB I have created a db that tracks training courses, classes and attendees. A course can have many classes and a class can have many attendees. The database also stores links to course documents and class notes. I think there is a lot more I can do with this...

Except in the cases where Windows assigns a different drive letter than usual. Don't know how common that is nowadays but my school of thought was always use UNC. Alas, there are pros and cons to any decision you make in life.

I can't tell by your description how you set up the share but you should make sure to use UNC paths (\\server\share\) when linking tables instead of mapped drives (D:\) or even (\\server\D\). Just FYI

Thanks for the rep! Hope everything works out; if not, you know where to find us!

When the second form is opened with link criteria, then the first form is saved, will the link criteria auto update the data on form 2? Or, in other word, would it not be best to place the save command BEFORE the OpenForm command? I have no idea because I don't use link criteria very often.

Right you are. I guess what I meant is that I'm not used to working with these types of database models so I might be a little slow on the uptake. Like LagBolt said, I don't feel that I fully understand Smart's model.

I've seen AMAZING things done with Access in regards to surveying, so yes I'm sure it can be done. The trick is explaining it to us regular folk who don't wrap our heads around coordinates on a regular basis.

Don't forget to back-up the data regularly!

Sounds like you will need at least 7 tables. This will allow the many-many relationships you describe: tblPolicies - PolicyID (pk) - Subject - EffDate - RevDate tblReviewers - ReviewerID (pk) - FirstName - Lastname tblPolicyReviewers (junction table) - PolicyID (fk) - ReviewerID (fk)...

When you say that this database is going to be linked to Excel, what exactly do you mean by that? The reason I ask is because it looks like there is a lot of opportuniy to normalize the data. You may get more meaningful and easier reports out of it once normalized.

While I don't have an answer for you, I see that others have had the same problem: This seems to be an issue with Encoding or Language and Regional Options in the Control Panel. http://www.access-programmers.co.uk/forums/showthread.php?t=116786&highlight=export+encoding I hope this points you in...

You can accomplish this by changing the location field on the input form to a textbox, then set it's default value to [Forms]![form1]![location name] Before you do that though, I would rename all fields, tables and objects so they do not contain spaces in their names and choose a naming...

That can be toggled by the form's Modal property. The form's pop-up property may also be of use to you. When a form or report opens as a modal window, you must close the window before you can move the focus to another object. When a form or report opens as a pop-up window it remains on top of...

Hi Bob, Thanks for the rep. Couldn't have done it without you.

Quite alright. I know, I've done it before. Just have to take a step back and clear your mind sometimes.

Can you place a break in the code, step through it and identify what part of the code generates the message?

I figured out how to fix it, but I still don't understand why it acted like that. I had to change the form's AllowEdits property to Yes.

I have this code on a form that is usually displayed through a subform control of another form. Private Sub Form_Delete(Cancel As Integer) If MsgBox("Are you sure you want to delete this note?", vbYesNo, "Confirm Delete") = vbNo Then Cancel = True End If End Sub When the form...