Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: rushitshah
  • Order by date
  1. rushitshah

    Can the form be created dynamically??

    yes.. I just got it and did that..change the names of text boxes and now seems ok. But is there any way to change these names of text boxes in VBA code? Or I have to manually look for each text box and change its name?? Rush..
  2. rushitshah

    Can the form be created dynamically??

    Ginger.. Thanks.. For Text134..I tried a lot to change it... Here's what I am doing.. On the form I put textbox from tools menu. It puts two boxes on the form, one has unbound written in it. and the other has text134. Then I click on text134 box and rename it to Quarter1. and then save it...
  3. rushitshah

    Can the form be created dynamically??

    Will this kind of logic work?? If IsNull(Me.Text134) = False Or Me.Text134 <> "" Then rs!January2005 = Me.Text134 rs!February2005 = Me.Text134 rs!March2005 = Me.Text134 Else rs!January2005 = Me.Text10 rs!February2005 = Me.Text24 rs!March2005 = Me.Text26 End If...
  4. rushitshah

    Regarding entry from the form in to the DB tables.

    Hey Missinglinq.. Where are these options? In the properties of forms or should I include it with VBA coding? And is this going to work for unbound form too?? Thanks, Rushit..
  5. rushitshah

    Regarding entry from the form in to the DB tables.

    Hello.. I am doing data entry in the tables from the form. The thing is that the form when opened goes on the first record of the database and displays what is there. If I change something it is directly updated in table. If I mark form's data entry field as YES then, it does not show the...
  6. rushitshah

    Can the form be created dynamically??

    Thanks Ginger.. By updating other fields of DB by some fields of DB I mean is... Consider..I have a product, television. I want to forecast its price monthwise for some years... so is it possible to create the fields dynamically when the user enters values from the form. The form will have...
  7. rushitshah

    Can the form be created dynamically??

    Ginger, Yes, It is like the whole application is dynamic. I will say it as a FORECAST DATE. Compare current date with forecast date. Decide which timeframe are you in? I mean by time frame is.. if 6 months then -- I need to ask the user to enter the weekly data and roll up that data to...
  8. rushitshah

    Can the form be created dynamically??

    Thanks a lot for replying Ginger. It is like for 6 months of forecasting I need to ask the user to enter the weekly data and roll up that data to monthly data and quarterly data automatically by updating the table fields. If the time for forecasting in more than 6 months to 2 years, I need to...
  9. rushitshah

    Can the form be created dynamically??

    Hello... I am working on a applcation that asks the user to enter the data in to related tables from forms. Consider, a company that works on testing of a product and has some parameters of that product. They are doing forecase for those parameters. In April 2004, they have data for the...
  10. rushitshah

    To verify data while entering into the DB from Forms

    got it Trev.. Thanks.. By the way can you guys refer a very basic good book for VBA coding for Access 2003?? Rush..
  11. rushitshah

    To verify data while entering into the DB from Forms

    yes. I clicked the button. after opening the form, I kept data in both the text boxes and hit the button, so the data entered in to the table. Now both the textboxes are empty. If I hit the button at this time, it adds blank record, it is not generating the error message. Shouldn't it run the...
  12. rushitshah

    To verify data while entering into the DB from Forms

    Hi Ginger.. I think there is still some minor glitch. For the first time it works ok. Initailly if I leave the textbox text0 empty, it generates the error box. But if I add something from that textbox first into the table, and then without closing the form, if I leave it empty it does not...
  13. rushitshah

    To verify data while entering into the DB from Forms

    Hi Ging.. Thanks a lot...it is working.. even I should have thought of that...!!! But you are great...I think I will allow you to take rest for today...Thanks for your help. Will post the thread if some help is needed again. Rush..
  14. rushitshah

    To verify data while entering into the DB from Forms

    tried with it.. But not working..still the message box is not popping up. I am leaving text0 field empty and in text2 textbox keeping some data and then hitting the button. But it adds blank record in test table and adds the text from text2 box to test1 table. Rushit..
  15. rushitshah

    To verify data while entering into the DB from Forms

    The problem is even if the Text0 textbox is null, it does not generate the error message box, and it enters the blank record in the test table. So it is not checking for the mendatory field condition. Rushit..
  16. rushitshah

    To verify data while entering into the DB from Forms

    Hi Ginger..Still having problem. I have two tables. Table1: Name Test -- Two fields, TestData(Text) Number(AutoNum,Primarykey) Table2: Name Test1 -- Two fields, Number(Number, for relation) and Text (Text) and one button command4. When the button is hit, data...
  17. rushitshah

    To verify data while entering into the DB from Forms

    Hey Ginger... I tried it with Text0 only... But it is not working... This is just when asking question I pasted it from the top of this page...so sorry for confusion... Rush..
  18. rushitshah

    To verify data while entering into the DB from Forms

    Thanks Ginger.. But still facing problems with mandatory field... I am checking if the field is empty so adding the following code in the beforeupdate event of textbox Text0. Private Sub Text0_BeforeUpdate(Cancel As Integer) if isnull(me.txtDate) = True then msgbox "Please enter a...
  19. rushitshah

    To verify data while entering into the DB from Forms

    Thanks Ginger and Trev, Trev.. I tried as per your suggestions..but still the same probs..will repeat those again and see what happens.. Ginger..I am using unbound form, that is not bounded with any table.. I have primary keys in my tables..As I have 3 tables. Table1, Table2 and Table3. Table1...
  20. rushitshah

    To verify data while entering into the DB from Forms

    Hey Trev...Thanks a lot man...It worked when I tested it!!! Actually I am also giving meaningful names to the objects on the form, but still in the code window it shows only the name of the objects what access gives by default. Like when I add textbox from the tools menu, access gives it a...

Part and Inventory Search

Back
Top