Search results

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...

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...

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...

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...

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 have a basic trouble ticket type database that I built. It records troubles and auto fills the date and time when a new records created. I want a simple query that will display the number of calls that each person has taken today. The problem being that If I use >Date()-1 I will get calls...