Search results

i have this database, thats suppose to have have there names and then have the values (satisfactory, unsatisfactory, needs improvement) put in a seprate table but be linked to there names ( i know that doesnt make much sence so just look at my database) I have two problems. First it doesnt save...

i couldnt get the sMonth: Month([NameOfDateFieldFromTheTable]) part to work so i gave up and just changed the text to number, i feel so stupid, i spent 2 hours tring to fix that and it was that easy:eek: but i got it to work thanks

i think i almost got it to work but it goes January october, november, december, feb, then its normal it does 1,10,11,12,2,3,4,5,6,7,8,9 err i dont know why its doing that

umm im not sure i follow, but the names of the months is from the months field which i use a look up wizard and typed in the names. So i create anouther table just with the month names and the 1 for jan 2 for feb etc, relate them by the month and create a query from that to sort it?

I have my database and a field to enter months as a drop down box. It enters as the full word. I want them to be sorted so it goes January, Febuary, March etc in my report. I was searching the database and found something with this function DatePart("m",[Field Name]) If i knew how to use...

thanks thats exsacly wat i needed

ok i tried, i have a lable and then a text box, i put that code " =Format(Date()-Weekday(Date(),6)+1,"mmmm dd"", ""yyyy") & " - " & Format(Date()-Weekday(Date(),6)+7,"mmmm dd"", ""yyyy") " into the text box, when i click out of the text box it goes away, its not there in preview view either,

well i havent learned anything about modules so im not sure about the second part. now on to the first post, is this correct =Format(Date()-Weekday(Date(),6)+1,"mmmm dd"", ""yyyy")

in my reports and forms i want the date to be that fridays date. Ex if i entered data a printed now it would display 6/6/2003 instead of 6/4/2003

thanks

when access opens i want a form to pop-up, its just one form can this be done

i believe the validation rule in the table would be 9????????? ?=wildcard for any character and can be left blank 9 is a required character, i think or is it 0 well its one of them look it up of just wait for someone smarter then I to correct my self.

i was fooling around with the property of the form with out it open and i choose hiden attribute and now the form with the hiden form as the subform wont work, how do i unhide my form?

ahh thanks works now

here it is, there were no modules to import

its too big :( :confused:

ok

there are no other ones that i can find

i am just learning access so i dont know anything about macros or modules. ok so i created a table, form, and report for my data base and everything works great but i wanted a print report button on my form. I used the wizard to create it and after entering in the data i push the button and get...