Search results for query: *

Using the built-in "Database splitter" is very simple and quick.(TOOLS, DATABASE UTILITIES, DATABASE SPLITTER). Then you can update all you want without effecting the data.

a legacy of poor table design..... but you can do this: [newfield]=[cost]/100 (format [newfield] as currency) and use in place of cost

In the Design view of the table, did you set the format to "currency"? You can also set the format of the field in a query. just go to the query design view and bring up the Properties of the field. (right click on the field)

Can you link to the database? When you copy the table are you able to go into design view? can you create a query, report or form? The answers to these questions would make it easier to help you

If that doesn't work try downloading "Jetcomp" from the Microsoft site.

Sorry it took so long to respond. If you haven't figured it out already....... use this code in the "After Update" of the first combo box good luck

Yes, go back to the pre split version, back it up and split the copy. They should automatically be linkes as Database_Fe and Database_Be. Make your changes to the frontend and if you need a copy of the frontend or backend just copy them Don't make a Replica! It really is very easy, your only...

Rick is right. If you move the frontend and backend to a new location you have to use the "Link Table Manager" to refresh the link. ( also it's always a good idea to backup! )

The forms and reports stay with the frontend. You can do anything you want the the frontend ( add queries, forms, reports etc.) without any change the the backend as long as you use the existing tables and fields. If you do need to make field or table changes then you have to go into the...

Go to "Tools" , "Database Utilities" , "Database Splitter"

1) Go to the properties of the field that you want to disable and in the "data" tab set "enabled" to no. 2) Go to the properties of the first combo box and in the "event" tab click to the right and select "code builder" and ad this...

Just curious, why would you have income and expences in the same table?

This is usually true but in some cases it may be necessary to store the calculation such as in a case where the values used in the calculation are updated. Try something like this: (click event on close form) Dim rs As Recordset Set db = CurrentDb Set rs =...

If I get you right..... In the "After Update" event of your combo box add this code Me.yourfield = Me.Source Reference.Column(#) ( # = the column with the data you want to populate with)

Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design ISBN: 0201694719 Absolutely the best!

You need to set your Recordset type as Dynaset , if not Access default type is Table type with wont work with a query

Make sure that all your references are available on the system not working. ( In the CODE window, TOOLS , REFERENCES)

Its always a good idea to split the database if there is going to be multiple users. I have used a different version of the frontend for different types of users so as to supply them access to only what they need. ( maybe just certain reports) As far as making an .MDE, this will keep users...

Try setting the "text alignment" In the field property to "left"

Combine the two fields Name: [FirstName] & " " & [LastName] This will adjust the space with each name