Recent content by neecie

The method used to add items depends on what combobox you are using. MSOffice, forms, Access all have different comboboxes and require different variables. It would help to know what library references you are using.

If you are trying to update the SHIP table, shouldn't it be WHERE SHIP.AP_NUM = T.AP_NUM (or formfield) You can try either of the below options UPDATE SHIP SET SHIP.DETACHED_HOUSE = 0, SHIP.ATTACHED_HOUSE = 0, SHIP.PUD = 0, SHIP.CO_OP = 0, SHIP.CONDO = 1 WHERE EXISTS (SELECT...

If you search for "upgrade" in Access help it will bring up a list that includes "Use the Upsizing Wizard". From there you can read aboout converting your .mdb to a frontend/backend Access/SQL program.

Steve101, My references were from the MSDN Library. Specifically from Microsoft Office 2000/Visual Basic Programmers Guide Chapter 16 - Multiuser Database Solutions

If you have the permissions, select File, then Import Data and be sure that "All Files" or Excel files are listed in the file type of the dialog box

You may have found a workaround to receiving the unwanted message, but depending on the work environment your application runs in, it may not be the best solution. The following warnings are from MS regarding the use of the /runtime parameter: "The /runtime option does not secure your...

I had the same problem. I use a sub procedure to input the variables into textboxes on a hidden form, then reference the form fields for the parameters.

I'm getting confused following ISNULL NULLIF ISNULL! Doesn't the following do the same? dbo.MgrTB_tbl_Missed_Punch.EmpLastName + ', ' + dbo.MgrTB_tbl_Missed_Punch.EmpLglFirstName + ' ' + ISNULL(dbo.MgrTB_tbl_Missed_Punch.EmpMidName,'') AS NAME As Case statement would better deal with the...

I am afraid I have bad news... Microsoft says this behavior is by design (see MSKB article 322762). [sadeyes]

Bob, I am glad to know that I am not the only one who feels I would be better off without involving Access! I have been trying to convince my boss, without success, to dump Access and use VB for a long time. It is good to know that I am not the only one who feels this way!

Hi chezealot9, The answer to your question depends on how often you modify your code, how often it is accessed, etc. I have a timeclock program that runs continuously (and hadn't been modified for over a year). I had to make a change recently and the db compacted from 8M to 212kb! I compact...

Try: = Sum([Quantity]* [UnitPrice]) Or = Sum([LineTotal])

Glad your problem is solved!

I am not positive about SQL 2000, but in SQL7, if the Startup Service Account (find it in the server properties dialogue on the security tab) is the default "system account" then you can not access the server over a network. You need to change it to "This Account" and...

Personally, I use a function for processing stored procedures [code] Public Function Exec_Select2(spName As String, ParamArray IDs()) As ADODB.Recordset Dim i As Integer Dim com1 As ADODB.Command Dim parame As ADODB.Parameter Set com1 = New ADODB.Command...