Search results

jz, as much as I agree that I should build in all potential functionality so that users only interact with data via forms, the hardcore reality is that scope of this project and time frames don't allow it :( That said, thanks for the reminder about QBF, I haven't used that in a long, long...

Sorry, I just opened it and figured it out. I didn't realize you had populated the fields. Can you give me some advice on something? I am concerned that the structure may be complex for casual users. I bring this up because of my scope and time constraints. The company wants to have some...

Ok so, can you explain how the results table is used?

BTW, for your info (and other viewers), I kind of cross posted on another board here: http://www.utteraccess.com/forum/find-record-specific-t1948896.html. I didn't mean to confuse things but the question I asked here was more philisophocal in nature which has become more practical and specific...

jz, forgive the tardy reply. I must not have submitted my message on Tue eve - I probably had a session expired error that I didn't notice. I spent some time mapping collected data to the structure you've recommended and I'm not sure I understand it completely. Can you explain the purpose of...

jz - as always I'm grateful. I have spent some time with it this afternoon and do have some questions but I have to go out for a few hours so will post when I return.

Most of this is captured in the field types above but more specifically (note, I'm using the present table structure in descriptions so you can quickly connect it to information already provided)... In the product table are the product details: species, thickness, # of items per measurement...

There aren't any parts - just wood that's machined to make a final product. Therefore there is no assembly and no inventory of parts, just final product. I'm not even tracking the volume going in, just out. I may have led you down a wrong path to start. To clarify, this is a performance...

How will we capture shift details (ShiftName & ShiftDate) and how will they relate? Shift and daily productions reports will rely on them.

...and as I get through this, I'll likely have more q's...:)

Believe it or not, I am familiar with normalization and can challenge it when working with programmers in my real job. I agree with everything you said and I did take shortcuts out of necessity so your chastising is well deserved. The resources you provided are great refreshers since I'm not...

Here are a couple of examples with table names and some field names made generic. I hate to be so vague but I have an NDA in place with my company so have to be careful not to spill too many secrets :) So one of the reasons I did the process and inventory steps in separate tables is they are...

Thanks for your feedback jz. I am in a hurry to get this done so I tried to take shortcuts. You're right that the structure wasn't properly normalized. I was conveniently ignoring that fact because I built it based on data entry which had all the tblProduction fields on the main form with...

I am challenged by knowing the best practices with respect to getting a result I need programmatically or via a query result. Any advice on the following scenario is most appreciated. I'm simplifying for demonstration purposes... The user enters production data by date, shift and product. In...

Thanks so much g for the quick response. That's great advice and I will incorporate it because in this particular instance, it's actually my error trapping code that's looping :( I'd still love to hear from anyone that has an alternative because sometimes you don't know it's going to...

I have a new Dell Studio 17 which doesn't have a Break/Pause button (!?). I have an endless loop problem and I can't interrupt the code execution in order to debug. I've researched this issue and found one alternative on another site and here...

But let me explain what I actually meant. Since the borders of your textboxes are not visible, you don't need to hide the control. If the value is Null then it wouldn't show anyway. Meaning you don't need your code at all. Duh! I'm not very bright am I? Of course a null value wouldn't show...

vbaInet, I took your advice...at least what I interpreted to be your advice :o. I don't think I totally got it. But it seems to work now. This is the new PerUnit calc: PerUnit...

I just figured something else out, when I view in Layout view the txtPerUnit values show but not in print preview which explains the outside pdf writer anomaly.

I found the culprit... Bob...before I strip the db of sensitive info, can you review the following to see if you can spot the problem? It's probably my clunky logic. There is a weekly price and a daily price available for items in a catalogue. The user selects whether a quote will be based...