Search results

It is possible to use 1 report for 3 prints with different titles. 1. Create a text box on your form (hidden if you want) 2. Create a Print button and paste the following procedure : Private Sub btn_Print_Click() Me.ReportTitle = "1" DoCmd.OpenReport "ReportName", acViewNormal...

See This Thread (Hope the above address is correct, first time posting Url's You will need to change the commondialog properties to save with "*.xls" instead of "*.txt" And then change the command in the procedure "Private Sub btn_Save_Click()" from displaying the msgbox to...

eg. Create a form with 1. A label called "lbl_EmailAddress" 2. A Combo box called "fld_EmailList" which has two column of data, column 1 contains "UserName", column 2 contains "Email Address" - this can be a list or based on a query/table 3. Create the Event Procedure Private Sub...

I think I understand what you are trying to do. Create temporary date field and base the criteria on that field not the original date TempDate :Mid([OriginalDate],4) This willremove the "dd/" from "dd/mm/yyyy". Therefore leaving just the "mm/yyyy" which you can specify a month/year criteria...

Set the Field Definition to : Data Type : Date/Time Format : mm/yyyy Default Value : =Date() Smed

Rachael, To perform table changes use an SQL Query : Create Index (Duplicates OK) CREATE INDEX index_name ON table_name (column_name) Create Unique Index (No Duplicates) CREATE UNIQUE INDEX index_name ON table_name (column_name) Hope this helps Smed

Liam, I have tried to recreate your problem but your code works fine. (Provided i correctly understood your problem ) Attached is the database I created Smed

use vba to hide/show the textbox Create an "On Activate" event procedure in your report and specify a condition for displaying the text box. eg. If IsNull ([forms]![SomeForm]![SomeField]) THEN Me.TextBox.Visible = False Else Me.TextBox.Visible = True Endif...

If the two text boxes on your forms are bound to a field in a table, have a look at the field definition a check they are not set to integar. Also open the form in Design Mode. Display the properties for each field and set the "Format" property to "FIXED" and specify how many "Decimal Places"...

Mike, Have you tried using the ActiveX : Common Dialogs Control ? I use it to obtaining a file name selected/specified in both a open & save file requester. I have attached a simple db for you to have a look at. Hope it's helps Smed