Recent content by ScottBeatty

Eh, scratch that. I'll most likely just have to use a query, correct?

Is there a code to sum the data in a table and present in a form in a text box or some other visual that will stay the same even when navigating through other records?

Yes exactly. I don't want there to be duplicates of a state until all 50 states are randomly selected. I want the there to be 2 random states for every 1 client. I want that process to be repeated 25 times so that all 50 states are selected. The comment about the 50 months was irrelevant...

I have a scenario that I tried on an Excel forum but didn't have much luck. Conditions for my assignment: 1) Long description short, I have to randomly select 2 records for each client each month. 2) The catch is that these records have to be different states until the process is done...

Okay thank you

Hello, I have a spreadsheet that my company uses that has about 20 clients presented in a single sheet in Excel so I was wondering if it was possible to display only a selected range (i.e. only one client) in a specific form in Access to cleanse this up a bit. Thanks, Scott.

I have a question about something on my database that I do not even know if it's possible or not, but I figured it's worth a shot. I pulled a report from this website my company uses and it has around 7,000 orders and a corresponding employee to each record. Since each employee has around...

I have a form with a 1,000 or so records and I'd like to be able to start where I left off when I save and open up. Is there an access property or VBA code that allows me to start on, for example, 250, instead of returning to 1 every time? I know how to go to the last record in the database...

Hi everyone, I'm not very familiar with linking data from Access to Excel but I think it's what I'm going to want to do for my operation. I have a huge spreadsheet that my boss handed me and he wanted to see if it were possible to only present a part of it in access. I already have a form to a...

thank you for all of your help!

well that certainly got rid of the grand total, but then for the success and failing rates it just yields a value of #N/A. I may just keep it with the grand total at this point haha. It doesn't necessarily affect my database. I just found it a little redundant

That button is also disabled when I right click.

yep that's what I was trying. However, I'm primarily using this for the PivotTable and it is disabled when I open it as PivotTable. I tried to click in after switching to viewing to different views but it didn't change anything. Any other suggestions on what may work?

Well I don't have a column that I created to calculate the totals. They are just provided automatically and I was wondering if there was a way to just show the percentages of passes and percentages of fails and not have them totaled to 100%

Okay thank you. How exactly would I be able to change the visible propery though?