Search results

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.

unfortunately there is a system already in place. We have already assigned numbers to real parts and now those numbers have meaning. So I have to be able to change the numbers I am autogenerating to be these specific numbers, and then I would like to have them sequentially generated after...

Hey thanks a lot, that works much better now! The form that I have enters the part number into the child table, and my autonumbering used to come from the parent, so there was always a record existing in the parent table. Now I need some way to create the number that I get from the Dmax +1...

I looked into using Dmax like you suggested earlier. The compiler doesn't like the line: LMax = DMax("Part Number", "Part Numbers") + 1. I think it's just the syntax, but I am new at VBA. "Part Number" is the field in my table "Part Numbers" is the table. Here's the code: Private Sub...

I am having some technical difficulties uploading my database. Can I send it to you in email form?

Ok, so here's the dilemma then, I shouldn't be auto numbering my part numbers because I want to get them back if i delete them. But I want the numbers to be sequential and the user to automatically be presented with the next available part number when they enter a new part. I have heard I can...