Search results

Hello, Hopefully no one is irritated by *another* send report by e-mail post, but everyone I see is for doing much more than what I need and I cannot get the code to work. I would post the send code I have, but it is so broken I think it would be useless for figuring this out. I have tried...

I am haveing this exact same problem and it has proven to be extremely frustrating. I have linked the subreport to the report in every way the interface allows. Using all combinations of linkage provided in the wizard interface, as well as manually linking child / master through the properties...

Thank you Hayley, very appreciated... I hope to make this work! BTW: I use Outlook 2003, some users will have Outlook 2000, is this going to cause me problems?

Believe me, I would rather not have to mess with it, but *someone* seems bent on having the feature, to the point where he thinks that it would just be better to create ANOTHER Excel spreadsheet to redundantly ener the data into so it looks pretty. At this point in learning about Acces I am all...

Agreed! We are looking at a MAS 90 / Sales Logix implementation as soon as budget will allow, but for now it is imperitive to get rid of all of our different spreadsheets for each step of the sales / service process and eliminate redundant data entry so we don't have to hire more and more...

Doc, I have read this again and would like your thoughts on this, tracking PO's doesn't seem to necessitate cycle redundancy: tblCustomers > tblOrders > tblOrderDetails > tblSerialNumbers I was asking before if it would be more wise to tag the tblSerialNumbers directly to tblOrders and bypass...

We sell heavy duty equipment, tools, automotive repair machines, things of that nature... One sample product would be an engine crane. Garage stuff like that... too many to list. We are a paper organization now, with spreadsheets all over the frikin' place! We will continue to do hand counts...

I'd like to piggy-back a quick question on here if I could... In my Audit log I am adding in, I am noting record activity in a memo field in an Audit table. I am using VBA to note the following: - Now() - logged in user (by global variable) name - Environ(user) name (or however that goes...

What happens is there is a front office employee who processes orders, and assigns serial numbers with the following method (roughly): - Container's order date - Load number (2 letters (manufacturer) & 4 #'s (order # from that manufacturer) - model number (3 letter combo) - product number (4...

Thank you for the insight Doc. What is your evaluation of the super generic outline I provided in the graphic above? Do the relationships appear to be workable? I am starting to realize this may prove to be a nightmare months from now, but if I can make something that will work, it would be...

Whaddup once again Dave, (I'm proving to be quite the problem poster huh) I will give you an outline (you asked for it!): Our database has two functions: Sales and Service CustomerID is the easy way to tie those together, but then you get into one other thing: Containers. We import product...

If I did go with the Many to One relationship to handle this, I was thinking it may be more simple to just use OrderID as my FK instead of OrderDetailsID to make queries easier... that was I can avoid having to include that extra table in my queries when I pull this all back together... Hell I...

You two should open a consulting firm together :D Thanks a ton!!!

Thanks RG, are you saying that it would be unwise to use the Quantity / Model design here and I should just go with individual items? That would work fine for typical orders, but if someone ordered a container full of 30 - 50 products, that might become a pain.... Thanks

Here's what I've come up with so far: tblOrders - OrderID - ShippingCost - TaxRate - REST OF FIELDS (irrelevant) tblOrderDetails - OrderDetailsID - OrderID - Quantity - ProductModel - SerialNumberID - Price - Extension NEW TABLE: (Maybe I should name this tblProductSN to make sure it is more...

My database uses a common structure (from what I understand): tblCustomers tblOrders tblOrderDetails so, when an item is entered in, the following is recorded (the field names may not be right, but you 'll get the effect): tbOrders: TaxRate ShippingCost tblOrderDetails: Quantity ModelName...

What will cause the results of a query to be uneditable? One to many relationships? Sometimes they are editable, sometimes I get that fantastic *ding whenever I try to edit the results of a query... Thank you!

The 3 fields are Yes/No fields in the tblOrders table with the Display Control set to Checkbox. I think that I may get rid of these fields anyway, because they seem unnecessary... Still don't understand why they don't work :confused: A tangent: I would be able to do the same thing with filled...

I'm far from an expert as far as Access on the web goes (or Access in general, beginner here too), but here's my understanding: The database (at least the back end) would have to be hosted on a server so that it is accessable to the web. Then you could use data access pages to make an interface...

The site will not open for me, (I am in the US), but my advice would be to go to the people you said you had develop the site for you, it should not be your problem to fix, other than griping about it and making sire they fix it for you.