Search results

Here you go..... http://www.ecademy.com/module.php?mod=list&lid=47413

Hello: Enclosed is a link to a patient care data model. It can be modified to suit your needs. http://www.databaseanswers.org/data%5Fmodels/patient_care/index.htm Regards Mark

Hello: Here is a link to another forum with the same question: Regards Mark http://www.dbforums.com/archive/index.php/t-327946.html

Hello Put the below code under a command button and run. ' Private Sub cmdTest_Click() Dim MyCheck As Boolean Dim obj As AccessObject, dbs As Object Set dbs = Application.CurrentProject ' Search for open AccessObject objects in AllForms collection. For Each obj In...

Use the option group for this!!

Date() - Weekday(Date()) + 1 Will give you the first day of the current week Regards Mark

Here you go......................... http://support.microsoft.com/kb/826765/en-us

Hello Enclosed is a "Random Number" database that you can use in your databases. Regards Mark

Hello: If all your tables have the same fields, you can run an "Append Query" and attach all your tables to one table. Regards Mark

Hello: The key to that is to have a "Where" expression in your SQL statement such as: ' strSQL = strSQL & "WHERE (((YourTableName." & YourFieldName & ")='" & YourCombo.Value & "'));" ' Make sure your form is open when you run the query. Regards Mark

Hello: If you have a combo box set up to "Find a record" the Auto Expand function of the combo box does that. Regards Mark

Hello: Enclosed is an example of a Timer form and a custom pause function that can be used in your applications. Regards Mark

If you do what RuralGuy says above, you will come up with this: ' SELECT Table1.T1Field1, Table2.T2Field1, [T1Field1] & "/" & [T2Field1] AS Expr1 FROM Table1 INNER JOIN Table2 ON Table1.Table1ID = Table2.Table2ID; Regards Mark

Your welcome and good luck with this!

Convert your "Null" values to zero before adding them Use the Nz function to do this. Its usage is in the help file. Mark

Hello: You can embed the Excel application in a form. Regards Mark

Set the Format property of your box to General Number.....

Hello: I believe you want to use the PreviousControl method to obtain that value: Below is the syntax Screen.PreviousControl.OldValue Search online help for complete example Regards Mark

This might be what your after........ http://support.microsoft.com/kb/208824/en-us Regards Mark

Hello It is used in the Parameters collection for a query table. Search help under Paramenters collection for examples. Regards Mark