Recent content by jive6243

Hi guys. I'm at a loss...someone PUHLEESE throw me a frickin' bone, here. OK so. I'm in Access 2002. I thought it would be easy to create ONE report containing nothing but ONE graph based on ONE query with 4 columns: Product Category [PC], Time, sum(LY Inventory), sum(TY Inventory)...

Thanks a lot! I'll definately investigate some ways i can incorporate this into my database. Thanks so much for your help!

Yes please!!!

Thank you, Keith. However, i need to have this in vba as i cannot use changing parameters in a pass-through, from what i'm told. so i have an access table that holds the updated information, and via the vba, the string is appended to the existing pass-through query. I think i may have...

Hiya- I'm using the self-teach method for VBA, folks, and so far it hasn't been very effective, so bare with me... i am performing a pass-thru query in VBA using code that i updated from another db. it works fine, however, i would like to have the results appear so i can do a quick, one-time...

I will try that route - seems easier than writing the crazy functions. Thanks!

mresann - thanks for your post. let me give you a bit of background. i currently do this in Excel. There's a tab for each day, which contains the items sold that day. All of the tabs roll up to a total tab. But it is has become too time consuming because items vary day to day, and i would...

Thanks for your help - it's much appreciated. :)

Hello all! Quick question. WindowsXP, Access 2002. I have a table that shows sales and inventory levels for an item for each day of the week. Let's say the week starts out at 100 units. On Sunday, 7 units were sold, so the ending inv level for Sunday would be 93. Monday was 5, leaving...

OK. I'm so bad. I originally checked the "same as detail" checkbox and thought I unchecked it, but I went in again, and it was checked. So I unchecked it and changed the size of the columns and I'm good to go. Thanks for your reply!

It's been a while and I'm a little rusty, but I have created a report in access that I have formatted to go in columns. I was hoping I could have the header stretch across the page and just have the detail portion of the report be columnar. Is this possible? (Access 2002 by the way)

Eureka!!!!!! omg you totally rock!!!!!!!!!! I figured I was just being a bonehead, and I was right. lol Thank you SO MUCH!!!

Hey guys... Does anyone know of a bug in Access 2002 with some of the form properties not working? I have an agitatingly simple Access 2002 form. No VBA, no macros, just 2 measly columns that come up in datasheet view (although the same problem happens in form view, as well) when opened...

Doc Man - thank you so much for your help. I will definately try this! Thanks again!

Thank you for your reply Doc Man. I apologize for not being more clear about the code. I am doing a transfertext command which is appending the tables to the master. So for the SQL command, are you saying that the filename field should be appended to the rows while they are still in the text...