Search results

Look at Application.SetOption : http://msdn2.microsoft.com/en-gb/library/aa140014(office.10).aspx For example in my application I get the user's original options when the application starts, and sets them while they use my application. Then set them back to the user's Original Settings (Have...

Not too certain what is in your *.txt file. But would be better to append each line to a List box. Just off the top of my head . . . '++++++++++++++++++++++++++++++++++++++++++++ 'Best place this in a module, then you can reuse in other projects, other stick it in your form code Public...

Why not introduce a new field of type Yes/No in one of your tables referenced in the subform. Then display it in the subform with the Title "Delete" or "Remove". When the user clicks the command button "Delete" then execute a query or SQL to delete those records that are true. Include...

Hi, I have this bit of code that tranfers a file into my Access 97 Db: DoCmd.TransferText A_IMPORTFIXED, "ARCCAND.DAT", "CandidateIn", gstrImportDir & "\ARCCAND.DAT" The last time I ran this was under NT. It doesn't work under XP now though. Any clues? Many thanks

Hello, I am using Access 2002. I have an MDE front end that links to a db on the server. The back end db memory size is around 10MB at the start of the day. At the end of the day it gets to about 60 MB. I compact it in the morning and it goes back down to around 10MB. Would anyone have any...

Found it! It's on the Import menu button options -->.

Found it! It's a part of the options menu on the import dialogue box.

Hi, Does anybody know how to import a custom Menu Bar from another db please? Thanks

Hi, Does anybody know how to import a Custom Menu Bar from another db? Thanks

Do you know what the the syntax is?

Hi, Does anybody know how to call a module in a subform from a totaly different form please? Many thanks

Does anybody know how to call a module in a subform from a totaly different form please? Many thanks.

Thx Good point Batman! I'll stick the button on the subform. On click - move to new rec. Open Z form and make modal. Excellent! It's just too easy! :P Thx KenHigg

doesn't work Thx for the reply. Unfortunately although setting focus to the other subform, it creates a new record in the other form "Form Z". I will try recordsetclones now.

Try this??? Why don't you have another field that you use as an id key. This id key could be: 1 (For Text) 2 (For Numeric Values) 3 (For Boolean) Then on your form create 3 different controls to handle each one. i.e. Tex Box, list box, combo box . . . . Dependent therefore on your question...

Reply Hi there, This module wil delete any entries by the user that you determine. Please rename all the 'txtbox' to the name of your textbox on your form. the KeyCode 192 is the ASCII value for " ' " . For anymore just add them after the no. 192. I have added the letter A (65, for...

Ciao! (Access 97 Prob) Backgorund: I have a main form "Form A" with a subform "Form A1". The subform allows users to add Candidates for a certain test. I have allowed a button on "Form A" that will show a new form "Form Z" that lits all Candidates already in the db. The idea is that when a user...