Search results

Search for UsefulDateFunctions...it is in the Sample Databases at the bottom of page 4 and was created by Pat Hartman and I have found it quite useful though I am not sure in your application it is what you are looking for. But it might give you some ideas.

I know there is a property called "Column Widths" that you can set manually but then this may not be what you are asking for. Column headings I believe take their width from this setting in "Column Widths" As to have them "automatically" adjust according to the size of the text in the list I...

I am certainly no expert but I know that if you go into one of your modules (visual basic) and goto Tools/References and make sure that "ActiveX DataObjects 2.1 Library" box is checked. I don't know how it would get "unchecked" but when I have had this message it did have something to do with...

Though it may sound "simple" what you are basically asking is how to use Access. Try to get a hold of a copy of a basic book of Access and review the Forms section. Also, look at the Sample Database section of this forum. The form you want to create has to have tables, queries, relationships...

Put this in the GotFocus event of your list box: Me.ListBoxName.Requery After adding a new student, I assume you will return focus to the list box. If not, try searching this forum "Refresh List Box" there are tons of threads. Hope this helps!

ghudson: Are you sure you are posting your last reply to the correct thread? man, I am really confused if you are because I don't see the connex! but thanx anyway...I wrote a sub using your code to check for the number of characters that works great!

gHudson: thanks so much your last code did it! I am curious as to why: I declared strMsg = [my Textboxnamehere] so it seems to me your first posted code should have also worked. Oh well, I am grateful to move on from this little adventure with your help! Thanks again:D

Keith: I cannot post as it is a confidential patient grievance log. Is there something specific I could post or detail ? basically, it is a form that has a number of fields. Two fields are comment fields and when the character count of either field goes beyond 1000 the form will not all fit...

ghudson: thanks but still getting "Invalid use of null" error :(

thanks to both of u for such quick reply KeithG: "still getting Invalid use of null" error rboRob: It should be ok if they leave the field blank. I tried the "vbNullString" however same error. thanks again

I am checking to see if a memo field and/or a text field has more than 1000 characters and if so then it calls a function that prints legal size paper vs. 8 X 11. It works fine except when the either field is empty. I have searched and searched the Forum and found many that are close but no...

thanks again for your responses..the last one made it clear for me!

Pat - Your quote: (don’t know how to do this the “forum way” and can’t take the time to find out right now!) “If what you are saying is that among the three applications there are three shared tables and other non-shared tables then they do belong in the same back end database” YES: and I...

I don't think you can "count labels". If you can make the Regions a field and part of your table/query behind the report then you can simply total the [Regions] field. Hopefully I am understanding your question!

I have 4 databases that share 3 tables. Each database is used for different purposes and other tables which do not relate to the other databases. My question is: how do I set up the back ends so each database can retrieve and enter data into the 3 shared tables without conflicts?? I know...

I am designing a form for users to write letters in which they give “reasons” for denying a particular service. It is a State-required form letter and there are 7 “reasons” to deny. The user usually chooses just one “reason” and then types in (free-style) the text for the specific rationale...

I solved the problem by creating a sub report based on the table that contains the memo field and linking it to the id field in the main report. The query for this report is based on many tables and being a "totals" query is most likely the reason the memo field was truncated. Thanks again as...

Thanks for your replies. Rickster: I cannot post my database for condidentiality reasons. RuralGuy: I am looking into the suggestions. The field is included in a totals query and I tried grouping on "First" but no good. I do not sort on it but the post you gave me gave me some other ideas. I...

I have a report based on a query. There is a field "comments" that is a memo type however on the report it does not display all of the text. I have the property "Can Grow" set to "yes" however it still only shows partial text. Any ideas? thanks in advance!

And in case I did not thank you gHudson, when I first found your compact code on this site: THANK YOU! I use this often and it has never failed and like you say, takes the hassel out of having to remember to do it and having to do it "manually"...