Search results

May be you are looking for this. This is basically repeating the data. You will bloat your database! Cheers Raghu Prabhu

It is simple. I have attached a small sample database. The control has to be combo box. It should be populated by the names. Hope you can understand it. Cheers

Hi, This is a small metrics database. Please use it but leave my details in it. My work wants to keep a track of tasks people in various sections do. So I came up with this. Raghu Prabhu Melbourne

Thanks JANR, Rabbie and Mike. Your simple solutions have been very helpful. Cheers Raghu

Hi All, Attached is a small database. I have the following problem. I am trying to save a copy of the records before changing the various fields. To do that I click the "Copy?”and then I click cmdCopy button. I cannot copy if there is an “ ‘ “ in the string of the field. For example I can copy...

I am new to Access. Been at it on and off for a few years. Dispite all this I feel I have just dipped my toes in a VAST sea called Access. Learning new things every day. Thanks. Cheers Raghu

This small attached database may be of help to you. The buttons should be set transparent. This is in access 2000.

Hi Could you please zip the databases and put it on line please. I can not download your databases. Cheers Raghu Prabhu

Hi, Finally was able to design and get a job tracking database running in Access 2007. My client is very happy. I split the database, put the back end on their server, converted the front end to accde and connected it to the backend. Made a copy of the accde and put it on all the...

First of all Wish you all a Very Happy New Year! Now the problem. Could be related to this thread. I recently got a new computer with Access 2007. It took a bit to get used to Access 2007. I designed a database and had a few lines of VBA on each of the form. I compacted the database and the...

Hi I am looking for a job tracking database. Any one have a simple job tracking database? Much appreciated. Thanks Raghu Prabhu from Melbourne Have a safe and Merry Christmas and a Happy New Year! Please don't drink and drive!

Thanks that was very helpful. I am able to fix the problem. Cheers Raghu

Hi, I have attached a small database. The frmReports has 8 date buttons. 5 of these buttons are working. Code for Today, Yesterday, This Week, This Month and This Year are working. What is the code for Last week, Last Month and last year please? Thank you. Raghu Prabhu

I have a table named tblDEFPAC with Given Name, Surname, Phone, Fax, Emailaddress, userID and anID as fields. This table stores all the details of the employees. In the second table tblClaims I have Name Of payee, Input by, Input date (default value is date()), anID and userIDString .The...

Making a main menu First create a form called "frmMainMenu" Then from the menu View -> Code paste the following Option Compare Database Option Explicit Private Sub Form_Current() DoCmd.Maximize End Sub Then from the menu Tools -> Database utilties -> Startup Display form/page...

Hi, I found this code useful to repeat some field values in a continuous form. Improved it.... Cheers Raghu Prabhu

Hi, In my database if the user wants to change a record, I make them store the old record in another table. I am using the following code. Private Sub cmdArchive_Click() On Error GoTo ErrorHandler Dim conn As ADODB.Connection Dim i As Integer Dim s As String Dim sSQL As String sSQL =...