Pookaroo85
Last Activity: Oct 15 '19, 03:35 PM
Joined: Nov 26 '13
Location:
-
This is a great tool and looks great in print preview. But, it jumps back to label 1 when I actually print the labels. Any ideas? -
I figured it out. Although it is not highly looked upon, I had to use... Like "*" & [Field] & "*"Leave a comment:
-
Query Criteria
I have a form with a StartDate, EndDate and 8 combo boxes to filter a query. The user is required to enter dates but needs to be given the option to use none/some/all of the combo boxes. The date criteria works with a between statement but I cannot for the life of me get the combo boxes to filter the query without wiping EVERYTHING out. I have unbound combo boxes that reference the query for appropriate options and the query uses the combo boxes... -
Thanks all! This is great!!
One note... You have to have the report page set up as Column Layout = Across, then Down. Otherwise, it doesn't work.Leave a comment:
-
Labels - How to Print to Column 2?
I have a report for labels that feeds from a query. There are 10 labels that will be printed at a time. I am using label sheets that have 30 labels and consumes the leftmost column each time. I need to figure out how to select the column so that I don't waste the middle column. How do I start printing at label 1 or 11 on command? Thanks in advance!! -
Pookaroo85 replied to How can I add values to a datasheet subform with a command button on the parent form?in Visual BasicFIGURED IT OUT! :)
Create a query that gives you the information you want to transfer.
Change the select query to an append query.
Create a button on your form and write the following On Click event:
Private Sub ButtonName_Clic k()
DoCmd.Save
CurrentDb.Execu te "QueryName" , dbFailOnError
Form.Refresh
MsgBox ("You did it!")
End SubLeave a comment:
-
Pookaroo85 started a topic How can I add values to a datasheet subform with a command button on the parent form?in Visual BasicHow can I add values to a datasheet subform with a command button on the parent form?
I have a button on a parent form. OnClick, I would like the subform datasheet to fill in a set of 11 records into one column (ValveID) with specific values. Consider it a sample set that is specific to each record of the parent form.
Example:
Record 1... ValveID = "Valve A"
Record 2... ValveID = "Valve B"
Record 3... ValveID = "Valve C" -
Would this work where I have to print the same report multiple times with different criteria based on the selections of the form?Leave a comment:
-
Use IF-THEN to change query parameters for a report
I have a form with a series of check boxes and combo boxes to change report criteria. Based on the user's selection, I need 1 - 17 reports to print with different criteria from the same 5 queries. Each query has been made into a sub-report. I cannot seem to figure out how to get the scenarios to influence the query parameters. For sake of space, I have only included 2 queries worth below.
[Private Sub cmdPrint_Click( )
Dim dbs... -
Filter Query Checkbox Based on Form Textbox
I have a form frmCRApproval which has a textbox txtMatrix that I would like to use as criteria in my query qryCRApproval. I would like to change the criteria to checked if txtMatrix is ValueA but leave the criteria as Null if it is not ValueA.
I currently haveIIf([Forms]![frmCRApproval]![txtMatrix]="ValueA",-1,Null)in the criteria.Last edited by zmbd; Nov 5 '15, 06:21 AM. Reason: [z{please use the code format for posted script, thnx}] -
Form opens with a custom formatted value then passes it to another form
Problem #1) I need a text field CRNo on form frmChangeImpact to autonumber/format to YY-### and reset at the beginning of each year. Is this possible?Last edited by zmbd; Oct 25 '15, 05:10 AM. Reason: [z{deleted second question. One Question per thread please. :) see FAQ.}] -
Using the information from a checkbox survey to run a query.
I am trying to create a form where there is a unique request number, some general information and a list of 25 standard questions. Next to the questions would be a check box indicating yes/no. I would like to run a query based on whether the checkbox is checked and another table indicating a list of associated forms that will subsequently need to be completed. Does anyone have any suggestions as to how I should go about doing this? Thanks! -
Excel 2010 - Disable Min / Max
I have an Excel 2010 workbook which opens to full screen. The problem is that if you minimize the application, it shows the ribbon and formula bar. How would I go about either:- Disabling the application min / max buttons (I don't this this is wise).
- Reinstating the fullscreen feature if the application is minimized.
-
I figured it out. I changed...
to...Code:LOW = Application.WorksheetFunction.VLookup(Range("C7"), Sheet.TANKS.Range("A:D"), 3, False) 8. HIGH = Application.WorksheetFunction.VLookup(Range("C7"), Sheet.TANKS.Range("A:D"), 4, False)
...Code:LOW = Application.WorksheetFunction.VLookup(Sheets("FORM").Range("C7"), Sheets("TANKS").Range("A:D"),Leave a comment:
-
Object Error
I am working in Excel 2010 and am trying to print a report from another tab only if a specific cell is within a specific range. When I click the 'Print' button I get "Run-time error '424': Object required" when it gets to my LOW and HIGH strings. I do not know how to fix this. Any clues would be appreciated.
...Code:Sub PRINT_SLURRY_Click() 'Prints batch ticket from different tab Dim LOW As -
This is what I've done... I now have 4 quearies for my 4 different scenarios. I need to change the record source of the report based on what fields are null in my form. Theoretically, I think this should work, but it doesn't and I'm not skilled enough to know why. Any help would be appreciated.
...Code:Private Sub cmdReport_Click() On Error GoTo Err_cmdReport_Click Dim stDocName As String Dim stWhereConditionLeave a comment:
-
Filter Query through Form
SET-UP: I currently have a form with unbound text fields to type in the criteria. Then, I have a query with the criteria referencing those text fields. On the form, I have a 'Report' command button to print preview the report.
GOAL: I have a form that filters a query to then print a report. There are two sections in the form: one for Start Date and End Date, the other for a material number. I would like the option to do the following... -
Figured it out. Thank you!Leave a comment:
-
The combobox value is blank. It saves into the table, but then doesn't reappear when toggling records in the form. I removed "Me.Supplie r = vbNullString".Leave a comment:
No activity results to display
Leave a comment: