Recent content by spoole

  1. S

    Question import from excel to create Database

    You will find it very hard to import that excel sheet into access as the layout does not lend itself to importing. You may have more success with the base data that produces the report and from there you can do what you are asking.
  2. S

    Automated Export Excel 2010 worksheet to Access 2010 Table

    If it's the same excel file each time, create a "Named range" in Excel and then link to that named range in access, then just use a query to pull that info?
  3. S

    Sales this month or year verses last years month or year

    Base your report on a query. The query needs to include two tables, the 2011 data and the other table is the 2010 data. In the query just create a join by month, supplier and customer.
  4. S

    Sales this month or year verses last years month or year

    ignore posted twice
  5. S

    Unwanted record update when I change view

    Changing the view is not saving the record. The record is saved in real time as you type. Look into "form validation" to prevent users from typing mistakes or entering incorrect data.
  6. S

    How to make my db ready for the users

    Look into splitting databases (take a copy before you attempt this) then forms should be your users only access to data in your database, so look at "locking down forms" Tools/startup/display forms page is where you say which form you want to open on start.
  7. S

    Access Front/Back End? advise needed.

    Yep, although with a little knowledge a user could get round that ;)
  8. S

    Disable a button after macro runs

    I don't think you can hide a button using a macro unless its with the "Set Value" function?. But there are two ways I know of. The lazy way is if the last action on your macro for example fills in data into a text box on the form then use that text box "After update" event to hide the button...
  9. S

    Read Only

    Do you have rights to location you moved it to? I know its your machine but Windows XP Pro for instance in a network deployment by default wont let you save stuff to the root of C, and does some funny things with security at times.
  10. S

    Access Front/Back End? advise needed.

    Splitting a DB does not always make it more secure, it simply seperates the DB into tables (back end) and forms (front end) To secure your database, as you have said, will be preventing users from altering data in the tables. All data that users see should be in a form or a report. A form...
  11. S

    Form level validation

    I handle multiple validations in a different way (not to say that its the correct way) I create a button and in the on click event place code like below, which checks that required fields are not null and a lookup that checks to see if the "Employee Number" already exists and then provides a...
  12. S

    Form level validation

    * already answered
  13. S

    Subform show only relevant records (selection from list)

    Ok I think I see. You need to base a query on what is selected in the list and display the results on a subform? If so firstly create a query with all the info you need from each table and set up the relationships. Then use this as an example to use the value in your selected list box as a...
  14. S

    Subform show only relevant records (selection from list)

    Im not sure, but cant you get round this by setting up a relationship between them using the relationship manager?
  15. S

    Automatically moving records to another table

    From the info you have given so far: What about having just 2 tables, where table 1 is the same as your current business enquiries table but also has a column added called status which records the number 1, 2 or 3. the second table contains the description for the status numbers ie. 1 = In...
Top Bottom