Search results

Ive done that once before with a datasheet subform and really liked the result it provided.

I did not know you could prevent the subform from loading until the tab itself was clicked. That would make a form much faster if you were dealing with large recordsets in each of the subforms.

I do like tab controls. I found I started to use them a bit too much though and had them all over the place packing probably too many things into them. That was when I started moving more towards changing the subform controls source. Both methods I found still have the problem of sizing...

I am curious to see what you all prefer when it comes to form design in regards to forms that have, or could have, multiple subforms. I personally like making smaller subforms their own form as a pop up, but then you lose the ability to do master/child links which can be troublesome. If I have...

I fully agree at this point. I am stopping and thinking about it more.

Sparing all the gritty details and giving the short answer, it would be the part number that would be the identifier.

Ok, I have reordered it a bit. My logic is a job can have many fixtures which can have many different sell prices and quantities. A fixture can have many cost, notes and types. I am still not sure if I have the many to many correct though.

Carletto - Sure thing! In reference to the example quote in #13, "Type" is the unique identified for that given product for that given job. Types can repeat from job to job, but the product the type is identifying can be completely different as they don't relate to each other. In my current...

Lines like 14 are what would probably be known as a kit. The top most item (in regards to 14) is the LED engine (the actual light) and the bottom part (the JPDZ4RDNCMF) is the housing that it goes in. There are likely a multitude of different LED engines that could go into a variety of housings...

I am having a really hard time trying to describe the process and I am sorry for that. Let me preface with this may end up long winded but my overall goal is to (re)create a app that we can use to quote/bid lighting packages for construction. This was the first Access app I ever created and...

Ok, here is how I now have it laid out: I did sale the same as cost but there are technically only two options (% Markup or hard entered price) as well as comments (internal vs external). Does this look more correct? Edit: I just noticed myself failing on naming again. All fields in...

For the differences in how the part number is presented, I believe I have decided all strings will go through a process to remove all spaces and hyphens to make them all one solid string as this is how we prefer it and it would be significantly harder to do it any other way. Pat - For this...

Thats not bad at all. The Honda Rune I keep eying at my local dealer is I think an '04 or '05 (they were only made for like a year or two) is sitting in their showroom with a 20k price tag lol.

O an Indian, very nice. How much is this going to set you back? Those bikes are not known for being cheap lol.

I see. I will make those changes and report back once I do them to make sure I understood what you said. It likely wont be today however as I am being pulled away to another project. Thanks plog!

You are correct with the naming Plog and I apologize for it. Its one of my worst habits when it comes to these things sadly. I had used the JobComplete and CompleteDate for two different things. JobComplete was shown on my forms to flag a job as done and then I had some code that time stamped...

I have done went and confused myself. I may just be overthinking this way too hard. The problem I am worried about is a part number coming across 3 different ways. Such as IBL 15L WD LP740, or IBL-15L-WD-LP740, or IBL15LWDL70.

I am rebuilding one of the first Access databases I made several years ago and have run into a problem with correctly normalizing my product table. Here is what I have so far: I have it this way as a product can have many prices due to different projects, quantities, end user etc so I felt the...

I dont know why, but this reminded me of a quote I heard in a movie once, now whether or not it was a legitimate quote from someone or just part of the movie, I do not know. The quote was (paraphrasing): "People are inherently violent. If you lock people in a room, it wont be long before they...

My first street bike was a (I think) '04 Honda Shadow. That proved a bit cramped with a second rider but was a nice learning bike. I upgraded to a '02 Honda VTX 1800. Thing was an absolute monster compared to the Shadow but was so much more pleasant to ride. Also was interesting to learn a...