Search results

I think I found a thread that will help.. I found this and am going to try working it in. It seems to be exactly what I'm looking for. http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=56642&highlight=foreign+key

Almost got it.... O.k. so I figured out my own way to connect these forms but it doesn't seem to be going as well as I planned. Heres what I did: The customerinfo form up top contains a customer number. In the customer service (complaints) subform I created a box for that customer number. That...

Sorry to be a dork but where would I find that? On the media, in help, or where? Thanks.

one to many relationship.... So as it turns out I can't create a one to many relationship between the autonumber customer ID and the autonumber complaint number. I can only guess that has something to do with the fact they are both auto number. However I had a stroke of genious to just ad a...

O.k. So the following problem has probably already been solved on these forums a million times, so if you know what I should be searching for I have no qualms doing the work myself. So here goes: I have a form for customer data, and a sub-form for complaint data that customer gives. Each...

Resolved, thank you... So I figured out what the problem was. There was bad code in the database when I started working with it. But since I wasn't the owner of the database all of the changes to the code that I made didn't really get applied, they just appeared to. What I had to do was make a...

I finally did get it.. This might help other people So I finally figured out what was wrong. You were all telling me things that were exactly right, my problem was on the rights end. See, I walked into the job of this database that had already been started by somebody else, so they owned the...

Hey anyone, So I thought I've been getting the following error because of bad requery code. "invalid procedure call or argument." but when I delete all of the code in code editor and leave absolutely nothing, I still get that when compiling. Where might I go in the database to figure out what...

Re: I DID IT!!! So I'm a freaking liar. It worked for a minute then back to the same problem. Any more words of advice? thanks.

I DID IT!!! Mile-O-Phile, I really gotta thank you. I figured it out, I was missing one line in the event. Here is the code I should have had. Private Sub description2_AfterUpdate() Me.specific2 = "" Me.specific2.Requery End Sub Thanks for your help. cheers.

Fixed that, any more help.... I still get an invalid procedure call or argument and the first line is highlighted in yellow in code mode. Private Sub description2_AfterUpdate() Me.specific2.Requery End Sub Private Sub Form_Close() DoCmd.OpenForm "switchboard" End Sub Whats wrong...

should I be able to compile this? When I try to complile the simple command I get an error: Invalid Procedure Call or Argument. Am I missing some kind of connection on the code side that I don't know about. This is what I have so far. Option Compare Database Private Sub...

I think that perhaps I havent' set the name of the field correctly. It seems to think it cannot find the field. What is that part of Me.SecondComboName = "" for? is that how I would set the name of the combo box to requery?

Now its worse.. So I tried to fix that some more and now I get invalid procedure call? what am I doing wrong?

error? O.k. so I did what I think is exactly what you guys have running I opened the event procedure in code view and copied exactly whats in the examples I have except substituting my field names of course. Now I get the following error. The expression AfterUpdate you entered produced the...

Hey guys, Thank you for all your help thus far figuring out cascading combo boxes. I've searched and read quite a few of the posts and they have been indespensable. I have one last question. I have a cascading combo of two boxes. When you select the item in the first box you get the proper...

Re: Re: First Timer In the after update of your Customer combo box you need to type: Me.cboModels.Requery I think this is where I went wrong... where does this go?

Almost got it... O.k. so I've been following all of this trying to get it to work out. However in my DB I get asked for a parameter value. What am I doing wrong. If you want the files let me know but its like six tables.

will do... thanks

I would like to build a set of two drop down menus. The first has a list of problems, the second has specifics on each problem. So what I want is when you select a problem on the first drop down menu the second only has the specifics for that drop down item, and for every other drop down item in...