Recent content by ChrisCione

Sorry, but I had to laugh at your "WHY?" question. Because I'm an idiot, that's why. Really, it's because I am learning on the fly (and barely, at that). It's neither here nor there to me how this is accomplished. I did try modifying the query, from this...

The first suggestion returned all records (didn't filter); the second suggestion, it couldn't parse. Could this be accomplished via another method? I want to print a "filtered" report using this criteria: 1) a checkbox on one form [frmRecruitment] - only those records with the checkbox...

Names. It's only 1 column.

I have an OpenReport macro which currently uses a query as a filter, which works 100%. I attempted to add a where condition to further "filter" results. The statement reads: [Specialist]=[Forms]![frmSwitchboard]![lstSpecialist] Specialist is a text field in my main table; lstSpecialist is a...

Thanks for the help.

As the topic title states, I want checkboxes to print on a report ONLY IF the checkbox value is "true" - if the checkbox is checked. If it is not checked, I don't want it to print at all. The report contains data from multiple records, some with the checkbox=1 and others with the checkbox=0.

The report is already built on a query, so I tried your second suggestion, which worked like a charm. Thanks for your help.

I have an unbound text box (called "Due Date") on my form which calculates a due date of a project based on two factors, both of which are fields in the db: the type (selected from a combo box) and the Date I was assigned the project. The field names are "Type" and "DateReceived". The...

Could Select Case work with this? I want to put code behind a command button that will open and populate a specific Excel worksheet based on the combo box selection. I have this for Word. How would it be written for Excel? Private Sub CommandOtherDocsGo_Click() 'Download to OtherDocs Word...

Thanks to everyone who assisted in this thread. I was looking for the same type of code. It works perfectly (to state the obvious)!!

How sweet it is. :)

I know how to set the field type in a table - have no idea how to set a textbox as text.

I've tried setting the formatting for the textbox. I've used Like "00000" Like "?????" and every permutation of the above that I can think of. Still not displaying leading zeros. I'm not sure if this information is needed, but the control source for the textbox is =ClassCombo.column(1)...

Not sure I'm using the right terminology, but I hope this makes sense: I have a text box that is bound to a combo box, such that the selection in the combo box (text) auto-populates the textbox (numbers). The textbox is used to display 5 digit numbers, some (but not all) with leading zeros. I...

Thanks. So simple, but I would have never gotten it.