Search results

thanks all.... sorted it now using my batch files ....but i'll look into the name statement thang as wel for the future. thanks ... once again for all your help... i feel a bit out of my depth around you clever guys... but maybe one day i'll be able to write code.... bestest ...kimbo:)

aggggggh!!! i think you're both missing the point.... i need to hitch my front end to a different dataset on the fly . in other words i need to use another datasource ie set of tables called the same as my master set with the samer relationships etc. once a year all the tables are copied into...

i am using a button to start a macro which closes an active form which uses linked table information from my database back end... opens a dialog whith another button which runs a dos batch file to change the name of an archived back end to the name of the back end i whish to run.... this all...

thanks for that... so far i've got .... =Trim([Home Address]) & IIf(Len(Trim([Home Address])) Is Null,"",Chr(13)) & Trim([Address]) & IIf(Len(Trim([Address])) Is Null,"",Chr(13)) & Trim([City]) & IIf(Len(Trim([City])) Is Null,"",Chr(13)) & Trim([State]) & IIf(Len(Trim([State])) Is...

i have a field... well actually a concatenation of trimed fields....but i need to insert a carriage return between some of them... i thought CHR(13) was the kiddie to use ...but all it does is put a square symbol in the sstring . how do i get a carriage return inserted? thanks in advance...

thanks very much.... i've now got it all working still dont quite get the hang of the syntax but hey.... if it works ....so what?!! thanks again.. best....kimbo

help with conditonal expression how do i?...... field a b c d e f g h i i need to make a conditional calculation.... on fields h and i ...h= if g-c= or <0 then h=0 if g-c>0 and <e then h=((g-c)/100)*d if g-c= or >e then h=(e/100)*d ...i= if g-c<e...

thanks for the help.... but how do i apply it? ....not very good with code do i just paste it into the data properties for the field h? and how do i write for field i?

help with conditonal expression how do i?...... field a b c d e f g h i i need to make a conditional calculation.... on fields h and i ...h= if g-c= or <0 then h=0 if g-c>0 and <e then h=((g-c)/100)*d if g-c= or >e then h=(e/100)*d ...i= if g-c<e then i=0 if g-c>e then...

thank for all thew inpt.... i'll have to get back onthe case a bit later.....some retouch work just in, is begging for my attention... and it pays more of the bills at the moment than db design.... thanks again and keep this thread going between yourselves.... i'll be back tonight!

mr cosmos ....my man..... you are a star... i think you've just helped to crystalise the idea i was arriving at. except....and i know its a relational database and i should'nt repeat data, but how about if i write the details of the client straight back to the appointments table? this repeats...

hu? ....why not check boxes? sounds so simple as far as the end user goes....it represents a given time slot....and they dont have to think about it ...just click........guess there's a programatic reason for it hey? just asking because i'm curious about just about everthing! like i said at...

thanks for the input.....i think i may have sussed it very simply!!! (for once!) i just need to create a record for a day/date and have a series if check boxes to represent the time periods ...which are fixed..... and have a calenderr control on the form to create a new date record or go to the...

how do i?...... i'm trying to build a booking document... i need to be able to see a graphic representation of the calender... ie a system wher the user clicks on a tab for day of the week and date and is presented with a table containing check boxes for each available time slot and a client id...