Search results for query: *

Hi All, We have recently converted our database from Access 97 to 2000. All went relatively smoothly, but I notice that now I cannot enter design mode unless I open the database in exclusive mode. To do this I have to kick everyone off of the system (which disrupts operations). This didn't...

I have been trying to create a field in my form that will update my table with the current date everytime the form is saved (a way of keeping track of the most recent change date). I have tried the Date()expression in the before and after update properties but it doesn't do anything, and if I...

Hi everyone, I have been searching around for a solution to this problem but can't seem to find one. I have a subform containing a field (called segment_#). I have created a command button to create a new record on this form and increment the segment_# field by one (actually it assigns a value...

Hi, Thanks for all the help I've been getting from the forum. I have a question about required fields and subforms. I created a form that contains a number of required fields, and a subform within it. The tab order is set so that the subform is reached before all of the required fields on the...

Hi Everyone, I might be out of luck here, but is there a way to have a table field updated via an expression on a form control? I have a text box on my form that calculates a value based on two other text boxes on the same form. The problem is that I can't get it to update the corresponding...

Hey there, I have creted the following expression to return a framecount from a user entry of "hours:mins:secs:frames" = (Val(Mid([timecode], 1, 2)) * 60 * 60 * 29.97) + (Val(Mid([timecode], 4, 2)) * 60 * 29.97) + (Val(Mid([timecode], 7, 2)) * 29.97) + Val(Mid([timecode], 10, 2))...