Search results

Thanks for the reply. This did not work. I'm postive I cannot reference an unbound textbox using this method. Since Text23 is not a field it is not recognized. Any other thoughts? Brian

I have an unbound textbox (Text23) on a report with the following code in the OnFormat event of the section. Private Sub GroupFooter1_Print(Cancel As Integer, PrintCount As Integer) If Text23.Value >= 2 Then Text25.Value = "Transfer" ElseIf Text23.Value <= 1 Then Text25.Value =...

Does anyone know how to run a macro from another database? Example: db1 contains macro1, I want db2 to be able to execute macro1. Sounds easy enough. Brian

I want a MsgBox to display a value from the current form when a command button is click. For example; Field3 is a field that calculates Field1 and Field2. When Command1 is clicked I want a MsgBox to display "Your total amount is: [field3's value]." Any ideas? Thanks, Brian.

Thanks! Works Great. Brian

I have a report and want to combine the value of two text boxes. For example: TextBox1 value = 100 and Text2 value = 200. I want an unbound textbox to show 100 and 200. Yes, I want the word "and" in there. Thanks in advance. Brian.

Check the appearance settings of your PC. Right click on desktop and select properties. You should then see appearance tab. Play with that for a bit. Brian

I've never tried this. Maybe you can import the form into your database and use the form adding your controls. Brian

Pocket Access is a file TYPE, not a PROGRAM. I see the need to have an actual program but the brains at Microsoft see it different. If you are looking for a good Db program I would suggest DbAnywhere. You can purchase it at handango.com. I use it frequently and even the developer responded...

Does anyone have a sample database that records click events to a table? Basically, I would like to know what each person does while in the database. Thanks, Brian.

Try this? =DCount("[EmployeeID]","1A_All Employees","[Depart_DNO] Between #09/30/02# And #11/01/02#,0)) Brian

Ian, Time to put this thing to rest. I got it working now. What I did was place three command buttons on my sheet. Each one would perform the spellcheck operation for their respective cells. I used three modules "Mod1" (CheckCells1), "Mod2" (CheckCells2) and "Mod3" (CheckCells3). For some...

I thought I was on to something there. Application.DisplayAlerts let it automatically begin checking from the top of the sheet. Any other thoughts? Brian

After I have spellchecked "A4" and "A6" I get this question, "Do you want to continue Spellchecking from the top of sheet?"? If I can set the default value of this question to"false" then I would be accomplishing what I set out to do. Any ideas? Brian

Ian, You are probably right, it's an Excel 2K issue. Did you try the file I attached and did it work on yours? Also, I have previously removed the protection, ran the spellcheck and then added protection all using vba. It also wants to continue to spell check the entire sheet. I only want...

I downloaded your file and it works as I need it to. I attempted to duplicate your code under a new file without success. The spellchecker will not stop after A1. I'm using Excel 2K, do you think that is the problem? I have attached the file where I tried to dup your code. Let me know if it...

Ian, Thanks for the reply. We're becoming very familiar with each other. I previously tried your idea and it does start at the specific cell but it wants to continue spellchecking the entire file. I ONLY want it to check these two cells. The reason for this is that the rest of the file it...

Does anyone know how to stop the spellchecker after it has checked specific cells? I have two cells, G3, G6. I would like to check only these areas and close the spellchecker. This is my code presently: Private Sub CommandButton2_Click() ActiveSheet.Unprotect Password:="PW"...

Just for fun. Does anyone know if you can place an image on a message box? I would bet if it is possible it would be a long vb procedure. Some time ago I seen an example of an image on the title bar of a message box. I display a message box in excel explaining the document and thought it...

I use ODBC and never have to import data. Brian.