Search results

if you can somehow import the winsock library you can create a "WinSock" object and get the LocalIP property.

Use a VALUES clause... INSERT INTO TRAN (VEN_ID, CARRIER, CTRL_NUM, PALLET_TYP, CTRL_ID, CTRL_DT, TRAILER_ID, TRAN_DT, IN_OK, OUT_OK ) VALUES ('ValOfVEN_ID','ValOfCARRIER',....) You fill it in, but follow the format defined in the first set of parenthesis.

Mile: Make functions in VB6, compile to DLL, reference DLL. This way, your code is compiled, so it will run much faster than through access (aka interpreted). Give it a try see what happens.

Link the CSV file as a table, make append query, simple.

Delete the box, change background color of textbox.

Not sure what you mean by "placing the form" under "headings". Care to elaborate?

Progress-Bar That is VBA Code driven, so you can prolly set up a timer on the form that counts it down for 45 seconds. Otherwise make a form, turn it to popup in the properties and open it when you start, close it when you end.

1) The update query if set up properly will update old records AND add missing ones. 2) Tools->Startup, Choose initial form.

I don't think you all understand the scope and design of my report.

no, it must be on each page

Are you sure? I cannot seem to find them anywhere.

on his face

Haha, no worries about that, but you know my location is valid look up ^^^

np, enjoy :D

the linked tables in my test db(s) for they may be absolute which would mean you need a user 'ablondah' on you're machine and a folder 'asdasd' on the desktop for you to put it in if you want it to work. However, it may be storing the links as relative paths, in which case you are set.

You need a query of the events table, put a criteria on the teamid to filter for whichever team you need, then make a field called tDiff and make it's definition: DateDiff("s",Date() + [TimeStart],Date() + [TimeEnd]) Sort by decending order.

Try modeling your query like this one: may have to re-link tables...

Just read that link above, let me modify my query to update records as well.

All it does is add the new ones. Match the form properties, it might help out ^_^

with a large