Search results

That's actually a really nice form OldSoftBoss, but I can't seem to find a way of manipulating the group keeptogether property on it. Basically, I just want to be able to toggle between having the report show all of the [Product] groups on the same page or having them split onto seperate...

Hi Everyone, I have a report that needs to open with the Product.GroupKeepTogether property in the sorting and grouping section either true or false. This would depend on a toggle switch on the form that opens it. I can't seem to find out how to do this in code. I figured I could just do a...

Perfect! all I had to do is put brackets around the [UPC#] and it worked like a charm. Thank you so much for your help :)

Multiselecting Woes- Please help Hi Everyone! I designed a form a long time ago that has been working great ever since. Bascially I can double-click an item in a list and it will bring up a form based on the supplier of that item. Right now it will show everything associated with that...

Worked like a charm. Thank for the help Shadez!

Hello! All I need is a simple control on a form that counts down the number of days between the current date and 3/6/2004. It seems so easy and yet I cant figure out how to do it. Thanks for your help!!

Thanks! That's exactly what I'm looking for :) You're the best! -Ben

Is there anyway of having my form link the current UPC# to the UPC# of the picture in my picture folder? So if record 55568 is being shown, the form will find the picture named 55568? Otherwise, how would I put these pictures into a table to link to my main application? Thanks for the help!! -Ben

Hey Everyone! I came here hoping to find some inspiration for my latest project. I'm supposed to scan a sample of every label we have in stock (Over 700 labels!) and include them in our Access inventory system. The idea is to be able to click a button and see a picture of any label. Anyway, I...

The Val function! Of course, that worked perfectly. Thanks a million :)

Hi Everyone! I'm having a serious headache with this query I'm working on. It seems pretty easy, but it's just not working. I'm just trying to add three fields together in a query. I have an expression in my query that looks like this: Expr1: [Field1] + [Field2] + [Field3] All three fields...

Thank you so much for your swift response! That worked perfectly. Three cheers for Jon K!

Hi everyone! I'm having some trouble with a fairly simple query I'm working on for some production records. I have a field in my Prod table named [DateID]. Basically, any new day that production records are entered, they will get the same DateID. (This is just to keep them in order since we...

Hi everyone! The completion of our new office building is almost at hand! (Which means I finally get my own office!!). And with the new building comes an entirely new network that I get to design. I'm planning on replacing our peer to peer network with a client/server. This means, of course...

Hey i figured it out! It wasn't exactly what you said WebFaktor, but you sparked the idea in my head that fixed it... so Thanks! I love this forum :)

That does make sense, but I need to know how to do that in a query. I have thousands of production records, grouped in the query by month with the sum of cases produced for each month. But now I need a single average for each product. I hope this is making some sense. Thanks for your help!! -Ben

Hi Everyone! I'm having some trouble with a query I'm working on. I have a query that shows the Sum([#cases]) produced grouped by Format(Date, "M"). This shows me the total number of cases produced for every month. I need to know how to get the monthly average of the cases produced, but I...

Have a good lawyer on standby, get an alibi, sell your DB over the black market, cover your tracks, and frame someone else. That's all you need to do ;)

Thanks for your reply Basically I want the records to be copied temporarily to a blank table so I can add feilds and change the data as needed (Via a form that is based on it) . Then I'd use an append query to paste the new, updated records into a main table. After that, Id have a delete query...

Hi everyone, I'm having some syntax problems with a form I'm working on. I have a form with a combobox and all I have to do is send the records that I double-click to a pre-made table. (Like coping and pasting). Seems easy enough? Well it probably is, but I've never done it before and once...