Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SmokinWrek

    Count from DBF to Excel

    Swi, I was looking into this a bit more, and if you return a recordset rather than trying to do a SELECT INTO, you might be able to use the CopyFromRecordset method to import the data. Kevin
  2. SmokinWrek

    Count from DBF to Excel

    ...to place the returned records. The IN clause will allow you to specify another database (in your case, an Excel file). Example: SELECT Persons.* INTO Persons IN 'Backup.mdb' FROM Persons In your case, the 'Backup.mdb' would be replaced with your Excel file. However, I'm not sure what...
  3. SmokinWrek

    I don't understand this error.

    PHV, I believe I originally had it written without the subquery, but when I ran into problems, I experimented writing it different ways. I believe the reason I had it as a subquery was simply because I started with the simplest part of the query and began building upon it (i.e. - I started...
  4. SmokinWrek

    I don't understand this error.

    Thanks, r937. I was not aware of that restriction when using an aggregate expression. PHV, is the BETWEEN operator inclusive (i.e. - If j.JobDate was 05/01/2007 or 05/30/2007 would it be included?)? Also, if I do the INNER JOIN on the whole JobInfo table, wouldn't that use more memory...
  5. SmokinWrek

    I don't understand this error.

    I don't work much in Access, but I have written SQL statements before for my VB programs. I am currently trying to write a query in Access, but am coming up with an error I don't quite understand, and of course, help is of no help at all. Here's my query: SELECT i.ClientID, SUM(d.Peices) AS...
  6. SmokinWrek

    Assign User Defined Type to Dictionary Item

    ...of the UDT, and use a dictionary item just to point to where certain items are stored within the array. Private Type DataInfo fldInd As String * 1 fldName As String fldPos As Long fldLen As Long fldMax As Long fldMin As Long fldCnt As Long fldWithData As Long End Type Dim...
  7. SmokinWrek

    Assign User Defined Type to Dictionary Item

    ...item, but am having problems. When I define the UDT and variable within my form module like this: Private Type DataInfo fldInd As String * 1 fldName As String fldPos As Long fldLen As Long fldMax As Long fldMin As Long fldCnt As Long fldWithData As Long End Type Dim...
  8. SmokinWrek

    Data Reports Question

    Well, for one of my programs that uses a data report, I'm displaying a form so the user can select date ranges, etc. Then I'm issuing the SQL statement to get the relevant data, and performing calculations on it. I would set the properties at that point. Obviously, your program will be...
  9. SmokinWrek

    Help with getting OU from active directory

    You might want to look in the Object Browser in the IDE... look at ActiveDs. I think you should be able to just use something like: IADsOU.Name Kevin
  10. SmokinWrek

    Data Reports Question

    oops... that thread is: thread709-88923
  11. SmokinWrek

    Data Reports Question

    You might put something like this in your code: If FldVal < 0 Then rptMyReport.Sections(1).Controls("txtMyControl").ForeColor = vbRed Else rptMyReport.Sections(1).Controls("txtMyControl").ForeColor = vbBlue End If You might want to read this thread as well, lots of different things...
  12. SmokinWrek

    Barcodes In Visual Basic

    As the others have said, most (if not all) handheld scanners do the actual detection of symbology and just send back the data that is encoded in the barcode. However, if you would like to learn more about the different symbologies and how to decode them, I highly recommend "The Bar Code Book"...
  13. SmokinWrek

    Arrays, Collections, insertion, and speed

    ...'increase the size of array ArraySize = ArraySize + 1 'shift down the contents of array starting from location [index] CopyMemory ByVal VarPtr(A(Index + 1)), _ ByVal VarPtr(A(Index)), (ArraySize - Index) * 4 'assign the new item into the array A(Index) = Item End Sub
  14. SmokinWrek

    HELP: ActiveReports!!!!!!!!!!!! ( VB 6.0)

    I don't know anything about ActiveReports, but have you checked in the object browser to make sure you're referencing the property correctly and that your constant is correct? I know if I'm using a data report, it's referenced like this: rptName.Orientation = rptOrientLandscape Just a...
  15. SmokinWrek

    Add Boolean Column using DAO

    If this is an Access database, you might try YesNo as your datatype. Kevin
  16. SmokinWrek

    error message related to mscvrt.dll

    Cubby1, Did you make sure that you closed other apps before you tried installing again? Try installing right after a reboot, before launching any other programs. If neither of those solutions work, try cancelling/closing programs in your task tray. Kevin
  17. SmokinWrek

    GET statement error

    ...Binary As #1 Len = RecordSize Set OutStream = fso.OpenTextFile(OutFile, ForWriting, True) For x = RecNum To 2 Step -1 Get #1, (RecordSize * (x - 1)) + 1, InputData OutStream.Write InputData CurrentCount = CurrentCount + 1 If ((CurrentCount Mod 1000) = 0) Then...
  18. SmokinWrek

    GET statement error

    Howdy! I hope someone can help me out here. I've got the following code that is supposed to read in a file of fixed length records, and reverse its order. OutFile = txtOutputFilename.Text InFile = txtInputFilename.Text TotalCount = fso.GetFile(InFile).Size / RecordSize RecNum =...
  19. SmokinWrek

    XP Pro laptop with network access issues.

    I have a laptop running XP Pro on my network that the user takes home so she can work from home(via VPN). Lately, when she brings the laptop to work and plugs in at her desk, she has some problems. She logs in to the domain just fine, and can access shares on our NT4 servers, but not the...
  20. SmokinWrek

    Report/Data Report

    Thanks, Swi! I was under the impression (from the help files) that I had to have an active connection during design time to assign the DataFields. Kevin

Part and Inventory Search

Back
Top