Microsoft Access 2003 for PC Logo

Related Topics:

Posted on Mar 23, 2009
Answered by a Fixya Expert

Trustworthy Expert Solutions

At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.

View Our Top Experts

Data in one record changes to the data in the following record

While in a form and I move the curors (without clicking) over the data in one record, the data changes to that of the following or previous record!

1 Answer

Dave Herard

Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that got 5 achievements.

Vice President:

An expert whose answer got voted for 100 times.

Governor:

An expert whose answer got voted for 20 times.

  • Expert 152 Answers
  • Posted on Mar 27, 2009
Dave Herard
Expert
Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that got 5 achievements.

Vice President:

An expert whose answer got voted for 100 times.

Governor:

An expert whose answer got voted for 20 times.

Joined: Mar 18, 2009
Answers
152
Questions
0
Helped
76821
Points
386

You have to go into the design view of the form. On the field(s) that this is happening to, right click and select properties. The select the Event tab. Go down the list and look for the "On Mouse Move" perperty. See if there is an Event Procedure in the block to the left. If there is, that is most likely what is causing this to happen. The procedure is probably written to perform this action.

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

0helpful
1answer

How do i deliet my password form pc windows 8

  1. Swipe in from the right edge of the screen, and then tap Search.
    (If you're using a mouse, point to the lower-right corner of the screen, move the mouse pointer up, and then click Search.)
  2. Enter sign, and then tap or click Change sign-in options.
  3. Choose the sign-in option you'd like to use, and then follow the instructions.
For More Information :
https://support.microsoft.com/en-us/help/14064/windows-8-sign-in-to-windows-without-password
tip

How To Run Data Verification In Peachtree Accounting

<p>Data Verification is a Peachtree utility that allows you to verify if any of your data files are missing or possibly damaged. During the verification process, Peachtree makes any needed changes so that your data records are compatible with Peachtree data formats. For example, if an ID in a data record has more than the maximum allowable characters, Peachtree will truncate the ID. Also, any files that Peachtree finds to be corrupt and unusable are deleted during the verification process. <br /> Following verification, Peachtree generates a log that details all errors encountered and reports on any changes made, as well as any corrupt records deleted. Follow these steps to run the test:<br /> <ol> <li>In your company, from the <b>Tasks</b> menu select <b>System</b>, <b>Change Accounting Period</b>.</li> <li>Highlight the first <b>Accounting Period</b> on the list and click <b>OK.</b></li> <li>From the <b>File</b> menu, select <b>Data Verification</b>.</li> <li>Select the <b>Both Tests</b> (recommended) option from the menu and click <b>Start</b>. <br /></li> <li>You will be prompted to make a <b>backup</b> of your Peachtree data. This is a required step. Click <b>Save</b>. The data verification test will begin automatically when the backup is complete.</li> <li>If no errors were found, click <b>Close</b>. If errors were found, you can examine the details of the tests by clicking the <b>View Error Log</b> button.</li> <li>To change back to the current Accounting Period follow steps 1 and 2 above.</li></ol>
on Feb 21, 2011 • Computers & Internet
0helpful
1answer

How to print database in vb

To Print a Database you would require to create a Report. There were many ways of creating reports in Visual Basic 6.0. Hereby I am giving you an example of Data Report.
Printing a Data Report
Printing a data report can be accomplished in one of two ways. The user can click the Print button that appears on the data report in Print Preview mode (using the Show method), or you can programmatically enable printing using the PrintReport method. If an error occurs during printing, trap it in the Error event.
Choosing to Display a Print Dialog Box
When printing a report programmatically, you have two choices: to print by displaying the Print dialog box, or by printing without displaying the dialog box.
To display the Print dialog box
  1. Add a CommandButton to a Form.
  2. In the button's Click event, place the following code.
DataReport1.PrintReport True The Print dialog box allows the user to select a printer, print to file, select a range of pages to print, and specify the number of copies to print.
Note Printers must be installed on the computer in order to present a choice of printers.

Printing Without a Dialog Box
In some cases, you may wish to print the report without user intervention. The PrintReport method also gives you the option of selecting a range of pages to print, either all, or a specified range.
To print without displaying the dialog box
  1. Add a CommandButton to a Form.
  2. In the button's Click event, place the following code:
DataReport1.PrintReport False
Or, to specify a range of pages to print, use the code below:
DataReport1.PrintReport False, rptRangeFromTo, 1, 2
0helpful
2answers

Access database was copied now no tables in dropdown list

Your version of Access may require slightly different menus and clicks than mine, but the procedure is straightforward and should be very similar to what you will need to do. Read the whole post first!

Make sure you have permission to modify the database, then go to the form (I assume the drop-down table is in a form) and go to design view.

In design view, click once on the dropdown box you are having a problem with, and a properties screen with several tabs should pop up; click on the data tab, and look at 'data source'. In the list look for 'row source type' to see if the source of your data is a) a table or a query, b) a value list or c) a field list. Most dropdown boxes use either a value list or data from another table or a query (based on a table).

Check the source of data by going down to the next line in the list titled 'Row Source' (this is the list on the data tab that popped up when you clicked on the dropdown box in design view).

If the source is a table/query type you should see some code in the Row Source box like "SELECT....". Without changing anything, click once immediately to the right of the box, and whatever source the rows are coming from should pop up--if a query, for instance, it will pop up the underlying query in design view.

You should be able to troubleshoot the underlying query to see why no data is given in the dropdown box.

Another point where underlying query or table is used: If the table was based on a query that pulls data from the records in the current database, the drop down list will be blank until new records are added so the query has something to list.

And if the source is a 'value list', the values should be included in the row source box below, separated by semicolons. If not you simply need to add them in.

If your source is a field list, go back to whomever copied the database and tell them you need help with the copy they gave you...
11helpful
6answers

Tally 5.4 error

try to configure your configuration setting. change the data source where you data saved.

Exp (from program files, configuration setting) :

;; Tally eis 5.4 workstation specific parameters file

[Tally]

; Specify location of Data files

Data = D:\data tally\Tally 2\DATA

;; Specify list of companies to preload
; ** TO STOP DEFAULT LOADING set the following line to NO

Default Companies = Yes

Load = 0001
;Load = 0002

; Specify list of TDL files for user defined reports and changes
; ** TO STOP LOADING TDL FILES, set the following line to NO

User TDL = Yes

;TDL = <TDL file 1>


; Specify location of TALLY.SAV (saved configuration of Tally)

Config = c:\TALLY

; Specify Color details of local monitor

Color = Yes



a bold letter is the source of data that you must change.
1helpful
1answer

How to activate command buttons

Not w/o you sharing how you did it step by step. Can you add some screenshots of the steps you tok to get there? In general "add record" should jump to another form that allows you to enter your data for the new record and "save" it.
Not finding what you are looking for?

56 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

k24674

Level 3 Expert

8093 Answers

Brad Brown

Level 3 Expert

19187 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...