Search results

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?

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

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

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

Hi everyone. I was wondering if it is possible to change the primary view for queries from the table view to say, the Pivot Chart view? Thanks

Hi everyone, I was wondering if it is possible to add a pivot table to a form? As of right now, I just have a bunch of buttons that you can click to go to the different queries but I would prefer if it were possible to add the actual table to the form

Hey everyone, I have a query that has clients sorted in the row area and a column from my table that is set up as text but only has yes/no options for the data. I have a pivot table that counts the yes's and counts the no's and finds a grand total; however, I want to be able to find the...

Hello everyone. I was wondering if anyone could help me create a button on my form that would find a random record. I would imagine I will be doing this through VB but any help would be great. Thanks

Hello all, I have about 20 columns in a query and each row is a customer. The columns are either pass/fail but are text fields and not a yes/no set up. I want to get the percentage of a pass in the column. Can somebody help me? Thanks! -Scott

I have a query that generates a random number. From that query I have a form. If I press refresh on that form it generates a new random number. I am fine with that however, I want it to save the original random number also. Any suggestions?

Hi all. I have a scenario that I've been working on but need some help. I have a query that contains about 2000 records and each record has one of the 50 states attached to it. What I'd like to do is randomly select 2 records and export that record into a report. In addition, I was wondering if...

I have a report already made but is it possible to import only one record from a query?

Hey everyone, I ran into something that I haven't been able to figure out. I have a text box in a form (unbound) and when I go to add text into it, the text carries over from one record to another but I want it to be exclusively for that record. Any help would be greatly appreciated! Thanks!

Hey everyone, I am wondering if someone could help me. I have a master form for lack of a better phrase and 3 other forms that represent specific items in the original drop down box. In the master drop down box, I have all 50 states, and the 3 forms are for 3 specific states. Here's the code I...