Search results

  1. Parker

    Need a little advice

    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...
  2. Parker

    Linked Tables Manually Changing.

    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...
  3. Parker

    importing dynamic data from Excel Spreadsheet

    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...
  4. Parker

    General Advice

    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...
  5. Parker

    Shrink My Package to a Smaller Size

    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
  6. Parker

    Linked Tables Manually Changing.

    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.
  7. Parker

    Text box and tables

    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...
  8. Parker

    Linked Tables Manually Changing.

    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...
  9. Parker

    Linked Tables Manually Changing.

    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?
  10. Parker

    MSAccess.exe has generated errors

    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...
  11. Parker

    Text box and tables

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

    importing dynamic data from Excel Spreadsheet

    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...
  13. Parker

    From Form to HTML

    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...
  14. Parker

    auto number starting from 1 million

    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
  15. Parker

    importing dynamic data from Excel Spreadsheet

    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...
  16. Parker

    importing dynamic data from Excel Spreadsheet

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

    Query Code

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

    Tournament Database

    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...
  19. Parker

    importing dynamic data from Excel Spreadsheet

    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...
  20. Parker

    mdb file size

    Compact and repair the db and the ghosties should disapear :)
Back
Top Bottom