Search results

Reported SPAM Signature for donnaj8887

NigelShaw, If both the source and target tables are in the SQL Server Database, why not simply execute a single Pass-Through Query? Example: oConnection1.Execute "INSERT INTO MyNewTableName (fldCellPhone, fldFirstName, fldLastName, fldTotalVisits, fldLastVisit, fldFirstEmployeeName)" _ & "...

Hello, NigelShaw, To create a table in an SQL Server database and populate the data, see my post here. Also, to determine whether a table exists in the SQL Server Database, try the following SQL syntax (substitute highlighted text with actual database/table names): SELECT * FROM...

You're very welcome, I'm glad it worked for you :)

Yes, your JOBS table is INNER JOIN-ed to your MATERIALS table. You need to change this to a LEFT JOIN (ex. FROM [Jobs] LEFT JOIN [Materials]).

In your module, you might have code like this: Option Explicit Public frmCode As String Public Function frmCodeGet() As String DoCmd.OpenForm "MyForm", , , , , acDialog frmCodeGet = frmCode End Function In the form MyForm, you might have two buttons, cmdOK and cmdCancel, and your...

Your request is still not clear. What exactly is it that you are trying to accomplish?

Having participated in various MRP system programming projects, I salute you for your courage, for I can tell you that you have undertaken no lightweight project. An MRP database application in Microsoft Access is not a project considered within the scope of a beginner MS Access user. You must...

In your SQL statement, For True: WHERE fldActive = 1 For False: WHERE fldActive = 0

If you are opening a recordset on a select statement, and not directly on a table, your statement should be: rstEmployees.Open (SQL), Cnxn1, adOpenKeyset, adLockOptimistic, adCmdText

You might try something like the following: Sub Test() Dim file_name As String Dim strPath As String ' NOTE: Make certain that CurDir is set to the ' directory of your choice strPath = CurDir & "\" & "*.txt" strfile = Dir(strPath) ' Loop through the...

To convert a bitmap to a JPEG, the following reference from The VB Zone may help: IJL10.DLL This is the Intel® JPEG Library that is used to save and load JPG/JPEG files in Visual Basic. This DLL does not need to be registered with REGSVR32.EXE. See the following module(s) for ease of use in...

You're welcome; I'm glad it worked for you.

Try something like the following (substitute bracketed table/field names with the actual names): UPDATE [MyTable] T1 SET T1.[Fee] = 13 WHERE T1.[Line_No] = ( SELECT MIN(T2.[Line_No]) FROM [MyTable] T2 WHERE T2.[Order_No] = T1.[Order_No]);

tagah, Databases require an actual field/value to make this determination; unless you have a field in your table that tracks line numbers, the database has no way to track it for you. What indicates the first record of each order number? Is it the Product #? Is there a Line Number? Example...

Yes, there is. Contact your "endorser" for the password.

Check out the following link: http://msdn.microsoft.com/en-us/library/aa286747(office.10).aspx

Set the Form's NavigationButtons property to No.

Also, instead of Format (n, "##0.00"), you might try Round(n, 2).

Easy. Either: 1) Share the scenario and the solution, that this thread may contribute to the knowledgebase of this forum, or 2) Delete the thread, since there is no scenario OR solution posted. This thread, in its current state, contributes nothing useful whatever.