Search results

As I iunderstand the app you wouldn't copy the FE to other machines but have a collective folder on the network to store the update. All of the other front ends should have this path set to look for their "current" version on open. This information is stored in the "tbl-version_master_location"...

Set the attributes of the BE (Back End) to read only in the standard windows file environment. e.g. Righ Click>Properties>Check read only. This will allow them to view the data but not alter it :) Good luck John

Any chance you can attach a copy of the database hard to tell without seeing what you have done?

Re: The instruction at -- referenced memory at --. The memory could not be read." I don't think this is an access problem more likely a hardware fault, 0x00000014 is a memory address, the other number I think is a CPU instruction reference number. I would run a memtest and swap out your ram as...

EDIT: Sorry missed the list box bit... thought it was a subform you need to use a statement in the criteria of your subform to filter the information in the listbox. Perhaps something like this pick sales from the drop down has "fake data" in it, something I did for someone with a similar...

No its the button you have on your form which uses the MergeSingleWord, this command calls the GuiWordTemplate form you can use MergeNoPrompts and specify your own criteria if you already have the template set up and don't require any user interaction. However as I said I have not used this...

You would have to use a delete query. Create the query based on the table and fields you want to delete then change type to delete query "BE CAREFUL" don't double click to open or you could delete all records when used you need to specify which record to delete in much the same way as your query...

Sounds like me apart from the random bouts of lucidity... :D

Right click on the folder in question select properties then security tab you will see the listed permissions alternatively log on as an administrator when making your database changes this should circumvent the UAC. Good luck John

I swap databases between Vista and Xp all the time and have never had the problem you describe are you sure its not the user account control settings preventing the changes on Vista and not something to do with access.... John

Although I have not used the function you can also use a query to export the fields that you want: http://www.members.shaw.ca/AlbertKallal/wordmerge/page2.html Found at the above link: "If you need NO prompts, and want to specify the from/to document name, then use MergeNoPrompts...

Ok attached as 2000 format and actually put some data and correct tables in this time so it works :o Hope its helps John :)

What version of access are you using?

Heres the link for Jet/Access reserved words: http://support.microsoft.com/kb/321266 good luck John

Use an append query to "copy" the fields you want from the source table to your secondary table run the query from your command button with something like: DoCmd.OpenQuery "qryAppend" good luck John

The "time" function in access derives its value from windows system settings so you would need to set up using a timer or something similar have a look here: http://www.access-programmers.co.uk/forums/showthread.php?t=128560 good luck John

Is there any calculation done with the resulting scales? If not you could create the tables for Patient, symptoms, etc then have a main form (Patient) with another form (assesment) to enter details which could be populated with the patients details when opened from the main form. You could also...

Have you copied the front end to your local drive on the pc you are using and used the linked table manager to tell it where to find the back end? What operating system is on the "server" windows server XXXX or just a standard windows operating system (simple file sharing)?

Not as yet the only thing I can think of is creating a code that loops through the records in your query and outputs a PDF for each however this will (depending on the amount of data in is row) probably cause heavy memory usage. I will have a try over the next few days but there are others here...

Is it a mapped network drive on your PC or just a shortcut through network connections? If its a shared application the database should really be split and a copy of the FE (Front End) that is generated should be copied to all remote PC's this will help prevent corruption and sharing/locking...