Search results for query: *

Hi, I am wanting to attach a file to a record. I want the user to be able to click a button, select a file and click save, just like attaching a file to an email, then the file to be saved / linked to the record. I've searched all over the internet for this but keep coming up with "How to...

Hi, I've been looking all over the internet and can't find what I'm looking for.....So I thought i'd try here :D No doubt someone can help! Basically I have a spreadsheet, see attached. I want to click a button and a filter to be ran, the filter will filter through the list of names (column...

Hi, I have a graph with various pieces of data on it (Series 1, Series 2 etc) I want to have check boxes next to the graph so when I tick them the data is visible on the graph and when I untick them I want the data on the graph not to be visible. I don't want to use: column(x).hidden = false...

If wanting to put a function into vba Basically its a vlookup, how would I write it? I thought maybe something like: vlookup(cells(vrow,"A").value,data,3,false) but this isn't working data is the name of the lookup area any ideas Cheers

Hi, I am wanting to do the following, how would I put it into code please? if cell a1 = (few calculations) then cell b1 = Y else b2 = N then I want to move onto cell a2 and run the same formula e.g if cell a2 = (few calculations) then cell b2 = Y else b2 = N but have to run the...

Hi I have a bar chart (MyGraph) and a button (MyButton) when I click "MyButton" I want "MyGraph" to change to a pie chart automatically, so i have entered the following code: Sub MyButton_Click() Dim GraphObj As Object Set GraphObj = Me![MyGraph].Object.Application.Chart GraphObj.Type...

Hi, I have a spreadsheet to do do some calculations at work, to do with prices. Basically I want to put "If the value = £XX plus or minus £0.01" At the min here is my formula...

I've got a db containing 12 linked speadsheets (Jan - Dec) and have then used a UNION ALL query to consolidate all od the data, and have then ran a further query (filtering specific dates) based on the UNION ALL Query. But I am not getting the correct results. Even though the data in my linked...

Hi, I have a database with 12 linked spreasheets containing info (Jan - Dec). Each one contains data in the same layout, same headers etc. I want to consolidate all the info onto one sheet automatically, without having to copy and paste the data in excel. I want to do this so I can run queries...

I've got a spreadsheet with different prices and percentages etc. in that I want to link to Access, I've gone through the wizard as I always do and most of the data has imported fine. But, there are one or two cells that when opened in Access, just give the error "#Num!" they are in the same...

Hi, I have a workbook with 2 sheets in it. On the second sheet in a cell I have put ='08.08.07'!A20 which is the reference of the cell on the first sheet that I want to get the info from. But, nothing is happening, in the cell it just says ='08.08.07'!A20 I've come across this before but...

Hi, I've got a Spreadsheet with various info on it. I use filters and want to add a formula to do the following: e.g/ A B C 1 Test __________________________________________ 10 1000 Test 16 100 Not inc. 20 50...

Hi, I need to set my autonumber to start at 10000. I've done this once already by doing an append query (duplicate table structure, add 1 record and number to start from etc, then making append query) and it worked fine. I have taken the same steps again to redo this and it still carries on...

Hi, just wondered how I would put the following into code: (I know how do to the Dlookup part) If the value I enter in a textbox is not found during a dlookup then leave the value as it is, if it is found in the dlookup then enter the dlookup value. e.g If I put "Test" into a text box and...

I have a form with a search box, when I enter criteria in the search box and click a seach button, the record that matches the criteria is displayed then the "Req received date" box is highlighted ready for me to enter info in. All the above works fine but, when the record is open ready for me...

Hi, I have a db which is working fine, but now, when i press the "Print Order" button I want the date that the order was printed to be inserted into my "Order Printed" text box. ie./ When I click the print order button, todays date is transferred into my "Order Printed" text box, so if the...

Hi, i've searched the forum and can't seem to find what i am looking for (sorry if i have misssed it). I have a form which obviously stores info into a table. All I want to do is insert a button, when i click the button a box comes up asking me where i would like to save the Excel spreadsheet...

Hi, a friend has just emailed me asking if i could post the below question on here: I have a query that contains, among other things, the name of X people attending X event and another name (from the same table) who is to act as their 'in case of emergency' contact. However, how can I check...

I have a search box (txtSearch) and a button (cmdSearch) when i enter text in txtSearch and click cmdSearch, the following code runs and filters my data to the criteria in txtSearch: Me.Filter = "" txtSearch.SetFocus If Len(txtSearch.Text) = 0 Then Exit Sub Dim strSearch As String strSearch =...

Hi, Sorry i know this is going to be a really simple question, just i've been working on a DB all day and my minds suddely gone blank! I have a search query and two combo boxes, i select the critria in my combo boxes, click search and the list of records matching the required criteria is...