JDDDDD
Last Activity: Nov 9 '10, 11:57 AM
Joined: Sep 16 '10
Location:
-
ok sweet guy you rulez. using that coding i can do what i wantz perfecto now. cheerz
okz one last final problemo thatz i need solving. i figured out how to have its update when i open a form by attaching it to the on open thing for de form but when i switch between records it dont change.
I select Myth on record one and its all well and good but when i switch to record 2 it still set up for myth. and when i change the...Leave a comment:
-
sorry dude but i dont getz it. that coding makes no sense to me. and besides i dont want a combo box to disable another combo box. i want it to disable a large number of fields and a few check boxes
plz help dudeLeave a comment:
-
Using a combo box to change dates
edit - right scrap all that crap and letz start again. Its probz gonna be to diffcult to do dates problem so letz give this a try
I got a combo box that letz me select the course i am studying.
(Theology in film, Mythology and Judiasm)
Underneath that i got the time scales for each one like thiz
Theology in film
Date coursework given
Date... -
yo guy totally. you rulez. such a help now i can gets me database to tell me when all me coursework needs to be done 4.
cheerz dudezLeave a comment:
-
Its ok dude. managed to sorts it out. I changed the ; to a , and it works perfectly. must be some random thing about access 2000Leave a comment:
-
its ok dudeo dont really care about this anymore. was to much of a problemo to deal with so i decided on another thingey mabob to do.
RespectLeave a comment:
-
Dude this so happened to me this one time. its cause the length of the report is bigger den a page. But thats no problemo to solve guy, just drag the edge of the report in until it becomes smallerz. Then try again and again until its small enough to print
RespectLeave a comment:
-
OK Dude. Please find attached a scheen shot showing my setup and the code.
What im trying to do is imput the date each action occurs and then have it automatically update the field next to it with the date the next action should be done by. But i only want to use weekdays cause thats what uni runs off savvy?...Leave a comment:
-
ok thanks dude. i will try and post a screenshot of my form in the morning. Will try again tonight to get it working and fingers crossed it will work now!Leave a comment:
-
could it be because i am using access 2000. Maybe that version doesnt support what i am trying to doLeave a comment:
-
Still not working :'( this time it says you omitted and operand or operator, you entered an invalid comma or character or you entered text without surrounding it in quotation marks. I copied the code exactly. then only changed Original date to read DateCourseworkG iven.
The code i used before when doing a 7 day week was =DateAdd("d",15 ,[DateCourseworkG iven]) and that works fine for a full week but i want to base it of university...Leave a comment:
-
USe a module on a form
Ok dudes heres the thing.
Thanks to the smiley one i have a code that sorts out a 5 day week but the problemo is i dont know how to use it with the form. i created a module with the code in but when i go onto my form the formula i have for dates doesnt reflect a 5 day week.
=DateAdd("d",5,[DateCourseworkG iven])
if i use that with todays date it gives an answer of the 22nd September instead of... -
ok i got where to put it sorted dudes. but when i try your function code it just comes up with
The visual basic model contains a syntax error. check the code and then recompile it.
i copied and pasted your code Smiley but changed Original date to Date courswork given and changed the 5 to 15Leave a comment:
-
Hiii
Im trying to do the same. could you please tell me where to enter the codeLeave a comment:
No activity results to display
Leave a comment: