Recent content by MaDmiX

No Luck :-( I tried both importing and exporting the objects but I still get the same "You don't have exclusive access" error. It seems that Access 2000 sees these actions as design changes and won't allow them. I don't really understand how the front end/back end design wil help me get around...

Thank you NorthNone, I don't think that we will be able to get a copy of Access 2000 Developer, so this option is out. But since I am the only developer of this app, maybe the second option will work fine... I hope. I will experiment with keeping a local copy of my database and exporting...

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

Hi GingerR Using Now() might work fine if I can format it as "mm/dd/yy". I'm using it in a query and the user inputs dates from a form to set the criteria. I tried Now() without the formating and the query didn't like that. Right now I have it working via a workaround (but I hate...

Hi GingerR, I tried using it as Date(), but the strangest thing... everytime I would save the form, Access changes the expression to Date (removing the "()"). I don't know if this has anything to do with it, but prior to adding your code, I had a field in my table which I had named...

Thanks GingerR, I thought it might not be the correct use of that action. Thanks for your help. I had to substitute Now() for the "Date" expression in your code because I kept getting a runtime error that Access couldn't find the field called "Date". Hopefully I will still...

I tried using the following code as an event procedure in the before update event of the form, but I got a "sub or function not defined error". Private Sub Form_BeforeUpdate(Cancel As Integer) SetValue [TQC_Sheet]![Last_Update_by] = CurrentUser() SetValue...

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

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

Thank you SBendBuckeye, I see where I went wrong and corrected the code. I got a call from one of the guys in the tech room. Seems that the segment_#'s are occasionally being all numbered "1". I had set the default value for this field to 1 so that the first segment would # properly...

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 Allanon, Thanks for your suggestion. I was able to use the "Tag" property to flag the "required" fields, which I then checked via a class module. When the user clicks on the "print report" button there is an If... Then statement that runs the class module and...

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

Mike, I got it!!! Heres the final code: Function CnvToTime(FrameCount As Long) As String Const FRate = 29.97 Dim Hours, Mins, Secs, Frames, TotalTime As Long TotalTime = Int(FrameCount / FRate) Hours = TotalTime / 3600 Mins = Int((TotalTime - Hours * 3600) / 60) Secs = TotalTime -...