Search results for query: *

How do I add a Browse button to a form for selecting a specific file on the current user's hard drive? Thanks, Steve728

Please provide me with a code sample of how to detect if a form is open in the backgrund or not. Thanks, Steve728

When trying to copy a photo into an OLE Object data type field I get the error message "The OLE server isn't registered. To register the OLE server, reinstall it. How do I do this??? Steve728 MS Access 2000 Win XP OS

Can anyone show me where to look and learn how to create group headers and footers in a continuous form? I know all is possible but is it really feasible? I know how to do it in reports but forms??? Steve728

Great. I should have been more generally explicit. How do I turn whatever time is in the field to it's 24 hour equivalent? Thanks again, Steve728

I want to convert a field's string content of "6:00" to "18:00"). Do I use the use the format() function? Will someone show me how to do this?? Thanks in advance. Steve728

Once I'm done gathering data into a table I need to export it to an Excel Spreadsheet or a .csv file. Is it possible to do this from within a stored procedure? If so please show me an example of the typeical code. Thanks in Advance! Steve728

I've given you all stars for sharing your weekends with me. I Don't know what I would do whithout all my cyber friends out there. Probably punt. Steve728

I'm using Access 2002 so here goes: .TxtPurse.Value > Me.TxtPrior Then strMemo = "-" & Now() & " Increased pocket from $" & .TxtPrior.Value & " to " _ & .TxtPurse.Value & vbCrLf & Nz(Trim(Forms![Storage Data Entry]!TxtMemo), " ") adoconnection.Execute "UPDATE storage SET...

This is great but please insert the corrections into my code so that I can see where to and how to apply this. Please.

I'm having a problem updating the storage.memo field with the contents of Forms![Storage Data Entry]!TxtMemo) because of special chars within it (i.e. ##, ' + *, etc.) Please help me solve this issue. If .TxtPurse.Value > Me.TxtPrior Then strMemo = "-" & Now() & " Increased pocket from...

Can anyone refer me to a good textbook that provides easy to more complex T-SQL tests with answers provided to check the results? The book would hopefully include the tables required or would use the common MS examples.

andymc Will you please send me some of your samples using nested if / Else If / Else 3-4 deep? Or perhaps refer me to more examples.I also got the good examples when "Making multiple variable assignments in one formula" from kenhamady.com Thanks in advance. Steve728 VBA, .NET, T-Sql 2000...

lbass Is the following correct when adding a third nested If? if x = 1 then ( if a = 5 then ( if q = "Go" then m else n ) b else c ) else if x = 2 then ( if a = 2 then d else e ) else y

I noticed and confirmed with other users that Crystal Reports XI easily gets confused when you work with nested Ifs. You must help the program by using parenthesis and semi colons. Will someone please refer me to a good reference for learning how to overcome this problem? A textbook or better...

Dear dgillz: The formula works great. Can you please tell me how to use a customized color for this formula instead of listed ones? I want to create a lighter shade of the color Silver. Actually light gray so that the printer doesn't use so much ink. Thanks so much! Steve728

Thank you so much and true, I should have included the version of the software. It is XI. Any changes? Steve728

I want the detail section to display two colors off and on within the detail section of the report. How do I do this? A formula?

Can someone please refer me to a good source of examples developing vb.net TreeView controls. Steve728 VS.Net 2003

Will someone please explaing what the following line is doing? If (@Job_Name = N") SELECT @Job_Name = NULL I'm used to seeing more like: If (@Job_Name = 'N') SELECT @Job_Name = NULL Thanks, Steve728