Search results

How stupid of me! Thought the 4.25 was coming out as 4. Very sorry - super thank you for looking into this and figuring it out!

Here is a sample. The data in the table is 4.25 but shows as 4 in the report. Thank you!

I will try - it is a large database. TY

Created a new text box, re-keyed the expression - left Format blank and decimal place at Auto. It returns 4. Should return: 4.25. Am I missing something from your suggestion? FYI: using MS Access 2010

Thank you for answering!! The ENT_MailboxRate correspond to the hourly rate charged to repair or paint or... the mailbox. In the table, the field = Size: Double Format: General Number Decimal Places: 2 And it works fine in a report if I don't need to insert it into an expression...

Hi all, I have a text box with the following expression: =IIf([ENT_Mailbox]>=0,[ENT_MailboxRate],"") The data is entered as 4.25, 5.0, 6.5 and so on in the ENT_MailboxRate. However, I can't figure out what to put in Format or Decimal Places to the number comes out the way it was...

Works great! See attached sample. Open the form, select a report, select one or more records, click on Preview Report! Thank you everyone! PS: one thing really bugs me: The select record(s) check box is in front of a command button, so when you select a record(s), all the checkboxes "flicker"...

Yes, it is for all RECORDS. But the "all" or "true" does not work. It renders "compile error Type mismatch". The code is: Private Sub cmdSelectAllRecords_Click() Set colCheckBox = True Me.Check11.Requery End Sub You suggest to remove the first instance of strWhere? The whole line...

Works Great! Would like to add a Select All button. The button that deselects all has the following coding: Private Sub cmdClearRecordSelection_Click() Set colCheckBox = Nothing Me.Check11.Requery End Sub Created a new button for Select All and tried: Private Sub...

Thank you Cronk.

GINA, the wizard! An answer! THANK YOU!! Will try this right away! PS: very open to "the way" you would to it - just fire away!

Ok but my initial questions does - please see the database sample. Would be great if you could assist me. THANK YOU

Thank you Jdraw. That really helps to create the report list. How do I link this to my event, to select records for that selected report?

Thank you Cronk! Ok - I can create a table; I can make a combo box. Ok for the bound column. Where do I modify the event procedure enclosed in the sample? Can you provide the event, updated, please? I will test it out.

Thank you - nice to know. Unsure how I would integrate that into the existing coding - don't know how to write: "...then in the code where you assign the name of the document to print". Wish you could open the mdb. As for the combo box, yes, I would type the name of reports into it.

Hi everyone, I have had this sample database for a while. It is an ".mdb". It allows the user to select the records to be included in a report. I would like it modified so the user could also select the report he would like to print. Right now, somewhere in the event, a report is selected. I...

Yes, thank you. Last night, I was researching this on the Web. I did look for "exportedUI". Problem is that before I had my drive removed from my old PC, I did not export them - therefore that file does not exist. When I do export/import, you are right it defaults to My Documents where I...

When you try to import the customization file, it does ask where it is located. Please remove comment - will no help anyone. Thank you for trying.

THANK YOU! The link you provided talks about MS Word, not Access... I still have the old hard drive - where would it be on there? Do you know?

Hi everyone, I purchased a new computer. I had the same OS installed (Win 7 Pro) and the same MS Office installed (ver 2010) as I had before. When I open any of my databases, I find that the "Customize the Ribbon - New Group" I had created and have been adding to for a long time - is GONE...