Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Steve1001

    How to open database in design view when hidden

    try Window> Tile vertically
  2. Steve1001

    How to open database in design view when hidden

    Try Window > Tile vertically
  3. Steve1001

    Multi user XL sheet

    Geoff Thanks for the help I have made it a shared workbook, but the problem of saving was occuring if only one person had the workbook open, and they had previously been able to save changes Steve
  4. Steve1001

    Multi user XL sheet

    Geoff The users all have full permissions, and can normally save their changes. The workbook was created as a single user not shared Steve
  5. Steve1001

    Get Value From Table

    Simon Thanks, I know that would work, but the tarrif table if many column and rows and would take a lot of work to re format...or is there a way Access can do this??? Stephen
  6. Steve1001

    Multi user XL sheet

    Hi I have an xl spreadsheet that is accessed and updated by many users. The problem is that occasionaly, it will not allow changes to be saved. It will allow the sheet to be saved with a new name and will continue again for a few weeks till the problem occurs again. Does any one know why...
  7. Steve1001

    Get Value From Table

    Hi I have a table of carrier tarrifs Wt. A B C 0.5 £12.50 £15.00 £14.00 1.0 £15.00 £18.50 £16.50 1.5 £16.00 £19.85 £17.90 2.0 £17.00 £21.20 £19.30 2.5 £18.00 £22.55 £20.70 3.0 £19.00 £23.90 £21.90 3.5 £20.00 £25.25 £23.10 4.0 £21.00 £26.60 £24.30 etc wt being the weight, and A B C etc the...
  8. Steve1001

    Query from table

    Hi I have a table of tarrifs, the vertical column is weights, the horizontal delivery areas a b c d 1 1.0 2.0 2.5 3.0 2 1.5 2.5 3.0 4.0 etc. is it possible to make a query that will select the value based on weight, and delivery area ? Many thanks Steve
  9. Steve1001

    shrink sub form

    Hi I have a sub form with properties set to Continuous, can grow = yes can shrink = no, none of the feilds have borders. Th eproblem is it won't shrink!! Can any body please help Thanks Stephen
  10. Steve1001

    Shrink Sub form

    Hi I have a sub form with properties set to Continuous, and Can grow and can shrinlk set to yes. The problem is it won't grow!!. Can any body please help Thanks Stephen
  11. Steve1001

    Image Problems

    Hi I have a report that has a picture linked to a remote drive. The appropriate picture is displayed linked to the item number on the form. This is fine if the correct picture exists, but if not, I just get an error message saying that the file can't be found. The code is very simple...
  12. Steve1001

    SELECT QUERY

    Hi I have a table with sample number, which is alpha numeric and can be 4 or more charactures long. How can I make a query that will select on say 3 or more of these ? Many thanks Steve
  13. Steve1001

    On Error

    Hi All I have a an access db that runs every 60 mins and collects data from other non access db's,(the tabels from this db are linked to other Acess db's)The PC that runs this is in another part of the building, and when the task is complete sends an e-mail confirming this. About once every 3...
  14. Steve1001

    Date Ref in IF statement

    Hi I am trying to add a date reference in an If statement so that if the current date is greater than the date set of a form the code will run, can any body help please Thanks Steve
  15. Steve1001

    Date Referance

    Hi I want a code to run when the current date passes the date set in a table, I am using the code below If "date() " > "table.[sample.check]" Then DoCmd.Quit End If where sample.check is the tabel and field with date, what hve i done wrong?? Many...
  16. Steve1001

    Message Boxes

    Thank I think that answers my questions Steve
  17. Steve1001

    Message Boxes

    Hi All When using the message boxes in Access, is it possible to disable the "Access" caption on the top of the box? If not is it possible to create a pop up form that is always the same size (ie it would not appear maximized and fill the whole screen) Many thanks Steve

Part and Inventory Search

Back
Top