Replies

Actual training courses are more suited to the general development of VisualBasic as a language, and they are everywhere!!!

Knowledge pertaining to Access in general can be found in most books. Many have CDs with them that have exercises and sample tables, as well as a wealth of information.

A particular favorite is Access 97 Macro and VBA Handbook-along with the accompanying book Access Development for Applications.
Published by Sybex
ISBN# 0-7821-1977-8
‘Hint-Most are available at discount bookstores and still have the CDs.

Edited by jazman2001 on 01/02/20 05:13.

I need to write a module that creates 38 records for each group listed in the CompanyID field. The qry_distinct does the job isolating the groups.

Each group should have 38 records. There are 652 groups.

I’m trying to get the last number in that group from the value of Field3 [RowID] and increase the number value by 1. It’s a Double as a datatype.

Example: in attached spreadsheet CompanyID AFFI has four records, so the count should start at 5.00 and proceed to 38.00

‘Thanks for any help given…

Rory’s right. A UserForm can be customized much more than a standard messagebox. See my post “Here’s a fun one”…You’re busted!!

Many helpful suggestions were given as to how to ‘instruct and educate’ my Excel users.

Edited by jazman2001 on 01/02/19 22:31.

The original post and attachment were so bad that I had to replace it with a second one. The attachment on that post contains actual data.
Please see the third post in the thread.

It was purely academic.
I naturally backed up the table before hand.
Besides, it was an easy table to recreate.

I was just wondering, had I used a delete query instead, how would one, if one could, get back their records.
NOT…appears to be the answer.
Thanks

Where does this code go?
How is it activated?

As an addendum…How does one inhibit the ability to cut i.e.(ctl+x) data out of cells?
Everytime they do this, it ruins the link down the line.
I’m assuming that this is really easy and something I just missed on the way.

Yeah, but I wanted to ‘bust them’!!
A nice message box would’ve been alot of fun.

Very cool,
Thanks alot Rory
I need to learn this range stuff more.
While I’m here.. would this same type of system work for a type of validation function?
For instance an If statement?
Can you use IF statements in Excel?

I guess I better read those VBATUTOR files I downloaded…;-)
Thanks again.

How is that applied in Excel?
I saw in the insert menu Insert-Vlookup.

I don’t have ODBC or MS Query capabilities here, are those required to do lookups?

I’ll read up on it at that site you suggested…

Very helpful indeed and just what I’ve been needing for the past 6 months.

One would think, had I applied some logic and just guessed at the URL I would’ve stumbled on it by now.
Thanks a bunch, Rory

Yeah!!
That worked like a charm.
I really have to learn more SQL, it’s so easy to read.
I usually use it to alter the source but rarely code straight to it. Excellent!
A little sorting in the report section and the results were spectacular.
Thanks for all your help KB

Fortunately, The U.S. does have some type of disciplined zip code system. It’s either a 5 digit or a nine with the last four separated by a dash. i.e. 12345-6789

Just start at the end of the string and go back to the first space. Delimit. That would be the easiest way probably. As long as its a non-numeral or a space.

Fortunately, here we don’t use hyphens in our city names. The postal service hates punctuation in the last line…it throws off the scanners.

I love that there is more than one way to skin a file.
Thanks Rupert

I would prefer that fields be restricted, naturally. Unfortunately, I inherited this as a Word list that was
entered from a hand written list, and the data entry people knew nothing about fields or which data should go where.

So now I am forced to search inside the strings for the appropriate value and group from the newly created fields built in the query.

What I really need are examples of expressions used in reports for customized grouping.
The Access help section isn’t very helpful on this one.
I imagine that it’s an INSTR call, and I believe that your call on searching backwards thru the fields would be the correct one.
Thanks for the assistance.

WOW…impressive code!

I am having difficulties calling the function, however.

As I understand it, A new query was created but is the function called from the query? If so, how is that done?
As an expression, right?

using this code in the query created an error.
District:= Cust_Instr(“District”, Table1!Ad1, Table1!Ad2,
Table1!Ad3)

If my fields are all called (Ad 1-5), would the corresponding code in the function be the same?
Thanks for the promp reply.

Sorry, they are standard textboxes in a UserForm.

It was a standard Word97 template with macros available on the office intranet with 5 text boxes on top,
5 to the left and five to the right…imagine the outlay of a business card.

I have moved the input to a series of UserForms and want to simply export the data and those tags on the forms to a delimited text file.

Using the radio buttons activates the appropriate UserForm with the appropriate number of text boxes.

Problem is those text boxes have styles attached to them.
i.e.