Search results

Any ideas or suggestions on how, eg ; as per code The list data is stored in A table called Selections The information needs to be added to the Table Call Seection (Via a form) Due to the GROUP BY options in the code for the list boxes (calling the selections table) the form is Read only in a...

Ok - managed to get the 4 list boxes working. Because the List data is in a separate table, the form will not allow me to update anymore. Please could you let me know how I can add records now (I presume that the GROUP BY has something to do with this)

I have managed to get it working - Thankyou Here is my solution Here is the output

Ok I have got the ouput to come out on the email - with the following code However I cannot get carriage returns, I have tried the following vbCrLf vbCr vbLf vbNewLine the output in the e-mail is as follows As you can see not line breaks, I presume that the body of the e-mail is HTML so...

Hi Thanks for that - It dosen't seem to like & vbCrLf & _ Any ideas?

I have been trying for hours to send form output via E-mail. I have got it working, but the body only outputs 1 line. Please see code below and the resulting e-mail is as below The e-mail only outputs the last line in Body from the script, please can anyone help?

Ok I am trying you method, but i am confused the table contains the following Table Name Selections Selection1 | Selection2 | Selection3 |Selection4 I.T Related | Software | Installation | Other I.T Related | Software | Removal MS...

Hi I am exploring options at the moment Using Multi List box or List box. But the data at the moment is not in any table, so Listbox1 I am inputting the data manually in the list - But pointing the data to be saved in a field in a table. Listbox2 will create a list dependent on what is...

Hi I am wanting to preempt data in list boxes listbox1 Fruit Vegetable listbox2 (If Fruit Is Selected) Apple Banana Orange listbox2 (If Vegetable Is Selected) Potato Peas Carrot If Fruit is selected in Listbox1 - Then Listbox2 should have the options Apple Banana Orange If Vegetable is...

I am trying to configure remote assistance, (on click). Whereby I have the PC Name for the remove assist. eg: PCNAME is Laptop1 I have managed to do this with remote desktop Private Sub PC_Name_Click() Shell ("mstsc.exe /v:" & PC_Name) End Sub (PC_Name is the field that holds the value) Can...

I can import the global address book but not the actual SMTP address, please can someone advise how do to this (the SMTP is on the exchange sever, but when I import, everything imports apart from the SMTP. Please can someone advise?:banghead:

Excellent that worked :) Thanks for that

I am trying to do a find and replace in msword problem: I need to search for the following format REF NO: 84542654 REF NO: 21364589 i need to replace the first 4 digits in the number with * so the iuput should be REF NO: ****2654 REF NO: ****4589 I cannot seem to get this working I have...

SOLVED Thanks for the responses I thought out of the box and used the following method in Sheet 1 I concatanated the cells that i wanted to use in the search EG: A1 - MR B1 - JOE C2 - BLOGGS IN G1 - =A1&" "&B1&" "&C2 SO G1 WILL contain the following output - Mr Joe Bloggs I did the same...

Thanks for the reponse i am trying to lookup to values in a row against a range to see if the same 2 values appear in the other spreadsheet in a the same row, and return a column value from that row. eg: - search for MR(title)(A1) and Bloggs(surname)(B1) spreadsheet 3 - when both are found in...

I am trying to do a Double nested vlookup where vlookup 1 looks for DOB in range and and vllokup 2 looks for surname in range, only when both vlookups match will it return the corresponding column value =IF(VLOOKUP(Sheet1!A1,Sheet3!$A:$G,(VLOOKUP(Sheet1!F1,Sheet3!$F:$F,1,FALSE)),FALSE),"NULL")...

I have just solved it I did a find and replace (as the page breaks are manual) for value ^m (with all the spaces before it) and replace with a space (space bar) works a treat

Hi I have a documemt that has been run through a macro that i created and eventually i get the records to split as i want them. However when each record ends it inserts a blank page I have done most of the adjustments with find and replace, however you cannot do find and replace when...

Thanks namliam That is to much coding for me, as i need to concatanate cells at a later stage, and record all this in a macro. This file needs to be run every week. I am not that bothered if i use vlookup, any other function/macro will do, as long as the required output works. Any ideas?

I am trying to use a Vlookup, in a Spreadsheet that has 15000 records. Column A has account numbers (which are repeated a few times) and Column B has person names. What I am trying to do is Vlookup repeat account numbers and show the person linked to that account in the form of a row. Vlookup...