Search results

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?

Sorry for being redundant; I saw a post earlier about this but I had a hard time finding it. To keep it short and sweet, my query set up is: Employee, Team Name, and then I have the same field in the column as I do in the data and it presents pass/fail data. I have the data shown as a...

Ahhh nevermind. Careless error. Thanks again!

Oops the first button worked but now that I added, about 25 more, none of them work and they are all referencing different queries. I'm getting the error message "The expression On Click you entered as the event property setting produce the following error: Ambiguous name detected [on a...

Okay perfect thank you

sorry what is the "DoCmd" method? I'd like to use a button in a form to automatically go to the Pivot Table if that helps at all