Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SiberBob

    Validating existing records with new validationrule

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

    Validating existing records with new validationrule

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

    Validating existing records with new validationrule

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

    Having problems with DoCmd.RunSQL

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

    Having problems with DoCmd.RunSQL

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

    Opening a web page in Firefox using VBA

    So how would you do this with iexplorer?
  7. SiberBob

    Need to Kill or .deletefile

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

    Need to Kill or .deletefile

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

    Need to Kill or .deletefile

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

    references stored in exe or in mdb

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

    Need to Kill or .deletefile

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

    Need to confirm fe linked to be in current directory on startup

    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!
  13. SiberBob

    Need to confirm fe linked to be in current directory on startup

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

    Need help populating an unbound form with ADO recordset

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

    KeyPress and KeyDown not working

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

    Problem copying file then running file from scrip

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

    Open then edit Lotus Notes mail from Access

    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?
  18. SiberBob

    Problem copying file then running file from scrip

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

    Dbl Quotes vs Apostrophe in SQL

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

    Dbl Quotes vs Apostrophe in SQL

    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?

Part and Inventory Search

Back
Top