Search results

I think you mean a DSN (Data Source Name) not a DNS (Domain Name System) DSN = ODBC databases DNS = www.somename.com

Well, VB/VBA... unlike any other major language (aka C/C++/Java) apparantly dosent have null as a value. IsNull() func it makes me think that it may be a flag or something. Because in C++/Java Null has a value and object == null will return true or false.

Id still like to know why you cannot use the <> (does not equal) operator.

Can someone tell me why when i break on this line, it reports rst("MechHours") is 800 If rst("MechHours") <> Null Then But branches to the else block?

You can also try FORMS![FRM_WAIT].Repaint This forces windows to physically draw the frame instead of waiting till windows tosses the DRAW signal to the window.

Not really too familliar with DB2 here myself, sorry cant help you w/o further info.

Can you post your network and database configuration, it would help me understand how to help you. Aka, how is the network structured, where are the databases, where's the break in communication due to password change. That kind of info.

bill gates with (Note: Wow, this topic is still going, it was going back when i left my job last year...)

If all the tables you need from the ODBC have the same structure you can link them all at once. Then make an SQL Union Query that ports into a maketable query. Union SQL: SELECT * FROM tblOne UNION SELECT * FROM tblTwo UNION ... and so on...

ASP isn't compiled, it's interpreted. This means that the file you make in notepad is what will run. IIS comes with all the neccesary tools to make asp run and is automatically configured to do so. As far as different servers goes, if the webserver can access the db over a shared drive, then...

Never mind...

K, this is sorta a duplicate, but with a twist. Building a combo box to select an item. but it needs to hold the ID as it's value, but display the name. I can get the value to be hidden in the drop downs, but i want the resulting field to display the NAME, not the ID. How can I do this?

Two (three?) routes you can go: 1) Like you said, ASP frontend with Access BE (Good, but lacking: for webpages are tedious to make, and also limited in thier flexability in relation to forms. 2) Build an SQL/Oracle/Whatever server and put it up on company Intranet (or securely on the internet...

Me.Undo is like CTRL+z it's an undo, you cannot undo a close operation. When Closing a form, ive noticed the DoCmd.CancelEvent errors, and only for me Cancel = True plain old dosent work. They are three different things... that all share common aspects though. Cancel = True *SHOULD* Cancel...

*.mdw (something similar with a w, i think this is it) holds all that info, try creating a new db in a different folder.

You need either a FTP Transfer OCX/ACTIVEX/COM Controll OR The winsock Control and knowledge of FTP Protocol. The RFC Documentation of the FTP (File Transfer Protocol) is here: http://www.w3.org/Protocols/rfc959/

Hold down shift while opening the database, the go check what nonsense you have in your startup options. /me prays you didn't disable the shift button.

If Abs(DateDiff("d",Me!txtDoA,Date())) >= 14 AND Me!cboWork = "New" Then Me!cboWork = "Tainted" End If

I have found in all the domain appregation, that field names work better if surrounded by []. Also you just forgot quotes.

You will need to go to Tools->References and find 'Microsoft DAO 3.6' in the list and check it for this: This is sketchy, read up about it.. it has been eons since I've done vb file access, and even longer since VBA~