Recent content by TracieLee

Oh.....so simple......I have just added the name and address as a subreport and it works perfectly!!!

I am self taught:o, so there is probably something very simple that I am overlooking, but here is the problem. I have a report that is used for mailing sorted by postcodes. I have (by code) managed to assign a sequence and page number to each record and used the sorting and grouping levels...

Wierd huh? I had already unset and reset the trusted locations and it didn't make any difference. Oh....well I suppose I can stop being lazy and just code it anyway!!

Thanks Bob, but yes, I have all the Trust Centre settings as you suggest. The weird thing is that all the other databases are fine, it is just this one. I am at a loss as to what setting I have on this one that is different!!

I am in Macro Design and ordinarily I can select the "Show All Actions" button in order to have an expanded list of actions to choose from (of which SetWarnings is one). There are four buttons on the show/Hide section of the ribbon. Arguments, Conditions, Macro Names and Show All Actions. The...

I am trying to turn warning off and back on again before and after a macro action. The Show all Actions button is greyed out. :( I have been able to see this in other databases I have been working on, and can't work out wha tis different with this one. any help would be much appreciated!!

If I am importing every client's information into a master table, do I need to clear out the table each time I have finished with it? Each client has changes to their data every month?

Galaxiom, forgive my ignorance, are you talking about the translation info being part of the initial import? I know I need to get the initial data into a standard format, but it may be beyond me to achieve it. It would be nice to be able to select which fields to import and rename to our...

Banana, Each of the client files are set up differently. Most have some of the same fields, but the naming conventions are different. My Application needs to take all of the data from an individual file, and be able to manipulate it depending on the state of each individual file. Each client...

Thanks for that. As you have correctly identified, I have not yet made a start on it yet, just wanted to make sure I was heading in the right direction when I do. I am sure I will be in touch once I start and need help with the next hurdle!!! Thanks so much for your time. Cheers!!

I was afraid that was the solution. It is not really an option to combine the databases into one, so I was trying to find a quick fix. Can I develop a front end to select a table and have that selection passed as a parameter into a generic query? How do I use the AfterUpdate in a combobox to...

Need to know the best design for this sort of thing..... I have Multiple client Databases which all have similar tables containing names and addresses. I need to have one central database that can link to each and write queries that will run against each database individually. Is the best way...