Search results

I will try I will do some reading. This database is starting to get large it is over 19,000 records now. It is also starting to slow up. Also our business it projected to double in the next year. I was not the creator of the database. But I would like to make it better. I am learning a lot on...

I will try I will do some reading. This database is starting to get large it is over 19,000 records now. It is also starting to slow up. Also our business it projected to double in the next year. I was not the creator of the database. But I would like to make it better. I am learning a lot on...

oops Sorry this was supposed to be a relpy to a previous post.... kim

I will do some reading. This database is starting to get large it is over 19,000 records now. It is also starting to slow up. Also our business it projected to double in the next year. I was not the creator of the database. But I would like to make it better. I am learning a lot on this...

This database is medical files.. and we need the age so.. if I have an entry in 1999 and the member is 33 at that time and we duplicate the record for 2001 the age will change to 36. I have the age autocalculate based on the input date. I changed the inpt mask to read a full year ex 2002 and...

Actually, I did need the input mask.. I had to change it from 00/00/00;0;_ to 00/00/0000;0;_ for it to work properly. Thanks again DES for your time and patientance. Kim

DES, I found it. I also had inpt masks on my form when I removed them it worked properly. Thank you very much for you help Kim

I did have a inpt mask on the birthdate.. and changed it to a short date. So please disregard my last post. But this did not help, I still get the error. Any other ideas?

I think I am confused ...If I take out the inpt mask, then how do I insure that everyone inputs the date the same?

I am a beginner.. I have a form that I have added a button to duplicated the record. When I use it the following error appears, "The value you entered isn't appropriate for the inpt mask '99/99/00;0;_' specified for this field." I have 3 date fields in the record, entry date (auto), birthdate...

I am a beginner... I want to make a form that a user may select critera to pull a query. (I do not want the users to be able to enter the tables directly or do queries because we have lost data in the past this way). I would also like it if I could make the query automatically convert to excel...

There are 6 tabs in the subform.. each tab will have a different total at the bottom. If I put the total at the footer of the subform ,when I switch tabs the total will stay at the bottom

I have a form that is made up of pages (tabs). On each page (tab) there about 20 questions with yes/no checkboxes. On each page (tab) I have a total score. I have used a macro to add the checkmarks (each question has a different value). This has worked very well to this point. Now the...

I found my problem... I had a macro that no longer existed in my form properties. I removed it and now it seems to be functioning properly.. Thank you so much for you help. I have learned a lot from this forum. Have a good one. Kim

I checked the table and it did work properly... had no problems.. I can't seem to pinpoint the problem in the form though?

no... If I go into the database and do not make any changes at all I can enter the design mode. But once I make a change I can no longer enter the design mode

My primary key is an ID number which is set to autonumber.

Hello, I have a simple database that is set up 9 tab sheets. Each sheet contains approx 15 question with yes/no fields. The only macros I am using are to sum the yes/no fields. The problem I have is .. When ever I make a change to a record it will not allow me to go back into design mode...