Recent content by Bumpthis

Hi I'm very new to coding and was wondering how i could import 1 csv file into my excel workbook but for every different item in the csv file generate a new worksheet for each instance please so for example the csv file contains Header1 Header2 A 10 B 10 C 10 A...

Excellent thanks for your help PHV Thanks for your help on dlookup also Zameer

Thanks zameer, i'd already tried that, i don't think i've been very specific in my problem, basically i want to use dlookup to create a query which takes table 1 data Employee Employee ID A 1 B 2 C 3 Adds table 2 data to it where the rowid is either a 1 & 2 or...

Thanks for your help Zameer The data in the Note field for each employee is just a concatenation of "Test" and the employee ID SELECT Employees.LastName, Employees.EmployeeID, DLookUp("[Note]","Employees2","[RowID]=1") AS Expr3 FROM Employees; LastName EmployeeID Expr3 Employee1 1 Test1...

Sorry but its still returning the same result doing this??

Thanks Zameer It appears to be giving the notes from employee number 1 rowid 1 to all employees? An example of my tables are: Table1 Name EmployeeID A 1 B 2 C 3 D 4 Table2 EmployeeID ROWID NOTES 1 1 Test1 3 1 Test2 4...

Hi I have two tables, one with employee data, [Name], [EmployeeID]. A second with [EmployeeID],[ROWID],[NOTES] I'm trying to return all Notes from the second table into a query with the first table where [ROWID] equals 1 or 2 but laid out in single rows [TABLE1]![Name], [TABLE2]![NOTES] AS...

Hi I have a excel list box which i made from a vba manual, however i have to open this spreadsheet via the internet explorer browser and am getting a debug error of Method 'Range' of object'_Global' failed My code is and its highlighting the the Range line ???? Private Sub cmdOk_Click()...

Hi Very new to vba but i've created a spreadsheet which has several links to hidden sheets in the workbook and a text book vb list box select going on. The problem is when i try and run this spreadsheet from a web page hyperlink it fails to find the hidden sheets. I get the error Run-time...

Hi i have a series of data which needs to be put into a graph, the problem i have is that i do not want the min value (Y) axis scale to be set to 0 or auto and a number i type into the format axis properties, i need it to look at the lowest value in my table and set it to another value...

Skip, the reason is so that the person responsible for A only gets the A data and so on and so forth. I admit its not the best of things but mine is not to reason why

Hi, is there anyway i can take a sheet of data in excel and then export certain rows matching a specific criteria into a new workbook? For example i would want to take all of the A's and put them into an a workbook or a workbook template and the b's into a b workbook etc etc However the...

Thanks for the help but i keep getting a compile error message "argument not optional" Private Sub Command5_Click() On Error GoTo Err_Command5_Click IIf DLookup("[tablename]![object]", "[tablename]") = "Yes" Then stDocName = "query1" DoCmd.Openquery stDocName, acPreview Else...

Hi I have an access 97 database which uses a form to collect either a yes or a no answer and then stores it in a table. The problem is i need to be able to run either query 1 if the response in the table is yes or query 2 if the response is no, using a button on another form (its needs to...

Leighmoore, Many thanks for the tips unfortunately i am getting a Compile error: invalid outside procedure when trying to run this script (apologies in advance as i am a beginner when it comes to scripts). Its highlighting x = 1 ???