Search results

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.

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?

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.

ignore posted twice

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.

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.

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

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

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.

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

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

* already answered

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

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

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

Does it work if you create a shortcut on his desktop without using the script?

This is the basics, I dont have time to explain everything at the moment but: In basic terms you need to base a query on the data that you type in form. The form will include 3 unbound text boxes for you to type in and one button that will run the query. To get the data from the form to the...

When referencing field names that have spaces just put the brackets round it: [Field name has spaces] that was Access know where the field name starts and ends and will not treat spaces as new lines of code to execute etc.

I may have miss understood you but I assume you have the teachers names in tblTeachers, if so add that table to the query (the query you base your report on for the report) and join by TeacherID to Teacher1ID, then add that table again and join by TeacherID and Teacher2ID and so on.

OK here is the base DB. It is not pretty due to time and I have not done everything you need but there is enough for you to be able develop it into your own project as most of the theory is there. The DB includes a form for dispensing, a startup form and a report of all dispensed by week and...