Search results

It is even trying to add the field to the MSys tables too. Otherwise this is good. Thank you Ranman256

Hi All, I inherited an old database. Not designed too well. Nearly 100 tables with different types of names. Some table names start with and "_", some with "tbl" and some just names. I want to add a new field called "TimeStamp", date/time, and default value Now() to all the tables. Any...

Hi Bucephalus, Post your database.. I will have a look and tell you... Raghu

Ops If service is 3 remove the what ever the alphabet and replace it with N unless the numerical parts starts with 8 then replace with O

Hi Everyone... Attached is a small database with one table with two columns as shown below. Service Service No. 1 F327445 1 421547 1 8014432 2 O22771 2 L185244 2 O852424 3 O321322 3 R552552 3 O8471254 Basically I want to do the following If service is 1 remove the...

Hi Megatronixs, Try this...

Hi JHB, Thank you. I am trying. will let you know when I get it working.

Sub DataToBeSent() On Error GoTo ErrorHandler Dim db As DAO.Database Dim rs As DAO.Recordset Dim sState As String Dim sClub As String Dim s As String Dim sSQL As String Dim dDate As String Dim i As Integer Dim activeDir As String Dim FileNum As Integer activeDir = CurrentProject.Path sSQL =...

Hi Every one, I have two attachments to be sent out in my emails. I am unable to send multiple attachments. So I have combined both the documents and sending one bulky document out to people who have not supplied their Medicare Levi Variation form and/or Employment declaration form How...

Thanks JHB. It is working beautifully now...

Thanks JHB, but it is taking 2 attempts for it to work. I don't know why. Regards Raghu Prabhu

Got it working a bit, but, have a look at the attachment Please. When I input No. Of Payments equals to 2, it is prompting me to input the IDLPA, how do I get around it? It has to pick up the IDLPA automatically. Thanks Raghu Prabhu

Hi All, I have uploaded a small database. I keep track of payments for people who receive a language proficiency allowance. Usually the members receive this allowance for two years. Sometimes they receive it for one year. Lang Level DateQuaFrom DateQuaTo DatePd From...

Gina, Congratulations on getting the thing working. what did you do??? Regards Raghu

Gina just take a copy of your database, in the copy delete all the extra bits, delete most of the data may be have one or two rows of data in the main form and one or two rows of data in the sub form. compress it then zip it an load it. That way I can quickly look at it, fix your sub form and...

Hi Gina, Upload a sample of your database and I will tell you what to do.

Attached a small database to look at. When the database is opened, form “frmSingleDate” pops open. Click “Do Something”, I get a dialog box asking “Would you like to change the date before proceeding?” Click on “Yes”, form “frmSelectPayPeriod” opens. Click on “Find Pay Day” and a...

I have attached a small database. My organisation pays an allowance for knowing foreign languages. The payment is for two years. The employee has to qualify by passing an assessment. He or she is paid according to the level of competency. There are four levels lower, intermediate, higher and...

Yes I am. My religious switch was turned off on my 14th birthday in a temple in India. I am a Hindu by birth and proud of it. Hinduism is not a religion it is way of life. All my relatives are very religious. My late wife was too. I being an atheist did not stop me taking my wife to the temple...

Hi All, I have a form with three list boxes. List1, lstPP1, lstPP2 When I double click an item in "List1" I want the item move to "lstPP1" . That I am able to do. For example item is "2012/21". With the same action how do I make the next item in "List1" ie "2012/22" to move to "lstPP2"? How...