Search results for query: *

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

I'm trying to assign a variable dim'ed as a UDT to a dictionary 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...

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

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

I need help! I have a program that reads in a flat datafile (fixed field/record length) and rewrites that file, but with extra records inserted every so often. The interval of insertion is dependant upon user input at the start of the program. I need to create a report that is based on the...

OK, I've got a program in which I am writing out fixed-length records to a file opened for Output. Some of the fields in the record are numbers calculated within the program. I need to output these numbers into a fixed length field and have leading zeroes. Example: calculated value is 4000...

I've got a fairly simple program that runs just fine in the IDE. It also runs fine as a compiled prog on my dev machine(WinME, but not by choice). However when I take it to the target machine(Win2K), it doesn't work properly. The program is supposed to read in a block of CRLF terminated...

Help! I'm getting this error on a Get statement, and I don't understand why. Here's the section of code that's giving me problems: Dim Banner() As BannerRec Dim NumRecs, Counter As Double Dim BoxSize, NumBoxes, NumPerPage As Integer Dim InputRec, BannerOut As String Open...