Search results

Max, Found these links may be of some use?? http://support.microsoft.com/default.aspx?kbid=823227&product=acc2003 http://forums.about.com/ab-databases/messages/?msg=1971.1 TS

Hi Max, In the help menu in the main database window is an option called Detect and Repair. You need to have the CD handy. You don't need a DB open just Access. It should tell you if their are any problems with the installation. TS

Hi Doc, What i am trying to do is allow an update of selected records chosen by the user. The scenario is a line manager leaves the department and the staff need to be reassigned to a new manager or indeed managers. I have a popup continuous form that displays all the member of staff under the...

Hi all, Is it possible to create a query that has a variable that i can access from a form? i.e. i can bind a checkbox to the variable. Or would i need to create a temp table first? Thanks TS

Hi, Thanks for clearing up the client side serverside issues, however - and not intending to be rude here - this seems to have gotten of the beaten path. My question was, which db engine would satisfy my requirements namely that it can be run on a windows iis server and that i can interact with...

Ok semantics apart. In order to open a table you must need to specify the path of the DB yesno? Does CF provide it's own connectivity or do you use an ODBC connection? Can you use traditonal controls such as lisboxes txt boxes or is there another method of selecting input? How do you write to...

As far as i understood it. If you use vbscript in an asp page the data has to be processed on the server. So if you fill out the form and submit it, the data goes the the server, the script is processed and comes back to the browser. In doing so you can get it to create html by imbeding the tags...

The data captured on the site is only intended to be used by certain people. As i should have direct access to the DB on the server from the Hospitals internal network i can use a desktop fe to the db to create user accounts that will restrict access to the pages. This way there is no way that a...

Hi, Basically; The pages can only be viewed from with the NHS net NWW. not WWW. This means Internet like i.e. viewed from many sites but with certain restrictions on access. + much quicker then standard internet. The data will need to be secure. I can do a 256bit encrypted password login to...

Hi all, I tried to find out as much as i can about this issue but i keep finding conflicting views. I am just about to buy a new server for work. I will be running a number of databases (4-5) on a website. The server will be using IIS windows server 2003. The databases will be accessed...

Lets forget about the how for a minute and look at the why. Yes you enter addresses in the address table. You say How many is a few. 1000, 100000, 10000000? It doesn't really matter. To be fair this is a lookup table a 1 to 1 relationship - 1 client has 1 home address - what it does is give...

Totally agree with you and Pat on this. You might as well say let's go and build a bridge out of marshmallows as build a database without normalization. I'm not saying it's always easy, but to reject the practice because you don't like it is nonsensical to the point of infantile. And quite...

If you look at my break down of your data you will see three address tables Business, Home and Postal. In your Client table you will have three fields to retain the PK of each one of the address tables. You can enter the address once in the address table and link it to as many clients as you...

Funny i know my example isn't perfect in every detail but when i started it would have taken me all week to figure that out. I quite enjoyed it. So sad where's that gun?? :eek: ;) :D TS

Mike, the importance is not actually important. The data isn't lost/ of less value because it is in another table. The positioning of fields in a table is down to the relationship between the object the table represents and the attributes of that object. For example a private car hire firm with...

And in response to Pat's data warehouse(DWh) post. This is exactly what they do in the Hospitals i have worked at in order to allow information departments access to the Patient Administration System (PAS) data. More often than not we would have a SQLSERVER DWh that pulls all of the PAS tables...

Short answer: No Long answer not sure if we are talking insurance claim or a new insurance poilicy. This should give you some ideas :D Unlike some people i don't mind lookup tables when you have as many catergories as i've seen in the NHS datasets and they keep changing their minds as to what...

Hi Cable, Yep that can be a problem. I think i've got some sort of illness, i spend ages pissing around with aligning boxes and stuff trying to get it perfect :D I wish i could just settle on one way of doing things for all my db's. :rolleyes: TS

Hi all, I am at the stage of developing the reports for my latest DB and i am yet again having doubts about the way i have choosen to align and justify the labels and data [See attached]. Does anyone else have a preference/examples. Cheers TS :confused:

a dynamite stick