Search results

Okay, it's definitely is working, after I figured out how to Insert Procedure Public Function. Thanks, great! It did one other funny thing though...it turned the tab option to 'NS' on one of the other fields from the table containing to Fld1. Ideleted that option and all's working.

My form is derived from several tables, some without RI as records being added are often creating new primary fields for the related tables, so I turned off RI, established two SubForms, so that the new entries can add in easily. The related tables are operating basically as Lookups Only whilst...

Create an update query for each statename you wish to shorten, and then run each query through a macro called say ShortState.

Thanks Pat. Not too complex at all!

Newcomer to VB thanks to the Forum. What Sub routine would I use to achieve the following (in my lay language): In my Form, Fld 1 may be blank, Fld 2 may be blank and Fld 3 may be blank, but each or all may contain data. However; I want Fld 4 (a 'global category') to update in the following...

I have a crosstab query based on a query. I click the show totals button on the wizard. It comes up with "You tried to execute a query that does not include the specified expression 'Surname' as part of an aggregate function. The query shows titles by state, where the count is no of surnames...

Just a minor problem. If I drop in new code in line under Propercase expression, I am getting error message. I have tried putting it in new Private Sub .... End Sub and still getting errors In your Me![FieldName].Tag = Me![FieldName].Value Is Me 'My Dbase name' or 'My Form Name' and also...

Thanks greatly guys. Jack, presume I drop this new code in a line after my Propercase conversion line, in cases where I already have an [Event Procedure] running for the chosen field? Sorry, very new (and frightened by) VB, but its working well where applied. Am reading the article but have not...

In my database there are many instances where I need to carry forward the previously entered text for selected fields, so that data entry person need only tab through to enter data in selected new fields. e.g. Field DeptCode may remain the same for 80 recs, whilst many other fields change; yet...

1. Okay...........First time I've dropped code in vb that's worked!!! But it appears it only works on the newly added record, which was my test piece. Perhaps, very importantly, this thread reveals how significant it is to establish the extent of the enquirer's knowledge of any VB script !!! I...

Re the above, I have tried dropping into expressionbuilder, and am getting the erroe message: "The object doesn't contain the Automation object VbProperCase". So I'm getting closer..........tks....help!

Steve, okay...thanks greatly yr additional patience as I try to understand some of this coding. (Oh I found the RIGHT helpfile in the VBHelp, but I was not to know that). 1) Now in the Properties box named AfterUpdate do I click ... then go to axpression builder and drop ...

Sorry to jump to conclusions based on my limited knowledge. I have not touched vb code and get easily confused. First, I am sorry, I do not understand whether "yourstring" means type the fieldname or what. I typed StrConv("YourString", 3) in a vb expression line and replaced "YourString" with...

Tks Jack, but still not working. Oh this used to work for years so easily in Lotus Approach Forms !!! 1) UCASE turns all text in field to upper, yes? I just want to convert text after entry "mr" to "Mr" and "prof" to "Prof" or "capt" to "Capt" or "wgcdr" to "Wgcdr", so if I have to say a number...

OK, I found how Combo box can show choices from related table. I turned RI off, but still get message Cannot enter data in blank field of an outer joined table. There must be a simple option to allow this to happen....anyone know where it is? Thanks in advance...

A couple of simple questions for a newby in Access Forms being designed for manual data input: 1.Where do I set in Properties for Titlecase, or uppercase (> ) and what is the Titlecase command? 2.Form is based on multi-table query. With RI intact in the related table (Instance type OR (in...

When you import the wizard allows you to enable an automatic primary key or choose your own. If you've macroed the process, I believe you should open the table in design, right click the field you want to be the primary key, and then click primary key.

Thanks, its basically working quite well now with macro by stages and a master Form of command buttons, each reminding me what I have to do when one of many tables opens. What I was after is: With a table open, and editing done is there any way to set an event, "On closing table, return to...

Thanks, from me too. This will help me with some of my postings too.

Why, when switching on totals if some records are blank and criteria is set “is not null”, a null record is included in the unique set?