Recent content by simpleton

This table only has 2 records in it. I need them to populate on an order-receipt in a rotating-like fashion. Currently I have them randomly pulled. I need them to load up on my report in order. IE: Run the report first time = Promo1 displays. Run it a second time = Promo2 displays. Etc.

Table "PromoBlurb" Table: "PromoBlurb" PromoID PInfo ------- -------------------------------------------- 1 Super Summer Sale. 5% off our list price. 2 Did you know we sell other stuff too?

I have a table with 2 text-blurbs in it. I need the data to populate in a rotating-like fashion. You, see I set it up to pull randomly.. but now they don't like random. So, how can I set this up to pull sequentially? So, every query will pull 1, then 2, then 1, then 2... etc. Here's what i'm...

But what i really want is a date parameter on my datasheet data.

I realize that i'm probably doing this all wrong. So i'm fine to start over on this form. I just don't know what direction to head. Here's the error i was getting on my bad-version.... First off, it doesn't want to load... it prompts me for the [Forms]![Admin]![Date] information... and then...

I have a form that shows a datasheet subform, but i need to have a little "date" box up top where I can have the data limited by the date. Nothing is working. Where should the parameter live? I tried putting it in the datasheet's query and referencing the date box.. like...

Awesome. Problem solved. They were "hidden" linked tables to the backend. Learn something new everyday. Thanks so much!!!

I've come into ownership of an Access Database system, and I can't seem to figure something out. The guy who set it up (who was fired, and unavailable), has two files in this system. One in the main folder which is .mde locked. And the other (which i assume is the back-end) in a subfolder...

Thanks. I did go ahead and just make a data-report. I do still need to do a chart though. When I use the chart wizard, I can only pick 6 columns. And the data always seems to come out funky.

I created a nice little Query that totals up all my data. Problem is, I can't seem to get the Chart-Builder to make this for me correctly. Here's what my Query returns: CategoryID R1 R2 R3 R4 R5 R6 AVG 1 91 91 82 82 82 82 86 2 75...

Ok. That worked quite well. Thanks sooo much!! I tweaked it a little bit so it only asks for PW. And doesn't give the reply. Thanks a lot!

Awesome. That looks perfect. I'll try it Monday. Thank you, thank you.

Is there a way I can setup general user's to only see the Main form (without using a login/pw) and set a password for Admin's so they can get access to everything? Here's what I have: I created a little access db so that users can get data onscreen. I have their form setup to auto-start and...

Can't seem to get that to work either...

Thanks. I read some on DLookup, but I didn't really find much related to my problem. I tried to trick my hyperlink, but it didn't work. hxxp://asp_server/ordernotes/print_new_ordernote.asp?OrderID=[Forms]![OrderNotes_New]![ORDER_NUMBER] So Frustrating...