Search results

Plog!! I tried to send you a PM but I think I am not seeing it in outgoing so I'm paranoid it didn't go through. Get in touch with me! We all want to send you stuff from the business you helped get back on it's feel database-wise!!

We would love to send you goodies for you and your family- please send me a PM! It'll make us all so happy sharing what we do with someone who helped us do it better. But YES so far it looks BEAUTIFUL. And you know you'll hear from me if something goes nuts lol. You rock my socks off. Period...

Seriously- send me your info and we'll send you something! It's the least we can do. Our team thanks you!!

YESSSSSSSSSSSSSS!! Paul, you are my hero today! Do I need to separate it in any way from DoCmd.OpenForm "FStockArtProduction", , , "ID = " & Me.ID? Or just put it in there right afterwards?

Let me see if I can better explain because I soooo appreciate your help and don't want to waste your time. I'm going to try to get us on the same page. We are an apparel printer. We (brilliantly or stupidly, I'm not sure which yet) specialize in offering 10 in-house printing processes. So...

Not yet. (un)Patiently waiting here: http://www.access-programmers.co.uk/forums/showthread.php?p=1342489#post1342489 Any suggestions?? I'm a sponge today and I LOVE it.

In a nutshell, yes. This "feature" was added by M$oft, but has not been accepted generally. It is not compatible with other database systems, and tends to get people into confusing situations. I would not use it. I am on various forums where it is discussed and there appears to be no...

I think I understand the theory of what I'm trying to do here, but being brand spankin new to VBA I've only got half of the idea working so far: I have a Project form, which holds StockArtProduction_Subform in datasheet view. I have it able to click on the ID in the StockArtProduction_Subform...

And I'll take the rest of the question over to the VBA section- since I guess that technically is where I am at. Thank you for getting me past my first hurdle!!!

This is actually a new concept to me. But I want to do things right this time. So, to make sure I understand, every time I used the Lookup Wizard in a table field I should have created a separate table? For example, I have tblCustomers and tblProjects. tblProjects has a lookup for CustomerID...

Why are y'all such geniuses? That worked perfectly! THANK YOU x A MILLION! I hope I'm not pushing my luck, but any suggestions on clicking the "new" entry and having it automatically enter the ID from the open form?

Thanks all I'll report back!

I'm estatic to attach for review! It's all dummy info (that'll probably be fairly obvious). Just testing functionality because I've already built the pretty version once just to find out it didn't work... and was unsalvagable :banghead: The link is the ProjectID. I don't know if this is...

Maybe I'm just saying it wrong (I'm self taught so my "jargon" leaves something to be desired) because I feel this is pretty fundamental and used a lot... but I've hit {yet another} wall in finding info. I'm already a solid month behind on this project so any help would be massively appreciated...

Cool so here's to onward and upward! I'll see everyone in the forms section later I'm sure lol

That's kind of the way I thought it was... So, is it accurate to say that as long as I can visually put it together without loops (as I did by using duplicate tables) that my database should be ok to move forward with?

Whoops hit a snag. I saved, closed, re-opened and some of my relationships snapped themselves back to one tblEmployees. Ideas?

You got it! THANK YOU SO MUCH!

Yes I feel very comfortable with this now! Thank you for giving me the missing puzzle piece! I'm hoping that some of the same moves I used previously will work now because the circular relationships are gone :) Moving forward, since I know exactly where I ran into an issue before (Projects...

I think it "clicked". I want to make sure, if this is correct, that I did it the correct way... To get the additional tables I just clicked add tables and added tbl Employees several times. From there I just deleted old relationships and added the new ones. I did everything in Relationships-...