Search results

In a similar manner if I want to store a number in text format like"123 345". What should I do?

That's a good solution. Thanks. GOD BLESS YOU!!!!!!!!!!!!!!

My God!!! Its tedious to do this for all the reports. Once it is stored in the table in capital all reports connected to it should automatically print capital. Why isn't it so?

In the attached db I have typed "alabama" in PLACE field. It shows capital. But when I click PRINT ENVELOPE it prints in lower case.

I want a text field to store the text in capital. In Format property I typed">" both on the form as well as the table. It displays capital on the form, it is storing in capital in the table but in reports it displays in the form that is typed. What to do?

Can I make Access produce auto numbers of the following type: I-17088 I-17089 I-17090 I-17091 I-17092 I-17093 I-17095 I-17096 I-17097 I-17098 I-17099 The prefix is I- and the number should have 5 digits.

I agree to your point. But it is not always possible to change the structure of the database. Hence we have to take this side path.

Thanks a lot! GOD BLESS YOU!!!!!!!!!

I will elaborate my problem: In my text field I type:"Feast on 08-08-19" Now, I want to check whether the date that is typed in the message is in Date format.

How to check whether a Text field contents contain a date?

I tried it but still traces of the sub-report remain which unnecessarily occupy space.

My report has several sub-reports. I f any sub-report has no data then I want it to be invisible. How to achieve this?

Thanks! GOD BLESS YOU!!!!!

We have a n/w of 3 comps. Access db is installed on 1 comp and all access it. When I access the db when another user is already accessing it, I get a message "You do not have exclusive access to the database this time. If you proceed to make changes, you may not be able to save them later." How...

We have a N/w of 3 computers. The Access prog is on one computer and is accessed by the other 2 computers. The Appl. runs well on the comp. on which it is installed. But it is slow on the computer accessing it. What can be done for this?

Thanks a lot! GOD BLESS YOU!!!!!!!!!!

In my code I have the following line, temp = temp & rst("REMARKS") & " " & amt & "; " REMARKS may contain name in any form such as KUNDAN or kundan etc. Whatever be the case, I want temp to store the name in proper case - Kundan. Howto do it?

In the attached DB the CR NO is the receipt no. If the same person comes again instead of typing his details they can be got from the record. This is the purpose of the subform. Now, when in a new record we type the LNAME it shows the corresponding records in the subform and when we doble click...