Recent content by aco2x

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 =...

You might start with something like this in your command button click procedure: Dim MyRS As ADODB.Recordset Dim MySQLString As String Set MyRS = New ADODB.Recordset MyRS.CursorLocation = adUseClient MySQLString = "SELECT * FROM myTable WHERE Trandate =...

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...

I think you will need to pass a hierarchical recordset to be the data source for your data report. 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 " & _...

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...

I think you will need to introduce grouping into your data report and then pass a hierarchical record set as the data source to the Data Report. Something like the following, but you will need to flesh it out for the three levels that you want to achieve. 'Make sure you specify a Shape...

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.