Search results

That worked... The only problem is I put it on the "On open" and "On timer" events. The timer works great... but the "On Open" opens the second form in the background. Any way to open it on top?

Ok, I put this code in the "Ontimer" event: If DCount(Ticket, Qry_Alert) > 0 Then DoCmd.OpenForm Frm_Alert End If "Ticket" is the field I was going to count (Any field in the query will work right?) Qry_Alert is the Query that finds old records Frm_Alert is the form I want to...

I have a form in continuous forms mode... Each entry is something the user is supposed to check on once and hour and update. I have a "Last updated" field. Now() goes into that field every time the record is updated. I have a querry that will show the users records that are over an hour old...

Nevermind, I figured it out

That worked great! I made 1 change: If Me.Ignore Then Me.[End Time]=Me.[Start Time]+TimeSerial(4,0,0) Else Me.[End Time]= Null End If The 0000 date that "Empty" made would mess up my query Thanks!!!

I have a form with 3 subforms. 1 in the header, 1 in the detail and 1 in the footer. I would like to refresh all 3 every 10 seconds. I can only get it to refresh 1 by putting this in the ontimer: =Forms![MAIN FORM]![Subform].Requery How do I do multiple forms at once? And if it's code, please...

This is what I have on my form: StartDate / EndDate / Ignore? Startdate = Now EndDate has no default and Ignore is a Yes/No checkbox What I want is for the EndDate to be blank... unless you check the ignore box. In which case the EndDate defaults to StartDate+4Hours. I can figure out how...

Hmm... This looks promising, but I dont really know how to implament it.

I have a database that I plan to use to help us manage an old "Remedy" system.... There is a field for "Ticket number" I want to be able to click a button and have this ticket open in Remedy. Remedy DOES have a link system. When I creat a link it creates a file like this: Ticketnumber.ARTask...

I have a form that has a main for, a subform, and then another subform inside the 1st subform. The form works like this: Conact info --->Call info and notes ---> Orders worked Each of those being nested as they appear. The problem is, the user usually jumps...

Well, first off, I wasnt really worried about the $$$ or anything. It was more a matter of my boss claiming it for her own... then asking IS to create a new one based on what "She" had told us to write for her... But it all worked out in the end. The IS person that was put in charge of the...

I almost think you are using the field wrong. Set the closing date in the field and leave it. Then create a different field for "Sales Status" or whatever... In that have "Pending Sale" "Closed Sale" "Lost Sale" etc... Then you wouldn't have to worry about it at all...

I use the database myself... I'll know before anyone else. They aren't going to use Access... I promise you that. We are going to get some horrible pre-packaged ticket system. I bet it will be web-based as well... Some horribly slow Java behemoth. We already use Right-now-web for our email...

I made a call trackign database for a small tech-related call center I work in. Total of 5 people using it. It was your basic Contact info with a subform for tickets... Well my boss was all excited about it and was showing it around. Now suddenly our IS department is taking it over and I am...

I have a call tracking database with 5 active users. Ocasionally the database will freeze, usually for several people at once. It will say: "Can not update record; Currently Locked" The only way to fix it is to close and re-open. I split the database, compiled it and then created an MDE file to...

I'm trying to incorportate Bob Larsons autoupdating utility... It works in that it checks the version, and if its wrong it creates the batch file... but then Access gets a message that says "importing: blah\blah\blah\NoPhoto.jpg" and access freezes. It doesn't delete the old file or copy the new...

Yep, that did it. Thanks!

Is there an easy way to switch from the table to the query? I'd rather not re-write the entire form if I don't have to.

I did search the forums on this subject and can not figure out how to do what I want to do. I have a form and subform setup. Basically by main form has contacts and my subform has log notes. It logs the date for every new record. It sorted fine up until yesterday when I ran an update query to...

I figured it out. My query now looks like: Agent | Agent | OrderDate Groupby | Count | Where Show | Show | Dontshow | | >=Date()