Search results

up his dark

Hi Dugantrain, That seems like a reasonable idea. It is a shame that this doesn't work as it is far more generic i.e. re-useable, than writing a query. Oh well, thanks for the help it's greatly appreciated. :) TS

Hi all, I'm trying to put some error handling events in my DB mainly to deal with key violations when appending records to tables. I've put this in a module which is called when i need to run a query. Option Compare Database Option Explicit Public Function RunQry(QryName As String)' Pass in...

Hi Shadez, I finally understand, I was just P****** around with it at it suddenly made sense, then i read your post and bingo there it was as well :D :D The first Strchild is a unique identifer and is deemed to be a variant data type so if you use a number even though you've passed in a...

Hi, Thanks for the suggestion that is basically what i am doing with the []. My real problem is i can't seem to add a childnode with the same name as another node (parent or child) even if it is in a different branch i.e Where G and H are childnodes of A and F is a child of G and another F is...

Hi all, I'm still having problems with the treeview control. I've found out from the microsoft knowledge base that you can't use numeric data for the nodes as the control treats them as variants and therefore tries to use them as indicies. This means you have to append something to them to make...

Hi Travis, That is an interesting solution but i think it will be confusing for the people using the data. The values relate to medical observations and therefore need to be precise. I managed to solve the problem though i'm not sure why it works (something i usually can't abide :mad: )...

Hi all, I am populating a tree view control from data in a table. However i get the error message 'Run time error 356003 invalid key' when i try to add a childnode that is numeric. With my treeview.nodes .add StrParent, twvChild, StrChild,StrChild end with If i replace StrChild with...

I wasn't questioning your knowledge of the Russian Alphabet or anything else for that matter. I was simply asking what the result of a transposition translation would be. Even when you do transpose the Greek Alphabet the words are obviously not going to be English. Are you able to translate them...

Hello again, Their is only two reason i would ever consider making tables. 1. If i was doing a complex query and couldn't find anyother way. As soon as i a had finished i would use the Drop sql statment and get rid of them. 2. when i wanted to archive hospital waiting list data that would be...

Hello, Why are you doing this? TS

Hi, We'll keep this simple. KKilfoil has a point you could keep both next of kin and patient in the same table and then link the 2 records through a link table where one reocord is the next of kin to a patient record. Personnaly my approach would be to have a seperate next of kin table. The...

Hi all, Mike your knowledge of your environment may be indepth/unique etc however a competent systems analyst would be able to transfer your knowledge into a structure that a database developer would understand. Most developers who post on this board do their own systems analysis and...

Hi, Yes it certainly is possible. You just type the name of the query instead of the SQL string. set db = currentdb set rst = db.openrecordset("NameofQuery") If you are using parameters in the query then use the method i posted earlier. Public Function getval() As Date Dim Db As...

Hi, Fear not recordsets are pretty simple - or maybe i just use them pretty simply-. I only use DAO and i think you kmow enough about that so I will progress. Dim DB as DAO.Database Dim Rst as DAO.Recordset Set Db = CurrentDB ' create an instance of the current database set Rst =...

No offence, i could of guessed that :D Try the rest of it without using an online translator. I'd be interested to know what you get. TS

Hi Mike, All arguments aside it is obvious that some parts of you database need "redesigning". I am not necessarily talking about the functionality i.e what the screens do but how the data is held. This will probably endup effecting how the data is presented and accessed anyway. I take your...

Hi, Tell you what Mike you right me a plain English description of what it is your trying to do. I will design you a full normalized, spanking ass database. We'll work some way out of transfering your data into it - god's that will be a nightmare :D . I will get my solicitor to draw up a...

Take an example of a course enrolment table. We need to know who has enrolled on which course what dept they are from and the start date of the course. We have two tables. Tbl_Staff. StaffID Staff-FName Staff-SName Dept 100 John Smith Accounts...

These work if that's any help. Forms("frmNew_Contribution").Employee.Column(2) or Forms!frmNew_Contribution.Employee.Column(2) TS