Search results

True enough about the thread title - I'll close it out now. In case anybody else has the same (dumb) problem here's the deal: I couldn't update my query because I was doing the join backwards. One table: tblOrder Many table: tblTrackingNumber I had a field in tblOrder:TrackingNumberID and...

I'm totally stuck. I think I do need to put the memo in a separate table for proper normalization. I can't figure out any way to write a query that gives me the list of order numbers with an editable tracking number. It seems like it should be so easy! Please help! Thank you, Evan

In my case I am storing the Tracking Number for a order, and several orders may have the same tracking number. Wouldn't I be breaking all the normalization rules by storing this many times in the order table?

Thanks Mike - that's good to know.

What if the memo field is only used on 1 of every 10 records? Do the unused records end up eating a lot of space? Thank you, Evan

I've read that it's best to store a memo field in a seperate table, so I've got 2 tables: tblTrackingNumber & tblPurchaseOrderItem - one to many. I can't figure out why I can't edit the tracking number in this query: SELECT tblPurchaseOrderItem.PurchaseOrderItemID...

Mike, I have about 6 different types of possible links between items. Most of them are one way, requiring one record. Substitution is two-way - that's why I have two records. If I were only doing substitution, I would probably use a different data structure. As you stated, a solution that...

I have a table that shows links between items in an ordering database: SourceItem TargetItem 1000 1001 1001 1000 1001 1005 1005 1001 Item 1005 is not directly linked to item 1000. Is it possible to return all 3 items with a query? Some type of...

Am I correct in concluding that nobody really uses Data Collection then? Evan

I'm about to jump up to Access 2007, mainly because of the Data Collection feature. My database sends out emails to our suppliers requesting the shipment of various items. I want to use data collection so that they can reply with delivery dates, etc... However, I read that the Data Collection...

I would use the dual listbox or dual subform approach. One for available locations. The other for locations assigned to that supplier. The use 'Add' and 'Remove' buttons to move locations from one list to the other.

You use the query as your datasource for the report instead of a table. In almost every case, a query can be referred to just like you would a table.

or... if Me.Dirty then me.dirty = false This triggers the save event and works like a charm

Yes - the name of your subform naturally - not the name of mine. :)

Where are the results for your query showing up? In a SubForm? If so, in the AfterUpdate event of your textbox put: MySubForm.Requery

Trye the "*" in front and behind like this: Like "*" & [SearchPhraseFormatted1] & "*"

I got something working after reading the link you posted again. qryCurrentStatus is the aggregate query which only has the two fields. Then in a new query i have tblOrders ----> qryCurrentStatus ----> tblStatus. I can grab the data from tblStatus that I couldn't put into the aggregate...

Banana - it's no problem to do as you said for 1 for one record by supplying the OrderID, but I need to see every orderID with the most recent status. HiTechCoach - your example was just about exactly what I needed, but the only problem is I can only include two fields in the aggragate query -...

My 2 cents (if it's not too late). I saw no speed loss using dlookup until i split my database and placed the backend on the network. Then things were really slugging - almost 2000 milliseconds during each record change. I replaced every dlookup with allen browne's elookup, and tweaked a...

I have two tables in a one to many relationship - tblOrder and tblOrderStatus. How can I create a query that returns each record in tblOrder and only the last matching record per order from tblOrderStatus? I've tried using a subquery for tblOrderStatus - with a TOP of 1 - but this only...