Search results for query: *

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

Found it... Here is the code I used: Function Update( source, target ) Dim f1,f2,d1,d2,c1,c2 If fs.FileExists( source ) then set f1 = fs.GetFile( source ) d1 = f1.DateLastModified c1 = Year(d1) * 10000 + Month(d1) * 100 + Day(d1) If fs.FileExists( target ) then...

I have extensively used code posted on this forum by oharab (thank you sir!) to send lotus notes email from within Access. I'd like to know if there is a way to cause lotus notes to create the mail document in lotus notes and then allow the user to edit it and send it manually when finished?

I have a script I have pieced together from a couple of threads (this is my first attempt at vbs). My intent is to check and see if the local copy of an Access DB file is the same as the server copy and if not replace the outdated local copy with the new server copy (this is a front end). Then...

PHV, Zion7, & ArkM: Thanks to all of you for your help... My problem with other posts was the font used in Zion 7's reply and most other posts is too hard to differentiate between the quotes and the apostrophes and double apostrophes and such. PHV's was a different font and much clearer for...

So you guys are telling me that substituting 2 apostrophe's in lieu of a single apostrophe when it occurs within a string which it to be used as part of an SQL Statement will solve my problem? Why would LIKE 'O''Sullivan' work?