Search results

aha! thanks Rich.. I have removed that line from the code and we have tested it and it seems to be a lot better... just could not bear to have to go back to simple buttons... I like my bells and whistles! ta John

lets try this... hopefully this will work....

here is a 97 vers...

bah and bah again! my forms have buttons which highlight when the user runs their mouse over the button.. this all works nicely except tht it can take the userup to 8 clicks of the mouse to register... any ideas why? It may be just the the dbase is running slowly.. but the button highlights...

barking up the wrong tree! many thanks Pat.. I'll have a go at the conditional formatting.. thought I would have a stab at the recordset.. (never used one before, so all a worthwhile learning curve) obviously not useful in this case though! back to the drawing board! thanks again john

hmmmmmm Ok;; I think this clearly shows I am awful at recordsets.. but have had a stab at it and promptly failed...:mad: can anyone spread any light on it.. i am trying to achieve the same as above... but in continuous forms layout... thanks John Private Sub Form_Load() Dim rs As...

ta! cheers IMO.. much appreciated.. can see where I was going wrong! I really need it in continuous forms... so will try with a recordset.. I assume that is what I need... will give it a stab and then post back in needbe.. many many thanks John.

bah!! again!! hello to you both, cheers for the ideas... I tried both of these but still something is wrong... have zipped up my database.. basically I have a form which depending on the value in txtbox "countdown" the labels on the form appear or not.. the three types are.... less than...

Private Sub Form_Open(Cancel As Integer) If Me.countdown = Null Then Me.countdown.Visible = False Me.countdowntxt.Visible = False Me.enddate_label.Visible = False End If I have this simple code which is if a record has no data in the countdown textbox then the following are not visible.. but...

cheers! Hi.. thanks for that link.. I knew of the site (bit of a SPSS goldmine!).. I have actually emailed Reynald who deals with that site for advice on this... but thought it might be worth sticking it on here too... I thought that maybe as it is the access module calling the data I could...

Hi.. I have this module which takes metadata out of SPSS and places it in an access table.. it brings over the variable names, labels, the value codes, and the labels for the codes.. the data is brought over in a seperate process.. the problem is that if the variable is a string then it only...

hi, firstly try a search on this forum.. there have been many many posts of this subject... using keywords such as "email" or "outlook" you can easily have some code which will pick out a new users details, put your email address in the To box.. you need to use the docmd.sendobjects command...

ok.... I think you have to be more specific with your question... you are highly unlikely to have someone build the dbase for you.. but if you have specific queries you need help on.. people are more than happy to help you.. my two cents... for form1 you can have a form which just jumps to...

what about using adobe acrobat writer.. there are plenty of shareware versions to try out first... and it is very easy to use..

ta! thanks for the info... have got it to work now... think the user had loaded up a different dbase when I asked him to test it..! thanks again. John

I was having problems with a query. I designed a report based on a query coming off a listbox and used querydef.. this was all fine.. except that the debugger was coming up with "user variable not defined.." for the query def statement dim q as querydef. so I searched on this forum and found i...

thanks! cheers for the info Travis. I have found a company specialising in text messaging software which allows bulk messages sent to mobile phones... this then can be populated with the data from my database.. am waiting on a call back from the company.. expecting the hard sell technique...

ok... am building a database for the department of education and they have enquired about whether we can incorporate a facility that will text message users onto their mobile phones! if this is possible I assume that you would need some external software.. and link through to access.. am still...

place a parameter in the query design think this might be what you are after.. (nb. it might have been Rich who told me about this in the first place!) on the design view of the query you are creating. in the two boxes that you have the user type in the criteria put the following such as...

try Open With.. I think if you right click on a database in explorer and goto open with, you can choose the default app to use and then there is a checkbox which says "always open with" i am pretty certain that this ensures that that version of access will open the files.. I have both...