Recent content by Sharad

I have a Data collection program that has option group with 2 buttons. Say, Retail and Wholesale. When I choose Retail option than the combo box should populate from tblRetail by using the drop down menu. Once the selection is made from the tblRetail and other fields are entered Save button...

Hey this is just great....I will give it a shot....Thanks again....sharad

I am looking for Date and Time Picker for Access 97. Is there a posting somewhere I could find it? Would appreciate. Thanks.

I'm working with Access 97 on a windows XP environment and I have a simple create database connection snippet that is giving me the following Error: "Run Time Error 429" ActiveX component can't create object. This is failing on the the line reading: Set Brent = OpenDatabase("c:\abc.mdb") Dim...

I have a Form where these calculations are done for additive to be added to the product. User enters the name, weight of the product and at the Click of the Calculate Button calculations are done. I have been using the following code: Dim lbs As Double Dim ozs As Integer lbs =...

I have a Form that I use to enter the data into the Table. I have the code posted below. When I click Add Record some text Fields change to "False", others change to "0" and date fields end up changing the dates to 1899, etc. I cannot update the table. I am stumped ! Need all the help I can get...

You are right as to Setwarnins False could cause problems in detecting actual problems. I tested it several times and everything works fine. The users were getting annoyed to have the Message Boxes pop up. After that I tried the code; DoCmd.Setwarnings False <Run the Query> DoCmd.Setwarnings...

Can you attach your file file ? Are you using Access 97 ?:cool:

I have this Database program I am working with. The program works fine but when I click Add Record button it INSERTS the data into the Table. Howerver, before it appends it displays this Message Boxes warning that you are about to append a row, etc. Is there any way to control these system...

Mile - O - Phile Thanks again for your input in re: Upper Case. The code Text0 = StrConv(Text0, vbProperCase) converts all the first letters of all the words in a sentence to Caps. The other code converts only the firt letter to Caps :)

Users to search from a Form using the Data from the Table. :)

I have a Database where Item Name is stored in a table. Item Name could have 1 or more Items. How would I go about doing a search of the Record to locate any of these Items ? Appreciate any help. :confused:

Upper Case Text0 = UCase(Left(Text0,1)) & LCase(Right(Text0,Len(Text0)-1)) This is it. This worked great. 2nd Code did not work, maybe I did not give enough time.Thanks guys. :) :)

When data is entered in a text box and Add Record button updates Table how do I make the first letter to show in Upper Case ? Thanks :confused:

Auto Number Interestingly enough I had similar issue. I got it resolved somehow and it is working fine. In this case ActionItemID is a Table with AutoNumber. Start the Number with 0 and it should return : 2003-1, 2003-2, etc. and in the following Years it should be return : yyyyy.nnn 'Add...