Recent content by kamulegs

Hello I searched for a word forum where they helped me make it work Just for benefit of some one who may have the same problem here below is the working code Private Sub cmdContracts_Click() Dim db As DAO.Database Dim rst As DAO.Recordset Dim strSQL As String Dim strFilePath As String Dim...

Hello Thank you for the reply I did not know that this forum only applies to access VBA Every thing was works except formating the bookmarks Ronald

Hello friends I am using office 2007 I use a code to automate creation of employee contracts using a word template. I want to add formatting to the information inserted like bold, italics, etc Here is the part of the code where information is inserted from the record set With wrdDoc...

Greetings I have been searching on how to set expiry date of a trial version of DB I have come a cross the code below If i run the sub SetExpirationDate, and check in the registry, i do not see the entry. If i run the sub UpdateLastUseddDate, i get a runtime error: Invalid root in...

Thanks so much it has worked after i implemented cascade delete. But i believe it is ok because if a booking is deleted, all the related information should be deleted

Greetings all I have main form/subform set up and i wanted to include a delete button on the main form( the undo created with wizard button doesnt work ) . I have tried the code below but it takes like 2 minutes to execute. Deleting just a few records(like 4). tblBooking is main table and...

Hello jdraw I am sory for that oversight of attaching an access 2007 DB Thanks for the links Now i have attached a copies of the DB in access 2000,and 2003 versions Can please kindly look at it and advise? Before i continue, i want an expert opinion on the database schema Thank you Ronald.

Thanks for the link I have got ideas to improve on mine What i also want is a comment on the table structures i have come up with whether they are normalized. Thanks Ronald

Greetings to you all I have been trying to design a DB to track bookings and related transactions at a small hotel( around 20 rooms) . I am not a professional programmer. I am learning Ms Access programming by participating in online groups and reading books. Briefs about the DB Bookings are...

I have given up on DlookUp Tried the Dao code bellow which i am still testing but so far it has been good

Thanks spikepl I have tried your suggestion But put the strSql in afterupdate event to see the results Here is the code In the immediate window for the strSql i see 1 printed The dates are printed correctly Any ideas? Ronald.

Hello I am new to Access World Forum My access programming skills are intermediate I have been trying to create a dlookup to check for overlapping bookings but over 3 hrs, i couldnt get it correct. I get a message that is there is a overlapping booking even where there is none!( i have...