Recent content by mama16

Hello Guys, First of all, I have a form with several fields. Two of those fields, I set them as Ole Objects. They are going to hold wave files. On the form, I right click on the; for example one field, then a pop up window shows. I choose "Insert Object" then " Create from File" then I look for...

First of all, I'd like to say hi to all you people. I have a bunch of tables that are all linked. There is a one to many link that I'd like to change it to a one to one. How do I go about doing that? On the E-R diagram session, when I drag the field (PK) to the other table (foreign) Access makes...

Thanks again Richard. This might be something simple but I'm not getting it to work. I changed my design a little bit. I'm actually making HWY+EXIT to be unique because even though I will be entering the data, I don't want duplicates. In design view, I'm selecting both HWY+EXIT and then hit...

Thanks a lot willir (MIS) for your comment. I liked your design, you actually included more information than what I need. I see that on the tblExit you indexed both Hwy and ExitNum with no duplicates allowed. That can not be possible because Highways and ExitNum are going to duplicate. For...

Richard, Thanks for everything. I really appreciate it. The reason I created the tblHighway is because the Highways are going to be static. Currently, I'm doing it for the state of Tennessee and I don't think those Highways are going to change. I'm hoping they'll never change!!! But I like your...

Randy, on the previous e-mail you mentioned that my tables were not normalized. I've been learning Access for about three months so I'm not an expert yet. Why aren't they normalized? I'm linking both table by Highway as a one to many relationship. please share any comments Thanks.

Thanks Randy, This is the code I have Private Sub cboHighway_AfterUpdate() Dim strSQL As String strSQL = "SELECT EXIT FROM tblExit WHERE HIGHWAY = '" & Me.cboHighway & "'" Me.cboExit.RowSource = strSQL Me.cboExit.Requery End Sub Also, the tblHighway has one field HIGHWAY...

Randy, I'm getting an error "Method or data member not found then Highlights me.cboExit.rowsource" tblHighway contains one field, all the Highways. tblExit has two fields Highway and Exit On th e form I want the drop down box to pull the Highways from the tblHighway. When a person chooses a...

Hello, Currently, I've created 5 tables. I want to create a form for data entry. I placed a few drop down boxes onto it along with some text fields. I want those boxes to pull the info from their corresponding tables. I can not get it to work. For example, when someone is doing data entry, I...

I forgot to ask you about your comment "And with the wave files, it just may be easier to store them internally within the Access database. However, if I were to create an HR database that included photos of employees, I would store the images as jpeg files and link to the photo within Access...

Thanks willir! I modified my tables a little more and I think this make sense now. The answer to your question, I'm selling a service to some customers. These are gas stations, Restaurants etc. Detailed information about merchants, located by Interstate exit will be on a database. This database...

Thanks a lot Richard. How can I store the .wav outside the actual database. Sorry, but I'm a little confused. I created the table with the fields "Name" and "Details" and made them OLE type. Also, I added more tables than what I had before. Please, let me know what you think. Table A Highway #...

Why am I getting an indeterminate relationship? I have this table that I want to join as a many to many relationship. How do I go about doing that?

Please, any feedbacks?

Just before I start building this DB I would love to get some feedbacks from all of you experts. This database will have 10 fields. These are, Service Name, Text Service Type, Drop Down Box Highway #, Drop Down Box Exit, Drop Down Box Priority, Drop Down Box Phone...