Recent content by SiberBob

Yes I have. On an existing record, changing a boolean value bound to the record will cause the "Before Update" event to fire.

That may be problematic: On the "tglReserveAppt_Click" event the "ApptReserved" boolean value for that record is set to True which causes the record to be locked for editing so the user can fill in the rest of the 'required' fields, but it also fires the BeforeUpdate event prior to those other...

Greetings. I am having a problem with record validation in access 2000. I have a table of records for appointments. I INSERT INTO the table records with available dates and times for the next three months when the form is opened. Those records only have the appointment date and time, and...

Yes. Actually the only time values allowed (entered by Update SQL statements) are 8:15 10:00 11:00 13:00 14:00 15:00 I can get the code above to work with either format of h:mm or h:mm:ss... as long as the time existing value in the table any existing value besides 10:00 or 14:00

I am having a problem with a DoCmd.RunSQL strSQL working in some instances and not in others... When the time provided in Me.txtBlockTime is either 10:00 or 14:00 the code fails. When the time is any other time it works. I have looked at the table and confirmed that records exist with the...

So how would you do this with iexplorer?

I wonder if I could just for/next loop through each file in the folder and see if the attrib settings for that file are set to currently allow delete? that would tell me if each file can be deleted by the current user...

I have a list of userids for all users (actually that information is in one of my tables). All users have the same rights to only delete files they created. On a Windows XP Pro system, our network admins have set the policies to restrict read / write / delete and such... Users can read other...

Thanks for the clarification on the code I have so far. I still need to figure out how to determine what user has privileges to delete which files... If I can find out how to read the username that has rights to a file, should be able to run through only those files the current user has rights...

Are the references I set in the Tools menu of the VBE saved in the MS Access.exe settings, or are they specific to the MDB file I set them in? I think they are saved in the mdb and thus follow that MDB whereever it is used, but I just need know for sure if I am right... Thanks! Bob L.

I need to write VBA Code to delete some files that are have security permissions set for administrators and specific users. I need to be able to write either a KILL sub or a .DeleteFile sub that will only delete those files for the current user [environ("Username")]... Any suggestions? Here...

You guys Rock! I had tried a variation of that earlier with CurrentProject.path & "\" & CurrentProject.name but apparently that doesn't work or I buggered up something in my syntax because the suggestion you both gave works flawlessly! Thanks - and Happy Thanksgiving!

I have a MS 2000 FE and BE that reside in the same directory. I want to set it up so when you open the FE it removes the link to the BE (regardless of where it is) and links to the BE that exists in the current directory of the FE. FE = "EquipRecord.mdb" BE = "EquipRecordData.mdb" Table to be...

Using MS 2000. I have an unbound form and I want to populate the controls on that unbound form with data from a recordset in a table in another MDB. What Refererences do I need to set in the VB Editor. Can you direct me to a "primer" about how to construct the code to display the data? I...

I can't seem to get either KeyPress or KeyDown to work on a userform in Excel 2000. Is that a known problem? Here is my code: Private Sub UserForm_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer) If KeyCode = vbKeyPageUp Then GotoPreviousRecord If KeyCode =...