Search results

Looks like a lot for info needed to understand your situation. How is data-entry done? How does your billing work......?

Sorry for the late response, we had three-day weekend. Nice layout - Hope that helps.

See attached Attached is a simple nifty sample created just for you. Hope it'll help you out. Remember, it's just a sample.

Is your listbox based on a query, table, ...?

First of all, are all the questions on one same form? How do you navigate through forms, via command buttons? How do you store the total score? Hope that helps.

Man! what happend to this forum? After leaving it unactivated for several minutes, it kicked me out and I'll have to login in again. Oops, back to business. Thanks FoFa. As I remember, for every connection, only one action can be performed. For example: RecordSet.Open sqlStatement...

Thanks FoFo for the response. I'm trying to avoid going through Access because that's not needed and would create an extra step. There should be a direct way to go from VB to SQL Server. How about something like this (brainstorming), will this work? 1. Open connection to Access DB 2...

Hello to all the experts out there. Hope you're having a great day. Does anyone know how to upload (append) programmatically a table in Access to an existing table in SQL Server 2000? On my VB app, there's an Upload button that when clicked will do the above task. The Access database also...

Hi guys and gals, I'm sorry that some of you took my comments offensively. I agree that Mr. Ghuson has been a great help in this forum and he did help out lots of folk here, including myself. I too, for a couple of times, did ask posters to use the Search utility. However, I found it...

How about showing some codes so that we know exactly where to put the "hay download this file" code at? Will it always be 5000?

WHERE [sqlTable's Name].TableFieldName = Me.UserID or the safe way: WHERE [sqlTable's Name].[TableFieldName] = Me.UserID.value Post back of its status.

Hi hooker, oops..., lhooker, Based on the way you name your variable, strComments seems to be an internal variable (agree with -g). Therefore, using Me.internalVariable will give you that error message because I can't find that field on your form. So whatever name of the column (in your...

Why not adding the module to your vb itself, just wonder?

Add this after your last 'Dim' statement If Forms![Hydro COA]![LotNumber] <> "" Then ...... Add this to the end Else Msgbox "Please enter a Lot Number!" End If

And...the winner is Mr. Ghuson (Circuit City guy). He seeeems to be the one that often asks posters to use the search utility. I'm sorry, man!

Add a DLookup to your listbox's afterupdate sub. Example: (just brainstorming, check for syntax, Country table has two fields: Country and City) Private sub listbox_afterupdate() CountryListBox = DLookup("[Country]","CountryTable","[City] = listbox.value") End Sub

:rolleyes: Not quite sure what you mean. Sensible?

Hi guys and gals, First of all, thank you for reading this. I've been wondering about when would be the best time to negotiate about a job promotion or for a raise. I'm hating my job and 've been looking for jobs. All were turned out. Man! what a poor life I'm having. Thanks alot.

Ultimate solution to all this "craps": Hmm......................................don't get married!!!!!

Thanks FoFa but again, it displays data out of tables which I'm trying to stay away from doing.