Search results

Is it possible to print two records on one label? I have to print 200 numbers onto labels for ID purposes and I don't want to waste 200 labels if I can use 100. For example, I need the first label to be: BACKNUMBER BACKNUMBER 1 2 and the second label to be...

Hey guys, I have a datafile being sent to me about once a week with various names in 5 different work sheets (4 sheets are individual categories and the last is all the data, which are people's names, on the one sheet)...(btw, not my choice....). Now what I need to do is have excel look at...

Anyone know of a good excel addin to do boxplots (also known as Box & Wisker plot), stem and leaf plots, dot plots? I've searched this forum and google and haven't found anything. I'd prefer freeware but I'll buy if I have to. Thanks again

I have some data that is grouped in two columns, one is "Score Value" and the other is "Frequency" (or the number with that score). Since there are 1000 total scores, is there a way to data statistical analysis (like mean, mode median, etc) on this data without expanding the data to 1000...

I have an Access Database setup that sorts archery scores. I want to export a query to a specific sheet in an Excel file that is setup for playoff bracketing which has formulas that automatically advances the winner of a match to the next round. Now my question is, am I looking at this...

Well, I found a major design flaw in my excel workbook. I made all my references relative when I need them to be absolute (ooops.....:o ). Instead of clicking on every cell and changing it, is there a way to change all the references on a sheet to absolute at once (i.e. change =A1 to =$A$1)...

First, I apologize if this has been answered before. I've tried searching for it and came up empty. Is there any way to bring up more than one record in a "Columnar" Form? i'm using this database for an archery tournament and what I need is to enter the target number into a search function...

I have a report that prints out the results of an archery tournament with several divisions. Is there anyway to number these results? i.e. 1 Archer1 2 Archer2 3 Archer3 Basically, I need an autonumber field or something similar to be in the Detail section of the report. Thanks, Steve

Here's the code... Private Sub Command53_Click() Dim strArcherRef As String Dim strSearch As String 'Check txtSearch for Null value or Nill Entry first. If IsNull(Me![txtSearch]) Or (Me![txtSearch]) = "" Then MsgBox "Please enter a value!", vbOKOnly, "Invalid Search...

First, I have to explain what this DB is being used for. It is used by an archery tournament administrator to enter archer information (i.e name, address,etc. and scores.) When a new archer is inputted, it creates a unique ID using the DMax() function. Now, what i need to be able to do is...

is there an easy way to delete all records on the main table and re-setting the autonumber back to 1? right now i have to manually delete all the records, delete the autonumber field, create new field with the same name as the old one and then set it up to autonumber (btw...the autonumber is...

Hey, it's me again. I found something else that i just can't figure out how to do. When my database opens, I want a form to pop up (i dunno if it should be unbound or not) and ask me for some information. Specifically, i want it to ask "Tournament Name?" and I will enter the tournament name...

I have a query field that currently has an expression that "adds" three text strings together to define a new one. The expression right now is "Division: [Class]+" "+[Male/Female]+" "+[Style]+" "+[In/Out Of State]". Is there any way i can put code in so that is [In/Out Of State] is blank (...

Is there anyway to limit the number of duplicates in a table? For example, I have a column that is named "Line". I want to be able to limit a specific entry in this column to only 28 times. So that the same information (let's say "Saturday 9:30") can only be entered 28 times in that column...