Search results

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...

I have created a new Access project for creating Customer Order Notes. From Access, I need to be able to open an external report (like .asp or Reporting Services) and use a parameter from the Access Form that I have open. How could I pass a parameter like this to a link? Example: I use Access...

I have a form that pulls it's default data from it's subform. I'd like to be able to click a button in the main form that will move the subform data to the next record. After that, (i already got this part) when you go to the next record in the main form, the main form will pull the data from...

Cool. And then run an Append Query from that form to send the data into the SQL table?

Hmm.. Sorry. Let me start over. We have an application that runs manufacturing processes. From the order entry screen, I have created a macro (of sorts) that will extract data into Access (like CustID, Quantity, ShippingInfo). I need a way to open that Extract in Access, and use it (along with...

Interesting. I actually have 2 tables that are getting data extracted from our app. I need to make a way to copy this data to 1 row in our SQL table.. and then edit that one row with a whole bunch of other data. How can I append to the SQL, and then open that same row for editing?