Search results

Hi David, My scenario is I have a table with the following details Student_ID Student_Name Address Course_Opted Batch_No Payment_Details along with this table I have other tables wherein I maintain details about payments made, other facilities availed, etc. In the excel worksheet, I want to...

Greetings to everyone. I have the following scenario. I maintain a table of clients and their details in a database. I also have an excel workbook with some details. What I require is that when I key-in the unique Client_ID in a Column in Excel, the other details needs to be pulled from the...

Hi, Indexing the field with no duplicates is a good idea. But I would rather personally suggest, auto generate the ID. You can use the Autonumber field or you can setup your own ID generating routine. Try searching for Serial generating routines in the forum. Regards, Sakthivel

Hello Greetings to everyone, I am designing a form to collect the following: C_Name : Text (50) C_Add1 : Text (50) C_Add2 : Text (50) City: Text(50) ZipCode : Text(15) Join_Date : Date / Time for collecting the Join_Date information I would like to use the Date picker control. I tried setting...

Tried this "Insert into tblCountryState (Country, State) values ('" & Country.Value & "', '" & strValue & "')" and works. But the problem is after updating, the ComboBox doesn't update with the latest values. Sorry to bug you again, Can u please help. I also attach the Zipped mdb file with...

Tried but got a runtime error of 3075, Syntax error (Missing Operator) in expression "New Value" "New Value" is what I typed as input. Another ideas ?

Greetings to everyone, I have a table tblCountryState with the following structure pkID : Autonumber Country : Text State : Text Besides this I also have other tables tblStateCiry, pkID : Autonumber State : Text City : Text tblCountry. pkID : Autonumber Country : Text I have created a data...

Glad to hear I was able to help you. This is the way we learn from each other.

Hi, Why dont use the input mask feature of access. For your case the input mask will be L99999 for more information on input mask please refer to the following url http://www.uic.edu/depts/accc/seminars/access2000-intermed/tables-input-mask.html Regards, Sakthivel

Thanks Dave for clarifiying me on the difference.

Respected people, Can some one please advise me what is the difference between Null, vbNullString, "" The reason I ask is setting the property of text box at runtime ggave me some problems. when I set txtName.text = "" I get an error message whereas when I try txtName= Null works. Kindly...

Thanks Janr, Its working. Now that I have an idea. I'll try and reuse it. Thanks a lot for helping. I also thank all the forum members for helping me in this thread. Regards, Sakthivel

Thanks Mailman, I'll search for as you had said.

Sorry Mr.JohnLee, I attach the 97 and 2000 version of the same database. Regards, Sakthivel

Mr. JohnLee I am sorry for not giving a clear picture of my problem. I attach the Database so that you can go through and help me. Regards, Sakthivel

Mr. JohnLee I am sorry I don't understand you. I already have a form where I have 4 unbound textboxes One each for ClientID, ResPhone, OffPhone, Mobile1, Mobile2 and a command button. So when the user enters any of the four values and clicks the search button. I want the results to be...

Hello Everyone, I have a Table tblCustomers, where I store the details about the Customers like, CustomerID, Name, Address, Contact Number (Office / Residence / Mobile 1 / Mobile 2). I have designed a form where the user can give any of the detail like CustomerID or Name or Contact Number. and...

Mr. B, Thanks for the tip. Let me try and get back to you. Regards, Sakthivel

Respecred Mr.B, I am developing a Customer Detail Collection Application where I collect the details like Name, Address, Contact Numbers. The criteria for this form is as follows. Each member of the family will have a common number with a differential suffix. Say for instance Father will have...

Hi, I would suggest create new table say tblSerial and have as many fields as your department. Use a custom made function to set the next serial in the field and use them. I got this idea from another post / url which I am not sure. But I am uploading the example which you can experiment...