Search results

I think you're right. This would be a good route to go down. You could rationalise a complicated form by putting some stuff on "tab controlls" this will tidy it up a bit. But, as you imply, the next bit is, potentially dangerous. Do you have any way of creating an Audit trail on exsisting...

I came up with a similar idea while looking at the back of an artic lorry on the M25 Create a table to store all the info and use a delete routine to get rid of an old link. Then use the delete routine to fire a series of text boxes demanding info for the new link Include an error routine that...

Sorry it took so long to answer you but I had to go and do other things Good: The old grey matter is starting to work. Not that I know of ------ be your own tutor, Pull it apart, change things, study the code behind forms and controls etc. You can’t do any damage if you mess it up just...

One thing that may make your job easier is to get hold of a copy of a proprietery software auditing package. These are available for networks as well as single machines and at least then you will have an acurate list of what is on each machine, it's, proclaimed, licence Number, number of coppies...

It's a good job english is the base language on this forum in other languages this may get more than a laugh. One way to get attention though :D

Hmm every problem has a solution. Unfortunatly this one evades me at the moment maybe someone else can help that is more up to speed on this sort of stuff I will think on it but I have to go out on call now so it will be a while.

OK simple way Use a list box and use the "Row source" property to build the query you need. or Use the query builder to get the imformation you want and use the result of that query as the record source of your text box Both have pro's and con's and If you study the Northwind db example...

Hmm .... I had a nasty feeling you where going to say that. I don't know of an easy way of doing this but someone else may. However, Have you looked at other posible solutions? Dose you "Dev" enviroment table structure match the live one. i.e. do you have the same table and folder structure...

I may be mis understanding the question but do you mean to pick between two different db's as a record source or do you mean something else?

Hate to over simplify and state what may be the obvious but have you tried removing this item and any reference to it? Also what OS? If it is FE-BE is the data stored on a machine with a different OS than the FE? As well as checking the integrity of the data have you checked the integrity of...

Run a select query behind the text control in question. See above

You're welcome File> Get External Data> Link Tables But think, in depth, about what your Access table structure needs to look like and what it needs to achieve before you overwork your rodent(oops sorry.... "Dictionary of fuzzy logic" --- "wear out your mouse by rapidly and randomly clicking...

Why would you wan't too change someones elses web page for your own use? If you are giving someone else info over the web they will provide a means for you to do this. And if you are using someone elses info from the web then you should have their permission and in that case they will, again...

If you do a search there are loads of examples/answers to this question ..... look at re numbering autonumber fields and then start your autonumber wherever you like

Ok 3 things hit me straight away (I don't know if others have downloaded your db or not) You need to re read the posts that have already been given too you If you are using Excel to download data then link those tables in Access DO NOT recreate the tables all you will achieve by doing this is...

Can't view these as the site says I don't have permission. Post your db here and I'll take alook later

SELECT [MyFunction].MyFunction FROM [Table1]; I think

Seems doable to me. You appear to have already overcome the first hurdle.... analysing the whole problem in order to break it down into smaller problems. Take the quote above. You could make the last three Tables that way you could pick from the tables and design your tournament in a form...

As Bob has already stated, I think you need to re-think your process. 1'st question why is this necessary? You don't need to be doing this. Access is more than capable of sorting this out for you. And, anyway what is the point of creating separate component sheets only to combine them again...

Compact and repair the db and the ghosties should disapear :)