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
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'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.
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...
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
In my current employer's VB.NET coding I frequently see the following conditional coding:
If memvar = True Then
Do something...
Else : Me.TxtBox.Text = "DuDah"
Is there any reason, advantage to using the above versus the traditional syntax of:
If memvar = True Then
Do something...
Else...
Two questions about the following:
Dim s, fldCode$
1. What happens when you don't define the datatype like above?
2. What does the $ signify at the end of a memvar?
Thanks,
Steve728
Will someone please provide me a sample of code that will show me how to loop through multiple row selections made within a listview?
Thanks in advance,
Steve728
Basically I need the right syntax so that I can display the value in the listview's 2nd column:
MessageBox.Show("You selected FieldCode: " & Me.lvMOCApps.Column2)
VS.NET 2003
Steve728
Will someone please either show me how to create a multicolumn combo box with Visual Studio .NET 2003 or refer me to a reference on how do so?
Thanks in advance,
Steve728
Can someone please provide me with a sample of how one would
call a stored procedure from within a formula?
Thanks in advance.
Steve728
SQL Server 2000
Crystal Reports XI
My current employer has MANY graphically created NESTED JOIN queries. They drive me crazy with their complexities and normally have duplications. Is there a a reference some place on-line or a textbook that will serve as a good help in re-constructing them into a more straight-forward simpler...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.