Search results

Still new,but its working. What is the best way, when running some 45 queries where in when new tables are pasted, together with a linked SubDatasheet, I then want to pause the macro to do some editing, and then return to the macro when I close that table. The only apparent way is to split the...

Tks for input, Travis, but I'm not sure where to place the Forms reference in the queries, such that it would replace the task of right-clicking the mouse, click properties, and changing path details e.g c:/unzipped/ab##01-09-01.mdb.

Tks any way, I just solved the last problem as well by running two queries for Ms and Mr, after running an append of new firstnames in the macro. Tks all, I'm virtually there with 40 action queries in the one macro....phew

Tks Pat, actually my queries are in sort order already, e.g. ACT01, 02,etc. and it appears that the Main window can't be cleared, just copied by shortcuts to Groups.

Tks, but at this stage I still don't know how to plug in a Module and want to master as much from within Access 1st before looking at VB Code. 1. The queries still show up in main window even after added to Group1. Spose that doesn't really matter, just makes window_Grp1 clearer to work from...

I'm running a macro which transfers 5 Access tables weekly into one new table. The import file name changes every week, so can I create a prompt "Amend Import File Name!", such that I do not have to keep amending 5 Append Queries before I start the macro? The file name has a pattern, e.g...

First, there are many postings on this under UserName Randomblink, in GENERAL. Second, if some records do not append, you need to discover why. Most common reason is that your TO table has a Dbase definition item ALLOW ZERO LENGTH. This is set at a default of NO. Change it to YES. Also make...

In one related table, SECTION, I have an IT toggle yes/no according to the text descript. New records add weekly in here & new IT=yes's are manually made (not enough yet to make a macro). In my table,MAIN, there's another IT=yes determined by several criteria, one of which is SECTION. Where in...

Tks greatly, I'm adding a brief descript & that's helping, but I'm up round 100 queries and want to move them into groups. The Group option must be in my Access 2000 only. Tks I'll take a look at that properties a bit further.

There's a Favourites function down on the left there which it would appear I can use to group my queries, but when I dragged and dropped ... they are still sitting there in the main screen, and appear to be copies only (in the group) This is probably a dumb question, but I'm up to my eyeballs in...

Thanks Pat, I will look at that option too, it's only that the data to import comes from another Access db.

This type of calculation might better be set up in Excell. I'm no expert but it is one option.

This is a common problem when one of your table names or field names are not recognised (i.e. most likely a typing error). Check all very carefully again, and the pop-up box will have as its subject the information piece not recognised.

Thanks Pat, discovered that but always thought that Iif returned 2 options both true condition and false condition. In the process, found Copy & Pasting from a SELECT helped establish the result in the existing table in a new field, without needing to constantly make new tables, change...

Many ways to do this, depending on yr data layout & exceptions. Try Original Entry in [Names]: = "John Doe" Returned by Expression: Doe Expression:Expr: Right(Trim([Names]),Len(Trim([Names]))-InStr(1, _ [Names]," ")) OR TRY Original Entry in [Names]: "Doe, John" Returned by Expression: Doe...

Do you want to paste all records and fields from table A to table B? If so just use Append Qry, display only table you wish to append from, enter new table name (B) at the prompt.

More lateral play just solved this problem, but it appears the Iif function doesn't do what its supposed to. Instead, I created a new field, MAILTITLE, then used UPDATE set as DisplayTitle=No, used " " as the update and got the result. Then used copy and paste from select query to add the titles...

Thanks all for your input, but the problem is that the Iif is supposed to show me the blanks as well, but it's not! It is placed in the Criteria line, but is yielding only 91 records (DisplayTitle=yes)when it is supposed to show all 152 records incl. the blank title field. In other words, as...

Further thoughts on this, perhaps creating a calculated new field to work with the Iif will be the better way to go??

I have two types of titles, some yield a rank and others "May be Displayed". My related table Poscode has DisplayTitle, yes/no. I want to be able to set the criteria such that : IIf([Poscode]![DisplayTitle]=Yes,[Poscode]![Title],[Poscode]![Title]=" " but this function always runs only...