Recent content by geekay

A simple function can be written to meet your need. I am giving one. Call this function when u want the required date after five working days Public Function AddDate() As Date Dim StartDate As Date, Count As Byte MyDate = Date Count = 0 Do While Count < 5 MyDate = MyDate + 1 Select...

Let me check it later

Sure it can be done. There are various methods to do this. If the second form is a subform of the first it is rather easy. Don't bother, it can be done if it is an independent form too. Can't explain more without knowing the user interface and other details. Attach your mdb file to get the...

Add two lines of code one before and the other after your Do Command statement as below Application.SetOption "Confirm Action Queries", False DoCmd.RunSQL Sql Application.SetOption "Confirm Action Queries", True

Check your mailbox to get the 4th version. It includes sub series ranking. Thanks a lot for the experience given by your project .........Bye

I hope you have discarded the first two mail attachments and using the 3rd one. Still I dont know from which country you are

I have returned your databse with the coding needed for the task Best wishes

Hi friend I have done the coding for you. Testing is only remaining. Unfortunately I am away from home for few days for some duties. I can do any more works for you only after 26th July. The database you supplied is not with sufficient data for testing. In the meantime you can supply a database...

Where is your attachmant?

I dont think that your problem is a difficult one. But the way you present it makes it difficult to understand. If you want to get a solution you can attach a database with a few records, and a brief discription about what you really want. I can help you with codes in it

You can write a Public Fuction to convert your string to title case. You can call it anywhere in your project to convert a string to title case. If you can not write it yourself, please feel free to ask. I can give it for you. I think it is better helping to fish than giving fish

Your posting did not give sufficient information to for the exact answer. However try the following and if not working please come with more details IsDate([Transactions].BirthDate) = True And [Transactions].BirthDate > #01/01/1900# ...

Understand the difference between 'Null' and 'Null String'. Null can not be used with a relational operator like >, <, =, <> etc. There is nothing in Null and hence it can not be compared. So rewite the statement as below Private Sub txtSURICCode_GotFocus() If IsNull(txtSURICCode) = True Then...

Specifically say what is your need. Do you want to ensure that only one combo box is selected before the user clicks the command button to make report? What is the job of your text boxes? Put clear questions here. If not you will not get replies.

Bob is still telling what I did not mean. Please see what I said clearly. "..........Only thing the code need to work is to give the names of the controls (........) as specified in the code............" I reapeat; the code will work irrespective of the field name. it may be diiferent or same...