Search results

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

thank you so much billmeye! It worked perfectly

Oh no worries. Well, I made progress. The button with the corresponding code is now clickable without any error messages. However, it does not find a page. I thought it initially had something to do with my ID being set to visible= no but I just changed it to yes and it did not make a...

Okay, I came up with another error. It says Run-time error "3078": The Microsoft Access database engine cannot find the input table or query 'tmpImportedData'. Make sure it exists and that its name is spelled correctly. I was confused about this so I clicked on Debug and Access highlighted...

Okay I was wondering if you could help me out with some troubleshooting. I typed in everything nearly word for word because I am still a novice in VBA and I got a Run-time error '3131': Syntax error in FROM clause. My table name is "Imported Data" the field name is just "ID" and the button...

I actually haven't been using a query to do this. I was just wondering if there was a way to find a random record in a form that has data from my table. I have an ID as my primary key so every record has a unique ID. I am just wondering if there is a way to make a generic random function for...

Yes sorry I should have been specific. The problem I have is that I am using this database as a template so I can import data from Excel. Having said that, my ranges are not always the same (meaning my upper bound and my lower bound). Is there a generic code for finding a random record that is...

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

I really wish I could, but it contains confidential information.

Client is a text. I got another, but different, error message reading "The expression you entered has an invalid string. A string can be up to 2048 characters long, including opening and closing quotation marks." Code: PassPerCol2= FormatPercent(DCount("*","Headings From Client","[Final...

Sorry but I'm not crazy code savvy :banghead:, and I got an error message reading "The expression you entered contains invalid syntax. You may have entered an operand without an operator." My exact code is as follows: PassPerCol2= FormatPercent(DCount("*","Headings From Client","[Final...

I actually want to add up all of the passes in a column. This way I can use a filter to single out a single customer and see the percentage by customer. I've been trying to use the criteria in design view to count the passes and that works and everything but I cannot figure out a way to get...

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?

well I suppose. However I much prefer to click run query for a number of times with the random integer code. I just do not know how to set it up if my upperbound is variable based on the data I import from different Excel files.

I have a question to add on to this. What if I import tables daily that do not necessarily have a consisten upper bound and lower bound? Is there a way to have enter a standardized code that when I import the table from excel, it will automatically generate random numbers?

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?