Search results for query: *

thanks for your help much appreciated

Hi All I want to use the following code to import a spreadsheet DoCmd.TransferSpreadsheet acImport, 8, "Yourtablename", "filepath of spreadsheet", True, "Sheet2!A1:E273" Is it possible to change the "your table name" to pop up a dialog box to locate the file?? your help is much...

Hi Skip I m using Excel, not sure how to use this statement... Is this not a pop up box? I m looking for excel to look at the date in a cell with =NOW() in it and autopopulate another cell with the last date of the previous full month, so in terms of todays date it would enter 31/10/2009 in...

Hi All Last question i promise, can anyone tell me how i can enter the last date of the last full month dependant on todays date. ie using NOW() function, enters the last day of the last full month Ali

Hi All Managed to get it working using xlbo method thanks all for all your help Ali

Not sure what you re asking, basically it checks the start date of a contract to find which month the contract starts, then sums the number of sales achieved since that start date year to date, which will be every month to the right in the table The date ranges in cells for the sales month...

Hi All I am having an issue with maximum number of IF statements which i can use, i have the below formula which effectively checks if a date enterred by user in cell C9 falls in a month (the month is active and changes dependent on a year enterred), i am using two cells to identify the month...

THanks combo much appreciated

Hi All I am trying to automate the building of a date in multiple cells based on the a year enterred into cell C3, using the following formula ="01/04"&"/"&C3 this will return 01/04/2009 if C3 has 2009 enterred. this works fine, but my only problem is, i am then usign a formula to check if a...

THankyou that sorted my problem

Hi All I have recently installed a database on a new pc, and the combo boxes are now not showing the contents, worked fine on previous PC.... the lists look exactly as they should other than the values do not show and neither does it filter the subform anymore Has any one had similar...

THanks Geoff spot on!

Hi All I have an access database which i am exporting data to excel from, within excel this data is on one tab and a front sheet uses formulas to display in suitable format the data which has been export. my problem is that when i open the export has carried out successfully, but the front...

Hi Skip Users are pasting data of between 1000 and 5000 lines into a template spreadsheet, once pasted i need the command button to ensure each of the 5000lines has the formula in column X, alot of the users are nt excel savvy so trying to simplify the process with just 2 actions paste and...

Hi All I have a spreadsheet with list of contacts, i m looking to make it easier for clients to update spreadsheet, so after they paste contacts in i would like to add a command button that when pressed will add a formula in cell if the adjacent cell has a value, going down the spreadsheet until...

Hi All I have a spreadsheet with list of contacts, i m looking to make it easier for clients to update spreadsheet, so after they paste contacts in i would like to add a command button that when pressed will add a formula in cell if the adjacent cell has a value, going down the spreadsheet until...

Thankyou thats perfect One other questions, is it possible to automatically enter a formula in a cell if a value is present? i am trying to automate the process to prevent user mistakes, so in column AA, if value present in column Z, then paste formula, if no value then stop

Hi All I am looking to automate a process using a button press macro in excel, upon pressing the button it will clear all data in specified cell range (B2 to E2500), can anyone help me with the coding to place on the command button? Thanks Ali

Hi I m getting the following error in the soldto query: "the specified field 'ID' could refer to more than one table listed in the FROM clause of your SQL statement" Is this because i have a field in my table called "ID"?? Ali

Hi sorry i m struggling with this one, i tried simplify when explaining, but the sql is little more complex so i m struggling to figure where to place this. my SQL is SELECT DISTINCT Customer.[Name 1], CustomerDetails.ContactNote, CustomerDetails.PotentialOverall, CustomerDetails.CustomerType...