Search results

Hi AN60, Case 1.) If this database is for one user to use only and without share to other user. Case 2.) If this database need to share to other user. exp. In one company have several computer which install different access version. If in the case 1 the answer is worthlessness. If in the...

Your means is use sql command in access to created autonumber data type ? Or use mysql database ?

Although, I am not sure understand your means correctly. You can try to use subform technic for data enry of different materials.

One idea i want to say. You can separate your database to two file. 1.) Only have table for save data only. (use Access 97 version.) 2.) Including all of information except the table, then the table use "link table" linkup old verion(Access 97) file. This file you can make several version...

hello All. I am a newbie in acess even i have several years visual basic programming language experience. Now, I have a question which is how to modify the condition of query's table use vba ? for example. In the query's table which is set condition of the "balance" column >=1 How to change...

I have a question about report's format. I want to make sure that the report format is widthway and margin size = 5 when the user preview the report. How to accomplish ? Thank you a lot.

Write the belows VBA Code in combo box of afterupdate() method, change the recordsource in the form then data also will change too. Private Sub cboLot_Number_AfterUpdate() Dim strSQL As String strSQL = "SELECT * FROM [In Stock] WHERE [Lot Number] like '*" & cboLot_Number.Value & "*'"...

Agree with upstairs, I suggest you create a query to select what data is you want to show on report before you make the report. It would advantage to the report, if you want to change the data in report, then you only need to change the query.