Search results

Thanks Mike for your Macro. I have imported it in my database but I don't understand how it works. Daniel

Hi Rabbie; Thanks for the link, I will give a look. Daniel

I don't think so because I am the developer of the database. I think that the difference comes from how you open the form but I don't know where I have to look. Daniel

Changing color of records in a form Hi, Is is possible to change the color of some records in a form? I would like to change - for example- the color of every 10th record in my form. Daniel

Hi, I don't understand why, when I am opening some forms, I have at the button of the form a few boxes with filter, record and search and in other forms I don't have those boxes. Daniel

No, doesn't work but I will try to find another solution.

I didn't want to use the Shell function because with the Shortcut CTRL+ALT+U , I can directly launch a macro and this is impossible with the Shell function. Daniel

SendKeys "%^U" doesn't work

It launches a Macro application in an other windows program. ( in macro Expert) Daniel

+ is for SHIFT Daniel

I don't think because To specify that any combination of SHIFT, CTRL, and ALT should be held down while several other keys are pressed, enclose the code for those keys in parentheses

Hi, I have tried the following code: SendKeys "%(^U)" The purpose is to stimulate CTRL+ALT+U (all 3 keystrokes should be hold down together) but it doesn't work. What 's wrong? Daniel

I have found it : Just replacing entireRow.delete by select Set c = ThisWorkbook.Worksheets("Sheet1").Cells.Find("abcde", LookIn:=xlValues) If c Is Nothing Then Exit Sub a = c.Address ThisWorkbook.Worksheets("Sheet1").Range(a).select

Hi Brian, Thanks for your reply. Instead of alter the screen size, is it possible to go - when opening the spreadheet- with the cursor to a certain cell ? ( like in access with the command DoCmd.GoToRecord....) ?

Hi Brian, Thanks for your reply, I will try it. Two other questions: When, I am running the code, It works and closes the Spreadsheet, but Excel is still open . Is it possible to close not only the file but also Excel? This is the code that I have written: xlwrkBk.Close 'Close the...

I have found the solution: I have replaced Row by EntireRow and it works. Daniel

Thanks for your reply but using the code as above , I am receiving the following error : "Compile error, Invalid qualifier" for ".Row " Daniel

Hi Chergh, What do you mean by "xlValues" ? Daniel

Thanks, I have tried and I am receiving the name "Singles" Daniel

Of course not, but in this file, there is no tab at the bottom with name "Sheet1 Sheet 2 ....."