Search results

Mark- Your idea is a good one however I think the vbarchive is there just for this reason. The other problem is that some files change the modified date simply when it is opened. I don't know this for a fact but have read this. I would check for vbarchive of 32 (i.e. the file is ready...

Hi- I'm using a function to find all files/folders in a specific directory, then copy each one to a specific destination folder. I'm going to use this on a weekly basis to backup files on a computer. I would like to use the vbarchive in GetAttr/SetAttr so I only need to copy these if they have...

"as per #7" "See #12" . what are you reffering to?

Maybe something like this? I don't know the correct syntax however... Dim LFindBox As Long Dim LtMinbox As Long Dim StBox As sting LFindBox = DLookup("pricetoship", "cardbrd", "[dim1] > [shipdim1" And "[dim2] > [shipdim2]" And "[dim3] > [shipdim3]") LMinbox = DMin(StFindBox) StBox =...

My lack of knowledge! That's what I attempted with no luck. I tried something like this: boxesthatwork: DLookUp("cardbid","cardbrd","[dim1] > [shipdim1]") query can't find [shipdim1]. The 2 table cannot be linked and I don't know how to reference the Product table where [shipdim1] resides...

I've already done this- the user selects the appropriate boxid from a combo box. I have 7000 items and the turnover is great. Box sizes also change periodically. I need some sort of code or sets of queries where the boxid is set for each item

"smallest fit" for this purpose is the dimensions. I've arranged the product dims and the box dims so that the greatest dimesion is dim1 and the smallest dimension is dim3. Therefore, I need to somehow execute the following: find the boxid's where dim1 > shipdim1. then, from this list, find...

LOL- post has been fixed. much easier to understand. spikepl- Maybe something like DMin("dim1", TblBoxes, "dim1 >= " Me!shipdim1) however I need the code to incorporate all 3 box dims.....

Hi- I have products listed below: item shipdim1 shipdim2 shipdim3 ITEM10 28 28 11 ITEM11 13 11 2 ITEM12 32 21 18 ITEM13 30 96 57 ITEM14 30 72 57 ITEM15 30 60 57 ITEM16 28 28 11 ITEM17 44 15 12 ITEM18 25 8 7 ITEM19 37 8 7 ITEM20 25 8 7 ITEM21 47...

Thanks Mark! That worked. Saved me hours or frustration!

Hi- have been working on this for hours and cannot find the problem: I'm trying to insert a text value into a table (from another table). I need to insert the text value, then I will insert other code to email a report (not shown here), and then loop to do the same thing until the end of...

I'm not exactly sure what you mean when you ask 'what data tables' is used to store these? I haven't built this yet so I can store the data or save to a variable if needed and show on a report- that's what I meant earlier but I don't think this is what you were asking. anyway, I'll look out...

Hi- I probably want to display the results in a report. As far as the other question, I suppose that each sku should be spread out over the least amount of pallets. In this case, 2 pallets thanks for your reply

Hi- No idea how to solve this one.... I work for a distribution center and I'm trying to create code to calculate, given known dimensions of our products and qty's, the number of pallets needed to fill each order. Here are the relevant fields: skuid percentpallet: the percentage of a...

Hi- I need to switch columns and rows. here's what I currently have: loc, shift, dep, mc, disc, amex 40, 1, 100, 200, 300, 400 40, 2, 150, 250, 50, 20 40, 3, 50, 25, 60, 100 41, 1, 500, 300, 600, 400 41, 2, 175, 20, 50, 200 ect.. Here's...

thanks for your reply. I guess I'll try to include a "shift" field however, this almost seems like the reverse of a union query. I can't believe that their isn't a good way to do this with SQL thanks anyway

thanks for the reply I don't have a shift field. I was hoping I can create it in sql... something like Select (this is the part I don't know- record #1?) as [Shift1] ect..

I'm not sure how to explain (and therefore search) this so forgive me if this has already been answered. Here is my current table (I've changed the field names to make it easier): Date Deposit 4-5-11 $1000 4-5-11 $2000 4-5-11 $500 4-6-11 $200 4-6-11 $100 how can I modify the results to show...

pbaldy- Thanks!!!! That did the trick. just a small adjustment that took hours for me to work on. thanks again

Hi- I'm trying to create a running totals in a query and am stumped. I've read similar posts and cannot understand why this is not working for me. I have a table named "test" with the following info: testid (autonumber) AQty 1 30 2...