Search results

I've figured out how to do what I want, but now how do I make it so a particular field is not required for it to show up on the query?

On the form from which I'm making a report, the user puts in a series of single characters in their individual boxes, which correspond to a different table. The string of characters makes up the part number. The table that stores test results is called TestResults. The form TestResults asks...

Thanks. This is the code that actually wound up working: Edit: NVM, I can't format code windows like you, but the .3 and .4 needed to be moved out a level of parenthesis.

The problem that I'm running into is that I cannot get another result besides .3 Here is my updated code: Spec: IIf((([pCon1]="E" Or "G" Or "I" Or "L" Or "N" Or "O" Or "T") And ([pCon2]="E" Or "G" Or "I" Or "L" Or "N" Or "O" Or "T")) Or [pMode]="8" Or "9",0.3,0.4)

Spec: IIF(((pCon1 = "E" or "G" or "I" or "L" or "N" or "O" or "T") AND (pCon2 = "E" or "G" or "I" or "L" or "N" or "T")) OR pMode = "8" OR "9"), .3, .4) if pCon1 and pCon2 are any of those special letters, or if pMode is 8 or 9, I need a .3. Otherwise, I need a .4.

I want my data to go onto a report that will print on a 4-inch wide label from the Zebra 450 label printer. Anyone have any experience with creating reports on not-so-standard formats or label printing from access? In the end, I need the user to be able to click a button on the form, which...

Ok forget every variable I used in my OP, it's all about to change. Con1 = One end of the fiber. Based on values from idConnectors. The two categories here are UPC or APC. A value of D is UPC, Value E is APC, Value F is UPC, Value G is APC, and so on. Con2 = Other end of the fiber. Based on...

I believe what he wants, because I am in the process of making something similar, is a button to generate a report based on the criteria of the currently selected record.

Kansas? Just watch out for tornados.

Seems about right for me.

To answer poll in a word: No.

I am going to be printing a label from a report generated from a form. Box A (which draws its options from TableA) has ~20 options. Lets say 10 of these options give me the answer immediately; AnsA The other 10 options of Box A then depend on the answer of Box B (which draws its options from...

Hooray it works. Now to expand the code to copy all 12 fields :D

Now upon clicking the button, it says Compile error: object required It highlights the Private Sub line in yellow, and also highlights the vfpn, after Set.

I'm trying to add a button that will copy a bunch of the fields and have it ready for the next record, as they will be doing a lot of the same tests in a row. Here is the code I have. Private Sub CopyButton_Click() Dim vfpn As String Dim vcon1 As String Dim vcon2 As String Dim vmode As String...

Well, I guess the "normal" thing to do would be to create a table to assign each cable a serial number, then another table to put in test results for each fiber in that cable as its own record. In the end, I need to be able to print the test results on a label the size of a shipping label.

I think what I've decided to do is, assume each cable has 12 threads (they don't all). If you have less than 12 threads, great, fill out which cells you need. If you go over 12, which is usually in increments of 12, you create a new record with its own serial number for the next batch of 12...

I'm about to write a database for a fiberoptic cable company where I work. The cables are to be tested and the results will be input into a database. The trouble is, the fibers vary. The popular numbers are 1, 2, 4, 12, 24. But a better list of the common numbers is (1, 2, 4, 6, 8, 12, 24, 48...