Search results

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

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

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

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

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

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

Jeez, I am so out of my league. I've studied up on Access with Lyndia.com video training. I've read the Access 2003 bible. I think i've gotten down all the basics. I am pretty good with SQL stuff, but this project is driving me crazy. I have like 4 different tables all related to Customer...