Recent content by Sadie Hewgill

I do want to use the attachment type field, just the way it is meant to be used for displaying .jpgs and holding other attachments. I want the attachment to be added to this field automatically, not opened automatically

no i hadn't heard of that before, that's interesting, and I found Hyperlink.Follow will get the path from a control on my form. But it is the same as clicking a hyperlink to open a file. Will this pull up a new window for the picture or will it save as an attachment and show up in the...

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

thanks! it worked

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

Oh, I should've known that.

I will keep the fastener_mm ID and other ID numbers as autonumbers since they have no meaning. Should these be my primary keys or should part number be my primary key? I don't ever want there to be a duplicate of a part number regardless of the type. They should be completely unique, but the...

I have seen the light and stopped using autonumbers. I did initially take the advice to get rid of the autonumbers, and switched to numbers, but then I switched back because it seemed they worked better. So now that swap has messed up my database, and I'm quite ready to get rid of the...

sorry, i should've given you some direction to the main problem in my db. If you open the form called Fasteners_mm Entry Form and try to enter a new record you'll see what the problem is. I am now working with numbers and Dmax for the field "Part Numbers" instead of autonumbers, but still the...

Here's my database. All the data in it is bogus right now, so that doesn't matter. I'm really starting to think I should have never used autonumbers, but they seemed to work so nicely. They automatically appeared on the form when I'm entering new data, giving me the next part number, and they...

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

This applies to some earlier posts about the original code for an error message: It took me awhile to notice this, but the error message pops up when ever I edit data that is not part of my primary key in the form. I guess it is looking through the table and sees that the same record already...

hmm, on second thought I think autonumbers will suit me better here, but thank you for the info on Dmax

I found a way to reset my autonumbers so now I think I will just go with that, and not delete any until I put the real data in.