Recent content by Sakhikid

I need like a code builder for command button in one form to open another using a reference number that you could enter into the form to lookup the recordand open its info in another form. So not just opening the form but also just showing that record so that changes can be made.

I have a form that assigns an Auto Reference Number to each record. Now the records are later edited. Is there a way that I can have the user enter the Reference number and come directly to that particular record that needs to be changed in the form. Like a dialog box that asks Enter Reference...

It worked!!! Thanx alot.

I have other fields with names, other dates and account numbers which don't seem to change. How do you relate those to the one date field and make them change if it is related to that one particular date field.

Got it. Thanx!! I just put in the condition Date()-30 in the expression box. But my second question is can I apply it to the entire record. Bold the entire record if this condition applies to the date part of the record?? Or it can only be done for that field. Coz I couldn't find anything in...

Perfect!!! Thanks alot

I need to print out a report from a start to end date. But theres a catch i also need to print those items from previous months that are not yet resolved. I have a checkbox that tells me if the record has been resolved or not. Is there a way that I can put both the conditions into my query, one...

How could you highlight the entire record on the report though... all this does is highlights the date. Is there a way to link it up with other fields??

Hi, I am having a similar problem. I have a database where i have records based on dates. I need to bold all the dates that are over a month old. Is there a way I can do that in my query or report??