Recent content by pacsfo

update flag Me.RptCompleted = True should do it (if it's a yes/no field) otherwise Me.RptCompleted = 'Yes'

email code For the email, if they have outlook installed, you can use something like message = me.field1 & me.field2...... Set MyOlApp = CreateObject("Outlook.Application") Set CheckMail = MyOlApp.CreateItem(0) 'create new mail item CheckMail.Subject = "yadya email subject" CheckMail.to =...

image? I'd just give up and paste an image that looks the way you want...

reopen? The only thing I can think of is opening a second instance of the same db and then closing the first one...

dlookup? Try this in the afterupdate of textbox1 (assuming table has 2 columns: id, returnvalue) Me.textbox2 = dlookup("returnvalue","table","idvalue = '"& Me.textbox1 &"'") Or can you just use a combo box fed from the table?

normal (kind of) it's normal and it sucks! It's all the traffic moving across the 2. I ussually try optimizing the queries (bring only the needed fields and only the records that you need to display) If you can, compile the front end and distribute it to the end users so that they can store it...

I'm trying to setup a form that displays data in a calendar format i.e. a full month with entries in each day (something like Domino's Calendar view or the Calendar folder in Outlook). Does anyone know if this is possible (any ActiveX control out there)? Thanks

appending If the field where you are putting info in is text, try Me.[fieldname] = Me.[fieldname] & Newvalue If it's numeric, try Me.[fieldname] = Me.[fieldname]*10 + Newvalue Hope it helps

back end security Try setting up security for the back end db (security for the front end is kind of irrelevant if you compile it). You can use the same security file for both (the .mdw file) and set the default user access ('Admin' user) to the back end tables to 'no access' (uncheck all...

I'm trying to setup a form that displays data in a calendar format i.e. a full month with entries in each day (something like Domino's Calendar view or the Calendar folder in Outlook). Does anyone know if this is possible (any ActiveX control out there)? Thanks