Search results

In the Event Property On Open place this code DoCmd.Maximize This will open your form full screen. and in the Event Property On Close place this code DoCmd.Restore this will reverse the first code hope this helps

You need only two CommandButtons to print/view your reports. One for PrintView The Other for Print The attechment may Help

In the Report Footer place a CopyAndPaste of you Sum Textbox, this will Sum the whole column.

Is it the main Form or a subForm that you want the Count

In the Report Footer under the controls that you want to Sum, Place a Control, as its' Recordsourse put =Sum([DownTimeMins]) Hope this helps

Try Changing the Height to .1667" I would also Decrease the space between the textBoxes Hope this helps

You do not want to do this, instead use Queries to calculate your totals. In the Northwind Database goto queries you'll see one call Invoice Totals. Duplicated this in your database, changing Field Names where you need to. Create another Table and Name it CustomerRemits (or Something like...

I can suggest the Microsoft Access Northwind, it should be on your Access disc. If not it can be downloaded from Microsoft.com. This database will give some good pointers and a starting point. From there you have more tables, queries, forms, and reports. That you will have to add to the...

I would use multiple subForms set as Continuous Forms Use a Combobox or ListBox to Filter your records. Example: Main Form: ComboBox or ListBox to Filter your Records subForm1: Account Names (or a ListBox) subForm2: Account Address subForm3: Account Contacts & PhoneNumbers Hope this helps

No, the user (those who read only) will use the View only Form. to view the Records that you use your first Form to Enter/Change data in your tables. Example of Setup: Data Entry/Change Form Named frmCustomersEntry under laying table tblCustomers Data View Only Form Named frmCustomersViewOnly...

Try this DateSerial(Year(Date), Month(Date) + 60, 1) If todays date is 7-1-05 dates shown will be 9-1-05 Hope this helps

How do you mean updated. Do want to change the content of the Control Label if some conditions met Such as (example) If "txtInvoiceType" = "CO" then "lblInvoiceType" = "SalesInvoice" and If "txtInvoiceType" = "CR" then "lblInvoiceType" = "ReturnInvoice"

tblAcq = tblAcquired and tblAcqDetail = tblAcquiredDetail = Itms Received

Would it be better to use some code to lock down the database, with a back door to unlock. Some clients are a little slow, when it comes' to give up money for what really do need. By locking it down you retain any changes that they or you have made. And most important thier data is intact, for...

If do not want the other people to edit the database, you sould Create another Form that is for viewing only. For all of the data controls set the Enable property to No and the Lock property to Yes, this will prevent any changes. And maybe a few ComboBoxes to filter through the Records. The...

You want to create what is known as Cascading ComboBoxes Try this as a search,

Have you changed the name of the RecordSource of any of the ComboBoxes If not,it just a matter of rebuilding the ComboBoxes, sometimes Access acts stupid.

Try this and make sure that First ComboBox has been Named in the name property "Job". First ComboBox SELECT [Stations].[Station_Name] "add here" [Stations].[Department] FROM Stations WHERE ((([Stations].[Department])=[Forms]![Employee Training Main]![Department])) GROUP BY...

Try this Like IIf(IsNull([Forms]![FrmSearch.[Cmbo1]),"*",[Forms]![FrmSearch.[Cmbo1])

A simple solution is to click on it with your pointer. To have it happen automatic will require some code