Search results for query: *

I would say that there are two more extraneous "alleges" in the section of the sentence beginning with "alleged victims claim". The verb claim already implies allegation and makes them redundant. I would propose the sentence should be: Additional accusers of Jerry Sandusky's alleged acts...

Did you learn this in SKOOL or SHOOL?

http://www.ebaumsworld.com/jokes/read/81202310/

Each section of the datareport has a "ForcePageBreak" property. Set this property to rptPageBreakBefore for the Branch header section and you should be good to go.

You can use the GetSpecialFolder method of the File System Object to achieve this. Set a reference in the project to the Microsoft Scripting Runtime object and use this code Dim FSO As FileSystemObject Dim TempDirectory As String Set FSO =...

...Dim MySQLString As String Set MyRS = New ADODB.Recordset MyRS.CursorLocation = adUseClient MySQLString = "SELECT * FROM myTable WHERE Trandate = '05/15/2003'" MyRS.Open MySQLString, MyConnection, adOpenDynamic, adLockOptimistic Set...

I'm not sure I totally understand your data structure but I'm assuming the child data(Table2 in my example) is in another table with a foreign key (FieldA) to the parent(Table1). If so, try a sub query in your join like this: [Code] SELECT Table1.FieldA, FieldB, FieldC, FieldXSum FROM Table1...

...Something like this: [code] SQLCmd = "SHAPE {SELECT DISTINCT Doc FROM Table Order By Doc} As Parent " & _ "APPEND ({SELECT * FROM Table Order By Doc} As Data " & _ "RELATE Doc TO Doc)" Set DataReportRS = DB_Connection.Execute (SQLCmd, , adCmdText) Set...

I had the same problem with flex grids. To get around this put a picture box on the form behind your grid and add some code like this: 'Place contents of flex grids in picture boxes pbSample.AutoRedraw = True pbSample.Picture = fgSampleRS.Picture 'Hide Flex grids...

You might consider using the FileSystemObject, which has a FileExists method you can interrogate: object.FileExists(filespec) The FileExists method syntax has these parts: Part Description object Required. Always the name of a FileSystemObject. filespec Required. The name of...

...connection ReportSQLString = "SHAPE {SELECT DISTINCT Doctor FROM AccessTable Order By Doctor} As Parent " & _ "APPEND ({SELECT * FROM AccessTable Order By Doctor} As Data " & _ "RELATE Doctor TO Doctor)" Set DataReportRS = DB_Connection.Execute...

gvidali: Your solution worked perfectly for a similar problem I was having.....a star for you.

What does the code look like in your flex grid click event? I think you are having trouble opening your picture file not having problems with the FSO in the command button.

Thanks for the input. USB Drivers are loaded. What does registering the MAC address consist of?

DHCP is enabled. I have also tried using a static IP address. I can then ping the loopback address and the static IP address of my own machine but cannot ping the gateway or any farther.

I have a Windows XP Professional machine connected to a hub and then a router for my DSL. I have a PCI NIC in currently and everything works fine. I need to switch to a USB NIC to free up a PCI slot. When I try to use the USB NIC I cant see the network. IPCONFIG/RELEASE and IPCONFIG/RENEW...

Try this code: txtField1.SelStart = 0 txtField1.SelLength = Len(txtField1)

You may have to try something like this: For iii = 1 To Copies .PrintReport While .AsyncCount > 0 DoEvents Wend Next iii

Instead of refreshing the data report, try re-querying the data source behind it.

You want to use the ShellExecute API. Try searching for threads that reference that or use thread 222-5014 as an example.