Search results

Sorry, forgot to attach the database in question earlier. Here it is.

Okay, thanks. Will delete original post now.

I wasn't sure which forum subject to post in, my apologies. I thought (after my original post) that this would be the better forum to post in, but dont know how to delete my original thread...

I'm still learning Access, studying normalization now and need some help figuring out if I've successfully converted an un-normalized database into 3NF. This is the un-normalized table: * tblOriginal (ClientNumber, ClientName, ContactName1, ContacPhone1, ContactName2, ContactPhone2...

hi, yeah, I got it working thanks a ton! Now I'm studying normalization. It's a little tough to grasp the idea, but I'm slowly wrapping my head around the concept. I'm sure I'll post with questions about that too.

How do I do that? I tried writing this: =tblOrders.Column(2) in the textbox of the combo box in design view but it doesnt work... I dont know how to "bind it to the correct column". Still learning access, sorry...

**bump** Need help getting this combo box to populate the customer number to the Orders table...Please?

There is a field in the Orders table for customer numbers already, but after i've created a new combo box to select the customer number, it doesnt work. It gives me an error. Heres what I'm doing to create the combo box (Let me know if i'm doing something wrong). 1) Select "Look up values in a...

yeah, thats the combo box i'm having trouble with. how would I bind it to something, and what would i bind it too?

I'm new to access, still learning, just learned about forms this past week and am practicing building one that lets a user update or add new orders to existing customer orders, but it isnt working rite. The form works for the most part, but there is one field that doesnt populate to a related...

That, and what pbaldy said "You want column 1 rather than 2, as that property is zero based." Those worked! My subform is now showing the part descriptions! Thanks! But still having a problem with it... What I described in my last post, about the part number combo box. If a customer orders 3...

Okay, didnt know I could do that, here you go. My form is still messed up. It's not even close to final version. I wanted to tackle this unknown before I moved on to formatting so please excuse its awful state. Also, one thing I couldnt figure out was how to make the sub form combo box select...

Well I've tried to dissect the file you gave me to better understand what I'm doing but have only managed to accomplish a higher level of frustration lol. Here's what I have so far (and it isnt working...): I made a combo box (Combo29) in the subform that allows the user to select a part...

Thanks for the quick reply. I should've said that my "source" told me that a DLookup would be the best way to handle this situation. Apparently he may have been mistaken? Either way, I'm new to MS Access and Forms and am trying to learn, so thanks for the file, I'm looking into it now and...

I'm not familiar with the DLookup function, but am trying to accomplish a task that I know should use this function and need some help with the code. My scenario: I have a "Add or Change Customer Orders" form that displays the OrderNumber, OrderDate, CustomerNumber, and CustomerName. This form...

Yeah. Earlier I just wanted to know the limitations of queries E.G. what you could and couldnt do with them. I bought an MS Access book and am now reading about forms and soon to be doing the practice exercises accompanied by those chapters. Looking forward to learning more about forms. :)

I see, thanks for all the help. :rolleyes:

I understand that a form would be the best solution, but I am a beginner to MS Access, still learning, and am curious if you can set validation rules for a parameter query... I assume you can't?

Thanks for the help. I found a minor flaw in this query, in that if I enter a non-numeric character when it asks the user to "Enter a percentage", it errors out. Is there a way to set a validation rule in the query that will only allow numeric characters. If a non-numeric character is entered...

I understand that forms may be better in this situation, but I am required to do this with a query. Is there no way to do this with a query?