Search results

I have a combo box on one of my forms linked to tblreason which is a list of reasons which need to be selected... one of them is "to settle to work and to stop distracting other students" the text field is set to length 255 in the table but everytime someone selects this option it comes up with...

I have a query which draws information from 4 tables (main, tblpreviousweeks, tblexclusions, tblstandardletters2) each has Admission Number as a field and is unique in the main table. tblpreviousweeks, tblexclusions, tblstandardletters2 can all have duplicate records.. I am trying to do a...

Do you think that will work with the Exclusions screen that you helped me with???

what Autoname correct feature didnt even know it existed?

AV Definitions???? What are AV Definitions?

Anyone any ideas what is going wrong and please dont tell me I have a virus! I am creating reports and saving them.... but as soon as I close the application and reopen they have mysteriously vanished!!! I have tried importing them... same thing happens.. Any Ideas?

will that then work when they use the data for mailmerging to word? Cause its for letters that are sent out?

Dat problem... Much to my annoyance... the Head Secretary has now decided that having 9 September 2003 as a date is not good enough and she now wants 9th September 2003 etc.... ie.. all the st, rd, th's.. the only way I have found to do this is through a query.. where basically I tell it Date...

Where do you get the Add-ins from??

Just to let you know... Thanks loads Milo-o-phile... it is working brilliantly.. thanks for your patience...

I have a query... which holds say field 1 and field 2... when I put it in a report though I want field 1 to be normal text and field 2 to be underlined text.... That is no problem but actually what I want are the two fields to run along next to each other to make up a paragraph... and the only...

Will this also take into account the holiday dates in the table?? Or am I back to square one again?

Hi I have a serious problem...with Access 2000 since I have moved to Windows 2000 Professional, when I am in design view/saving I am constantly getting the following messages. I only have the database open and no other applications... The Instruction at "Ox77fcc453" referenced memory at...

Not that you want to hear this at all but it is still calculating weekends.....

ok.... managed to open it... your form returns weekend dates though...

Stuck Erm........ it ain't working....could someone be nice and take a look..... Pretty Pretty Please

will call anyone honey if they can fix my problem;)

thanks honey.. will take a look:)

I have a code below supplied by Milo-O-Phile Public dteTemp As Date Public Function SingleDate() As Date SingleDate = dteTemp End Function Public Function CountDays(ByVal dteStartDate As Date, intDays As Integer) As Date On Error GoTo Err_CountWeeks dteTemp =...

Report totalling problem:) Got a cracker of a problem here... Morning by the way:) right I have report called Weekly DFL report... basically kids start of with a total of 20 points which is held in tblTotalDfl for every DFL slip issued they lose/gain points... the max points they can have is...