Recent content by e2cheng

Hi I'm wondering how i check the size of my database in the immediate window Thanx in advance, Eric

thanks for the reply... sorry, my bad.. i typed it wrong in the previous message, it's actually capped in the code.. have no idea what up...

Same problems, but one step behind: hi, i was looking to do exactly as Wicklund has done. However, I was stupid enough to try something stupid and created some kind of admin lock on my database. I'm trying to get rid of this and follow directions in Newman's email, but I have issues. Does...

This is commonly used at the end of a subroutine. But what exactly is the purpose? does it save memory? Thank you in advance for your help.

thank you very much for the replies.. the code is as follows: dim mydate as date mydate = date If IsNull(txtBeginDate) Or IsDate(txtBeginDate) = False _ Or txtBeginDate > myDate Then MsgBox "Enter a valid beginning date. Try again." End If If (Not (IsNull(txtEndDate))...

just tried that.. same thing.. something is seriously wrong, i was using it the other day and it never gave that msg...

does anyone know the difference between using the + and & operators?? both seem to do the same hting.. thanx in advance

yep, sorry, it's on a form... but yeah i just tried inserting me. into it. still doesn't work...

Thank you for your rep Col, part of a subroutine that checks for a valid date before being used to generate an SQL statement. there's a whole bunch of stuff around it, but i just isolated the particular case that's giving me issues. Thank again, Eric

if (txtDate) > Date then msgbox "Date too big" end if i'm putting in "09/04/01" and I'm still getting the 'date too big' msg. any clues?? my comp date is set properly, but i was wondering if that function only checks the day field date+month field and leave out the year.. thanks in...

hi sambo, thank you so much again. don't know how much you've helped! passing in a form, ingenius... i will have to explore more.. but for now, it's time to get some rest. extremely grateful, eric

referencing hi, sorry to bother again, but let's say i put the code in a function Public Function recNum(objectName As String) As Integer Dim db As DAO.Database, rst As Recordset Set db = CurrentDb 'Set rst = db.OpenRecordset("qryDynamic_QBF", dbOpenDynaset)...

thank you all! thank you all for your help. i get it.. much appreciated!

yep MS DAO 3.6 Obj Lib is checked...

ok, i've tried changing that line of code and putting in my form name there. but i still get the same error. so i went back tot eh original and ran the code with it referencing a query, but i still get that error... not sure what's happening in this function... thank you for your patience...