Recent content by jammy_owen

oh ok. i just thought this could be done in a table. thanks for all your help

yeah, thanks for your help (!)

hi all, this really simple problem is buggin' me so i'll let you lot have a go! basically, in the datasheet view, how do you separate the title field name into two lines? ie the field looks like this: title field 1 title field 2 title field 3 title field 4 but i want it like this: title...

hi all, i've come across a minor problem here involving access. basically, i've got different tables that have some of the fields the same i.e title, date, price etc. but it would really help if i could merge the information so i could see it present in one table, and i'm only guessing that...

yey! thanks mile-o-phile! i told you it was a simple question!

hello. all i want to do is add up two sets of numbers from two fields. i.e add up the information from field 'a', which i can put as 1, and add up with the info from field 'b', for instance 2. the answer i want in this case is 3. But, for some reason, when i add up these fields with the '+'...

Don't worry, there's no more problems!! I've just put it in and it works for all of the buttons. thanks again!

ive replaced the old code with the new code that you gave me and the first macro works when i press it once, but if i press it again nothing happens.

hello again, it still works but i would like to do the same but with FIVE macros working one after the other(same as above). i tried making the code myself with: Private Sub Label2_Click() Static intFlag As Integer If intFlag = 0 Then DoCmd.RunMacro "MCR_MSG" If intFlag =...

i used the top one and it works perfectly! thanks a bunch mile-o-phile!!

could you translate the wording as i don't understand what to change it to? the macro that i want to perform first is called "MCR_MSG4" and when i click again it is called "MCR_MSG5". also, if its any use the form that im using it on is called "FRM_Membership Information"

im just wandering if i could click on a button or text box and it will perform one macro, then if i click it again it will perform a different macro? any help would be very useful.

Hi guys, this is my first post!! anyway, i would like to know if there is a way in which i can make a macro that closes one form, opens another, then 1 second later, closes that form then opens another one. The result of this would be my splashscreen opening, then 1 sec later, it closes that...