Search results

Sorry! I don't know how to do this: "Change the placeholder strings in the constants at top of the DoReplace macro to the strings you want to be found and replaced. (Notice the spaces before and after the strings to ensure it doesn't find partial matches in other words.)" Could you give me a...

Thank you so much! Reminder: The word documents to be amended are all in one folder.

Thank you. My deadline is Tuesday 8am (I am very slow as I have a medical condition that affects my fingers).

Thank you so much GalaxiomAtHome :)! What kind of code is it? Macro? I look forward to receiving your code and would appreciate it ASAP as I have a deadline and I am currently doing it manually :( whilst waiting for a reply...

Hello everyone! OS: Vista Software: Microsoft Word 2007 I have one folder which contains 300+ documents. I need to run Find & Replace for two words (it is the same two words for all documents) : eg. Find and Replace: A with B and then C with D. I have found a command button called...

Thank you so much Beetle everything is working fine now.. I just need to play around with my options a little more and decide which "reminder" type to go for now so I thank you kindly for showing me how to set a reminder in two different ways :) To be honest my favourite so far is your "List...

Could I email it to you?

I have tried this both of the following and nothing works: Private Sub Form_Load() If DCount("*", "qSupervisions") > 0 Then DoCmd.OpenForm "frmqSupervisions" End If End Sub AND Private Sub Form_Load() If DCount("*", "qSupervisionsReminder") > 0 Then DoCmd.OpenForm...

Another question if I may. Do I have to redo everything that I did for SupervisionsDueDate (above) for all the tables/fields that I require a reminder for? i.e. I need another reminder for the tblTrainingRecord (field UpdateDueDate).

Hello Beetle and thank you for your kind help. I think that I have managed to do everything (see attachments 8, 9 and 10). However, I seem to be having a problem with the last instruction (on the Switchboard, Event, On Load, Code Builder) - See attachment 11. When I close, save and re open...

..................bump ;)

Thank you for the above :) How do I delete the code that I created (draft5 attached)? I have created a query qSupervisions (draft6 attached) I have created a form frmSupervisions (draft7 attached) From what screen do I create the Code Builder to insert: Select * From tblSupervisions Where...

I don't think I understood that. Please see the attached and it is not working. Could you be more specific and give step by step instruction. If it is easier please kindly email me spollak77@hotmail.com Many thanks.

I would appreciate it if someone can help me please. If you have any questions please do not hesitate to ask me as I know many of you are finding hard to understand my posts. See attached a print screen of my database (relationship screen). I really am working on a database. I do not...

How does my database look now? I really worked hard on it and would appreciate your input before I move on to another area. Print screen attached. Thank you.

The reminder does not exist yet. I clearly said that I wanted to set an auto reminder hence the title of my post and the first line of my post: Access 2007 – Setting an automatic reminder 15 days prior to (see below) I have an “UPDATE DUE DATE” field in one table and a “NEXT SUPERVISION DUE”...

Could you please let me know what don't you understand?

Access 2007 – Setting an automatic reminder 15 days prior to (see below) I have an “UPDATE DUE DATE” field in one table and a “NEXT SUPERVISION DUE” field in another table: tblTrainingRecord UpdateDueDate tblSupervisions NextSupervisionDue I have a Switchboard that is loaded when the...

Hello John Big Booty, I would like to set a reminder on the following two tables: tblCourseDate tblSupervisionDate (15 days before the date in the following fields) I have a switchboard that opens on start up with already 3 separate open forms buttons. I have selected Event, then On Load...

Will it be to much trouble to ask how you did the first button i.e. employee and I will do the rest... I cannot understand how you made of form of just employee :(