Search results

I have a report with products like this sum of product1 100kgr sum of product2 200kgr sum of product3 10kgr sum of product4 50kgr And i want to sort them by sum like this sum of product2 200kgr sum of product1 100kgr sum of product4 50kgr sum of product3 10kgr how can i do that...

I have a form with email addresses and the code Private Sub Contact_DblClick(Cancel As Integer) DoCmd.SendObject , "", "", Me.Contact, "", "" End Sub When I double click a new email opens in outlook express and the email address is filled correctly in To: When I have default email client the...

thank you very much I have made this example The user has 20 seconds to fill in the form with a new record After this 20 seconds he cannot work with access until he fills the form Of course someone professional its simple to bypass it

thank you very much

how can i hide a button in a form or make inactive after a certain time

because its possible to have a very urgent gob and i want to give them 1 hour to work in other forms

no i want to obligate the users to fill in a form in 1 hour and if they dont to not have permission to use the access database after that hour until they fill in that form

How can I make the users of an Access database to have every morning 1 hour to fill in a form and if they don’t to not have permission to continue using the db ?

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q260/8/19.ASP&NoWebContent=1 I have this problem when i have both outllook express and Access 2000 or XP I have isstalled sp 1 2 3 for office but the problem exists Any ideas???

I have the following code in a field of a form with orders and Access crashes when I enter a new order The tables are : HOUSES and ORDERS Ex: A house has 1000 orders and the number of order (1000) is stored in a field of house table [NO_ORDER] When I add a new order and I enter the name of the...

i found this in access newsgroups if you are developing a database in MS Access it will grow like crazy. This happens because Access arranges space for new objects, but doesn't give the space free again when you remove an object, so this way the database will grow. Compacting will make your...

i have a lot of code its true Can you tell me all the procedure for importing all the database to a new empty? Thank you very much

no the tables are linked for both

i worked in this database and the size remains small

I have an Access database with linked tables with a size of 28MB (after compact and repair) When I create a new empty database and I import all the forms reports queries macros from the first the size is 14MB (after compact and repair) Is it normal ?

any ideas?

thank you but how can i do that? the first form has code (1) date from (1/1/03) date to (3/1/03) ..... the subform has code2 code date and i want to have the records 1 1 1/1/03 2 1 2/1/03 3 1 3/1/03

I have a form with start date (1/1/03) and end date (3/1/03) I have a sub form and I want to automate the addition in this sub form 3 records with dates 1/1/03 2/1/03 3/1/03 How can I do that?

i found in msdn that Note In Microsoft Access 97, the DoMenuItem method has been replaced by the RunCommand method. The DoMenuItem method is included in this version of Microsoft Access only for compatibility with previous versions. When you run existing Visual Basic code containing a...

i replace the DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 with DoCmd.RunCommand acCmdSaveRecord and its ok now it is correct like this?