Question about Microsoft Access 2003 for PC

1 Answer

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!

Posted by on

Ad

1 Answer

  • 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

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.

Posted on Mar 27, 2009

Ad

1 Suggested Answer

6ya6ya

6ya staff

  • 2 Answers

SOURCE:

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

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

Oct 14, 2016 | Computers & Internet

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

1 Answer

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

Mar 11, 2014 | Microsoft Visual Basic 6.0 for PC

2 Answers

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...

Sep 13, 2009 | Microsoft OFFICE 2003 BASIC OEM ENGLISH MS...

1 Answer

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.

Aug 14, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Access 2003 for PC Logo

Related Topics:

47 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

Alun Cox

Level 3 Expert

2679 Answers

Peter Dragonetti

Level 3 Expert

798 Answers

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

Answer questions

Manuals & User Guides

Loading...