Search results

When you try to compact an open database; Access closes the active database creates a new database (say db1.mdb) copies all the objects (except temporary and obsolete objects) from the closed database into db1.mdb deletes the original database. renames db1.mdb to original name. opens it...

Execute a Me.Refresh statement immediately after the statement setting the SourceObject Property value.

Post few Screen-shots so that your specific issue will have more clarity. When the field get focus on Form the Cursor behavior (1. select entire field, 2. go to start of the field 3. go to end of field) is controlled by the Behavior Entering Field setting under Advanced options in Access...

From the attached update query image it looks like you are trying to update the joined fields with the same data present in both table & query. If you are trying to update a field other than the joined fields then it make sense. But it is not shown, if it exists. You are using Left Join to...

I think the following link will help you in designing and setting up your daily backup procedure: Database Daily Backup

New record is automatically saved when you advance to the next/previous record. You may save the record by pressing Ctrl+S keys before closing the Form.

If both queries involves only a single table then it should work.

Table relationships is a complex subject. There are several type of relationship like one-to-one, on-to-many and others. A. One-to-one relationship Example: Employee Record has different segment of information: Segment-1: Employee Code, Name, Date of Birth, Place of Birth, Nationality...

Copy pasting details from Order-Details file is the easiest method you found to reduce the work involved. Are you trying to build an inventory database? You have a perfect example database (Northwind.accdb) to study the subject from in your machine. In real situations you may not be able to...

Run Me.Refresh action in the After_Update() Event Procedure of [Text41]. This will send a signal to the linked query to receive the changed content of [Text41] text box.

Here is some sample VBA Code for you to try it out on your Form: Private Sub cmdGenRec_DblClick(Cancel As Integer) Dim SN As Long, EN As Long, msg As String Dim C As Long, db As Database, rst As Recordset On Error GoTo cmdGenRec_DblClick_Err Set db = CurrentDb Set rst =...

Get the sample VBA Code from here: DOS Commands in VBA

I have made some changes to your database with the addition of a Query & a Form. Added a new text box and a DLookup() function to bring the total of all tests pertaining to a particular order. Database is attached.

Date Fields are actually of Data Type Double. Date & Time values are stored internally as Double precision number. Formatting will not change the stored value. mm.yyyy format string can be used to display the value in that format, date cannot be stored correctly in that format...

Make a copy of the tables involved (or better make a copy of the database itself) into a separate database. Use Update Query to round the value fields involved separately with the rounding formula, like INT([totalvalue] * 100)/100. Before going for updating the values open the table directly...

If you want some example to work on then check this out: Saving Data on Forms, not in Table

Design a Form with a Text Box and a Calendar Control yourself, instead of the built-in Inputbox Form. InputBox() function uses a Form and accepts only a text parameter as prompt. Check this link for ideas: Custom-made Form Wizard

Create a Table in the following structure as base: TEST PND 1,1 1,2 1,3 1,4 1,7 2,4 2,7 Calculate the Post Natal Day from the Patient Table and filter the data to determine the tests.

If you are using Access2007, open your database. Click Office Button and select Access Options. Select Advanced Option and look for Advanced Option Group. Here you will find two options Shared & Exclusive. Select Exlusive Radio Button and click OK to save the change. Close the database and...

The following statement is also valid. set rst = db.OpenRecordset(strSql) You don't need to create Query1.