Recent content by qurn

Thanks looking at the picture I can tell that this is exactly what I'm looking for, Thanks. I'll be looking at the code but it seems to be a bit needlessly complicated. The good news is that I wount need a button, the form will be used for adding records only, so clicking on the hyperlink box...

I have a form that is going to be used for adding records, but it's going to be used by other people, so I'm trying to make it as easy as possible to use. So one of the fields is a hyperlink that should be linked to the file you'd want to veiw, making one of these may be a bit too complicated...

Alright I found out this can happen if you have the ID field in your subform. now I'm getting error message You tried to assign the Null value to a variable that is not a Variant data type. (Error 3162) I'm going to read up on this, but I don't see why I'm having this problem.

I have 3 Tables One named "bulliten" one named "whomakes" And one that combines the 2 named "bulrid". I have a form with source "Bulrid" Who makes is chosen with cascading combos, and the bulliten information is suppost to be filled with a subform. but every time I try to put some info in the...

Ok, sweet, thanks. I see know that you need to use a subform. I was using one single form based on a query, so there's the indiscrepancy. I'm assuming I can make it look like only one form without it looking like a form with a bunch of subforms on it? I'll try this out, but just for curiosities...

any help from anybody? :(

Ok, I tried that it never seems to work for me. Do I need reinforce referencial integrity in order for it to work?

Well, I need it to complete relationships for updates. I'm trying to get it so my users can update from one form. I don't know how else to put it. The info is spread acrost a couple of tables then put together in a query (fairly common). Even with the relationships it's not automaticaly filling...

I have the same question, I'd like mine to copy from an auto number column after update, and I'd like to do it in VBA. Could I get the code for that please?

Thanks for your help so far. Well, I'm still running into a dead end here. So I stripped the database of all inmportaint and volitile information. If you also have any idea on how to make this thing better please let me know.

here's some screen shots, It should be easy enought to build really quickly on your own, if you feel so inclined.

I'd love too but I'm dealing with not only the states information, but the information of several private companies. My boss wants to make it public, but my bosses boss doesn't, and I can't say for the other companies. I can get you screen shots of the relationships and forms, I just can't send...

yeah I checked those, they're both set correctly. I noticed that when I put in information it's filling up the Bulliten table. I checked everthing and made sure that the source fields where set properly, even used the Expresion builder, but it's still only filling up the bulliten table, and not...

Yeah I tried updating from the Query and it does work.

Let me explain my database. Although there is lots of info. in it there isn't much to the infostructure. I have 5 Tables: Bulliten: ID (auto number) Bulliten name Link (is a hyperlink to the actual file; *.pdf, *.tif, etc.) Date Ride Name Ride ID Ride Name Manufacturer Manufacturer ID...