Search results for query: *

Ok, I have a table which has a field populated from a lookup in order to limit to list so only staff on the list can be added in. Im trying to create a simple query which totals up sales from each member of staff by region, and adds in their id code which is not in the original table. Every...

Apologies Im slowly getting back into using access again and finding Im struggling even with basics and everything is a bit different in this version of access. I have a report, it looks at a text box on a menu form to get its critera of a site number and generates the report for that site...

We have a list in excel (2007)which has photos inserted into it. I need to print the list including the photos but when i print the images are not lined up with the cell they appear to be in in "normal" view. I have tried setting properties to move and size with cells but that makes no...

I have 2 worksheets. for the sake of simplicity called A and B. I wish to check the contents of cell C8 on A with C36 on B, if they match (text) I want to then check if B6 on A and D17 on B and see if they are equal, if yes then see if cell D36 on B is a "y" if all that is correct I then want...

Im sure there must be a way to do this but cant think what it is. I need to be able to get the user to enter a invoice number, I then want the number to be stored against all records that have a yes in the "sold" field and nothing (blank) in the "invoice date" field. Any help hugely appriciated !

I have 80 rows in a worksheet, I want to be able to click a specific cell in each row and for that to go to a specific worksheet. very grateful for any idea on how to do this thanks in hope

I have some code very kindly given to me in thread 705-1142361 It has been working perfectly up to now but following some changes to the import files and therefore to the table that they import into now come up with an error message "Failed to Import File " (as you would expect) code- Function...

Im hoping someone can help with this one, i have a field in a table that contains a 6 digit number followed by a description, i want to split this into 2 fields, the number and the description seperated ? any help gratefully received :)

I have a list of numbers in excel all are to 1 decimal place. i need to round them all to the nearest .9 ? Please if anyone can help with something simple that would be fantastic.

Ok, I need to make a query to group numbers so i can see how many i have in a given band. I need to be able to round the numbers i have in my table to the nearest .9 in order for this to work properly but cant work out how to do that ? e.g i have numbers 11.1, 11.8, 10.7 and i want to be able...

I think this should be possible (?) just not sure how to do it, I have a report with 2 years with of figures for each client so i have a label for each month then the associated text box containing the data - what i want to do is turn the font colour of the label to white if the text box has no...

apologies i know this is probably really simple but i cannot get my brain to function at all today !! I have a query with 2 fields (yep a whole 2) name Date all i want is to convert that to name and the month from the date (currently in dd/mm/yyyy format please can anyone advise ??? huge thanks...

I have some code that was v helpfully given (thread705-1142361) to import excel files into a database for me (see below) which ran perfectly last quarter, however now i am getting an error as someone has changed the format of their file before sending it to me so it wont import. as i have 600...

Helps please...... :) Im trying to copy and paste data from one worksheet "checklist" to another worksheet "action points" i want the macro to look through all the rows 22 to 144 to see if the data in col D is "no" if so copy col A and H of that row to the action points sheet to next available...

i have written a very basic macro and called it finduser i have attached it to a button but when i click the button i get an error message telling me it cant be found becasue it doesnt exist or is new and hasnt been saved yet. i have been in and out of the database & saved it but i still get the...

I have an excel spreadsheet on which worksheet 2 looks up values in worksheet 1 -worksheet 1 has a specific layout not very friendly that must stay the same worksheet 2 is just the info going accross the sheet to be easy for access to import. i am then trying to import via file - get external...

We have a site checklist for all our premises which are done quarterly and i want to import into access to compare and produce mi from they are stored on a shared drive and titled by their premises id number, in a folder set called "current Qtr", i want to be able to just press a button and...

I have an email address set up for requests for a job application form so i want to be able to set up an automatic reply to all emails to that address that has a breif thank you for the enquiry and an attached file that is the standard application form Anyone know how i can do this pleae ...

I have a report that is a letter and the customer has 3 months to reply to the letter from the date of the letter so i want to have a text boxt on the report that shows the month (only the month not the date) in 3 months time ? Any help most gratefully received !! :)

I have code set up that establishes the username and decides if that user is allowed to go into the database, it works via the event of the switchboard form opening. i want to email the username of people that are refused entry to someone so they can keep tabs on attempts at unauthorised entry...