Search results

Set the app path as a trusted location in Package Solution Wizard when making your installer. Additional Registry Keys Root = CU Key = Software\Microsoft\Office\12.0\Access\Security\Trusted Locations\MyApp Name = Path Value = c:MyApp Root = CU Key =...

I have written a very simple form that allow a user to register their database. Very simple (and probably easy to crack). You hake the changes where neccessary. How it works: On opening the database tow String Vaules are written to the registry. Version and DateInstalled DateInstalled lets the...

I am in the initial stages of planning a new app. It will be used to record animals and events pertaining to each animal. The app will store data as events relating to an animal. Some events would have mulitiple occurances. i.e. medical treatments. My idea is to have an initial table with...

I have a startup form that calls 3 function Private Sub Form_Open(Cancel As Integer) Farm1File Farm2File FarmsFile End Sub These check that the 3 BE files exist. The Module is as below, but has 3 identical functions. Only the blue text is different: Function Farm1File() Dim Msg...

I have the following code in my "switchboard" On Open procedure. For reports I have a custom ribbon (via USysRibbons). It is the standard print ribbon. Reports open in print preview. DoCmd.ShowToolbar "Ribbon", acToolbarNo I need to turn this ribbon on when the report is open. The following...

The DB has 2 BE's. One for each farm. Reason: replication is done using sneakerware. One farm doesn't edit the other's data. The FE has duplicates of each form, just the references are different so as to use the correct BE. i.e. F_1_DateCheck and F_2_DateCheck. I would like some help on the VB...

I am building a custom ribbon and need some XML code help. I need this button to open a form. <button idMso="??????" size="large" label="MyButton"

Extracts from the Access help file: Access 2007 Developer Extensions and Runtime

Need help finishing this code please. Access 2k7. Existing record - Deletes (working) New record, dirty - Undo (working) New record, no data - Undo (working) No records - goes to "Existing record" Private Sub Button_Delete_Click() Dim Msg, Style, Title, Response, MyString Dim Cancel As...

I am using Form Level Validation and all works well except: When adding a new record the user is prompted if they would like to add a new record or not. Cancel works fine. If OK then a new record is created and the user can enter details. The problem comes in if they then decide not to add...

Found this interesting and would like some info. Is this bad practice? How would this affect my DB? Any useful comments please. I have a table that has lookups. T_Animal IDAnimal AnimalNumber (Indexed No Dup's) AnimalGroup (Lookup) AnimalSex (Lookup) AnimalBreed (Lookup) AnimalOrigin...

I have a button on my "switchboard" that allows you to make a backup that I thought you would be interested in. EDIT: This code backs up the BE files of a split DB app, not the FE, where the BE files are stored in a seperate directory from the FE. To backup a single file app or the FE use...

Access 2007, single machine. I have a form that is split into 2 parts. An unbound list box (to select an animal). A sub form that contains field related to an animal and (in the footer) a Tab Control (2 pages). Page 1 is for entering medical treatments. Page 2 is for enetring lactations...