Search results for query: *

I have a table that has a scandate, name and other customer data. The problem is the application duplicates the customer information with each new scan like: 2007-05-25 George M 45 50$ 2006-08-08 Allie F 50 70$ 2005-07-07 Allie F 50 80$ 2004-05-05 Allie F 50 90$ I want to extract one record...

Hail, Can you put two conditions in a while loop? Reason I want to know is I have two arrays I want to loop through, only stopping the loop when BOTH are eof. Something like: $queryH="SELECT * FROM Goals"; $resultH=mysql_query($queryH); $queryA="SELECT * FROM Assists"...

Hail, I have 4 fields: tName, tDate, tTime, TotalUtilizationAvg (this field in in %) What I need is to get the max amount from the Utilization field per day per Name which I do like so: SELECT tName, tDate, max(TotalUtilizationAvg) as MaxUtil FROM Traffic GROUP BY BridgeName, TrafficDate...

Hail, I tried to puzzle this out all morning, I usually use DAO but I know it's not very efficinet with SQL so I'm trying to use ADO now. Anyway, the recordset below is returning 0 records when I know that specific query returns records, I'm wondering if it has to do with something I'm doing...

Hail, I have a database that stores some stats for a hockey league in the following manner: Field names are GP, G, A Whenever a player Plays a game, his ID is added to the column GP while other columns go to 0 If a player scores a goal, his ID goes under G, the guy who assisted goes under A...

Hail, Let's say you have: Public Type Test Test1 as string Test2 as string Test3 as string End Type Is there a way to loop through the elements? For example, let's say I would want to assign three values (1, 2 and 3) to each of those, is there a way to loop them instead of doing Dim...

Hail, Let's say I have three text boxes in my submit form that I name the same to put in an array: <input name='txtInput[]' size='5'> <input name='txtInput[]' size='5'> <input name='txtInput[]' size='5'> If I want to know the value of textbox # 2, how would I do that? I thought: msgbox...

Hail, I have reports that export to HTML which works well but all my listboxes are not showing any data? Furthermore, any other formatting in code is also ignored? Is there a way around this?

Hail, I have to 2 number fields which I want to display in a query with a calculation as Field1 / Field2 but instead of integers I want the field to show two decimals. So I thought I could use format(a,"0.00") or #.## but then when I put a sort on that field, it screws it up because it treats...

Hail, I have linked tables in MSaccess that connect to a Sybase DB. Everything works fine except that each time I want to open a table or run a query, I'm prompted for the user/password. Is there anyway I can specify this when I link the table or something (something resembling a trusted...

Hail, It's really weird, on my XP pro machine, when I try accessing a shared folder of another computer through RUN and typing IP\ShareName, it just hangs there for a long period of time before it opens up the shared folder (that is called UNC right?). Anyway, what's even more weird is if I...

Hail, When I work from home, I have to connect with Contivity VPN software from Nortel to retrieve emails and have access to intranet and such. Problem is, I cannot use my home LAN ressources (printer, shared folders) while connected to the VPN software. Is this a configuration on the server...

Hail, How can I call a stored procedure on a SQL 7.0 DB from VB with DAO (have it in code for ADO but I need for DAO)? I don't want to convert everything to ADO even though I know ADO is better for SQL and DAO is more for Access... Phailak

Hail, I'm trying to query one database and insert the result into another table from another DB. I use DAO in VB, and this is what I wrote so far, but I can't seem to get the IN syntax correctly: Dim DBref As Database Set DBref = OpenDatabase(&quot;&quot;, 512, false...

Hail, This is probably a real beginner question but I can't figure out a way around it. A VB app opens a recordset connection to the access MDB. While it is opened, no one else can use the application? The code to open the connection is like: Dim DB as Database, RST as Recordset Set db =...

Hail, Times in our application's DB is kept in GMT time so that when I query the DB I have to specify with dateadd the amount of hours to adjust to EST. Now this is either -4 from April to october or -5 from october to april. As it stands, I have to go into every query that has reports...

Hail, When I run the following code to modify design of a report I get an automation error if I run it more than once (first time works!!!) Dim Obj As Object Dim Rep As Report Set Obj = CreateObject(&quot;access.application&quot;) Obj.Visible = False Obj.OpenCurrentDatabase DBPath &...

Hail, I have a client and server application. The client connects to the server (winsock state at 7!) but he cannot send any data. After I send it, it does not go to sendcomplete event nor does it even go to the sendprogress event??? Anyone know what is going on here??? Phailak

Hail, I don't think my problem is really related to my code or Winsock in reality. I'm testing this game I made with a friend over the network. At work it works fine, and it works when I connect to him. But when he (i tried other cpus too) tries to connect to me (or to ping for that matter) it...

Hail, Can I use an API call to rotate a picture from a picture box (Need to make pic face north, NE, E, SE, S, SW, W, NW). Obviously I could save the pic in the different positions, but before I do that, I'd like to know if I can do it this way... Phailak