Search results

Hi All, I am still using Access 2003. Some of the users of the database I creat are quite old. Have difficulty reading small fonts. I use "DoCmd.RunCommand acCmdZoomBox" on double click events of text and memo fields for a zoom box to pop up. My question is how I make the fonts bigger and...

Hi All, First of all A Happy New Year to one and all. I downloaded this small sample database from Allenbrowne’s site at the following page http://allenbrowne.com/AppFindAsUType.html . I have modified it to suit my working database. I have added a new form to the sample. When a company name is...

No worries. This forum is the best there is in this world. All the people are very helpful and don't mind solving a problem or sharing an idea. Raghu Prabhu

Hi All, I have attached a small database (Access 2003). This has table to show customer details and order details. It also has 3 forms and 2 subforms. The forms are as follows frmAddNewCustomer is to input new customer frmAddNewOrderDetails is to input new orderlines by customers...

I put a label on the report that does not print. It says " Press Esc to Close Report, Control + P to Print Report" Esc is about ~ When Control + P is actioned the print dialog box opens. Hope this helps. Cheers Raghu

Hi All, How do you Send SMS from Access database? I received a SMS from my dentist and the receptionist told me that the database sent it. I was wondering how it is done. Raghu Prabhu

I inherited a excel spreadsheet and cannot figure out the calculation in column L of main worksheet. Function code in Column L =IF(K3<>"N/A",IF(I3 = "CANCELLED", G3 +Q3, IF(OR(P3+1-G3>(I3+1-H3+Q3,P3=""),G3+Q3+S3,"N/A")),"N/A") Explaination of the function is as below. If K3...

Sorted it by way of using select case method. instead of one line of code IIf(LookUp("incrementOf","tblPFST","tblPFST.serviceOf='1' And tblPFST.rankOf='CAPT'")>5,5+1,"N/A") I ended up writing 500 lines of code. Cheers Raghu

I have attached a small database. In the "sFrmIncrements" there is a field named "newIncrement" I am trying to update the field but is not working. I don't know why. IIf(LookUp("incrementOf","tblPFST","tblPFST.serviceOf='" & [serviceType] & "' And tblPFST.rankOf='" & [rank] &...

Thanks Plog will try out your suggestion and see how it works. 18 May 2012 Hi Plog, I have attached a small database. Please have a look at it. Thanks Raghu PS 20 May 2012 Have been able to solve. Cheers

Hi I have a table called tblOffset. It has the following data ID Surname Code1 Code2 Code3 Code4 Amount payPeriod 1 Prabhu aaa bbb ccc ddd $1,234.00 2012/21 2 Jain ccc ddd eee fff $1,233.00 2012/21 3 Kumar ddd eee fff ggg $1,245.00 2012/21 4 Singh aaa ddd eee ddd $1,236.00 2012/12 5 Reddy aaa...

That is what I have done. Imported into a temp table and updated the required field.

Hi Alansidman, Each fortnight I get a new data source txt file. Next fortnight it is going to have "2012/22" in the first line. I want to append the data into one table and keep adding each fortnight. Thanks.

Thanks Alansidman but every fortnight the number changes. I want to automatically pick up the number and update the field.

I want to import data from the text file. I have been able to do that. The first line in the txt file is a string "2012/21" and this is causing "New Text Document_ImportErrors". Questions 1)Field13 in tblData is date in a string format. How do I change it to medium format? 2)How do I...

Hi, I am trying to add a new record in a sub form. The following code is working. How do I make the cursor to go to a certain field in the form? I want the cursor to go to or set focus in a field named eDate. Private Sub cmdAddNewReocrd_Click() Me.SF_AccountsSub.SetFocus DoCmd.GoToRecord , ...

May be this is what you want. It works but, when the form is closed, the "TickBox" goes back to value 0. You may need an underlying table for that. Cheers Raghu Prabhu

jzwp22 Thanks. I have attached with one form now. Cheers

I have attached a small database in Access 2003. It contains 14 forms. I think 10 forms are redundant. I have six forms as listed below. All the forms are similar. On the frmSplash I have 6 buttons to open these forms. frmCeaseOpenARMY frmCeaseOpenNAVY frmCeaseOpenRAAF frmCommenceOpenARMY...

Thanks a lot philben! I was able to use your designed query and make my life a bit easier. Well, I am still learning Access and will be learning till my last breath! Cheers Raghuprabhu