Search results

The reason I used the extension is so that it doesn't backup any temp files. You can change this. But why not leave the database in 2010 format? Use Access runtimes (see one of my other threads). That way the user doesn't need Access (any version) just the Runtime (free!!!). Now you get all the...

All tables would relate back to a GUID which will be stored in the "main" table. That table will only have fields that will never change. i.e. GUID, DOB and Breed. All other info is subject to change or may have multiple entries. i.e. An animal may have more than one RFID in its lifetime, or a...

Re: Planing an events based app You get Active and Passive RFID chips. Passive chips are activated by the reader. Active chips broadcast at timed intervals. You also get Read Only and Read/Write.

Re: Planing an events based app There will be a lot of tables. I just gave an example. So there will be a table for the plastic ear tag. This is the number that we refer to for the name of the cow. These are changed everytime an animal calves. The colour changes but the number stays the same...

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...

Remember the following: Create all the table you think you may need. The db that contains the tables is now your BE (BackEnd) For Forms, Queries, Reports and code start a new db that will be the FE (FrontEnd) and link the tables that are in your BE. You may want to have multiple FE's at some...

Can I ask why the totals are in a sub form? Is it just because you have the form as a datasheet? You know that you can make a continuous form look just like a datasheet. I have one situation where my totals are in a sub form in the footer and the main form is a sub form in the detail. Each...

Have a yes/no field in your table called Archived. Default = No. If yes the record is archived. In your queries you can show only record where Archived=No. The data is still available, but not used by default. Queries, reports and forms can then use Archived to either dislay all, current or...

Password protect the BE (BackEnd). That way nobody can open them without the password. In the FE (FrontEnd) the tables are linked. Linked tables cannot have their structure altered. When tables are linked, a password is required becasue the BE is password protected. This is only needed when you...

Why have the subform hidden? Rather have it showing and you won't need the extra text box. The totals will update automatically when the requery is run. Private Sub Field1_AfterUpdate() Me.Requery DoCmd.GoToControl "Field2" End Sub The last field should be Private Sub...

I have two almost identical queries to work out milk produced for a milking session. We have 2 milking sessions a day. One in the morning and one in ther afternoon. A tanker collects the milk at midday. The way we calculate milk produced for a day in by adding PM session from yesterday to AM...

Make sure that the folder the app is in is a trusted folder in Trust Centre. http://www.access-programmers.co.uk/forums/showthread.php?p=1029652#post1029652

I speak multiple languages. French is not one of them. But a simple translation to English was not that hard using the internet. If a person asks a question in, say, French. Let it be translated into English correctly before all the flaming starts. But the OPs must be made aware that the...

Seems a bit illogical. Having to in and out of a form to change the person. But anyway here you are.

Here we go. You need to create a combo box. Then have a sub form to dislay the data. Have a good look at the Query, as well as the Event Procedures.

Just an option that may help you. Are you, by any chance, on a domain server? If so, Sharepoint has great ways of doing surveys.

Look at my signature for more info on Runtime and Deployment. I agree that the BE should be moved to SQL. Do some users only have access to some parts of the app? i.e finance never use forms that engineering use? If so you could look at splitting the front end into "sub apps". The app then...

This link may help:

The code works fine. I have tested it a number of times using various variations. I moved the "Sub CheckFile(FarmFile As String)" to a module so I don't have to duplicate the code in each of the two slash forms. Because the code runs in the Form_Open procedure all the file checking is done...

The app opens with one of two splash screeens (_Splash1 or _Splash2). The splash screen that opens at next startup is dictated by a field (ComboFarm) on the "switchboard" (F_0_Main) and is set when the app closes. Private Sub Button_Quit_Click() Select Case Forms!F_0_Main!ComboFarm...