Search results

Look here for the difference in your code. http://support.microsoft.com/kb/q97142/

First Save yourself some frustration add a global Boolean to your module. Example: Dim mfAlreadyToldYou as Boolean Public Function updwrng() Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset Dim strSQL As String rs.Open "tblLogout", CurrentProject.Connection...

Use "" instead of '' for MS Access

One method would be to have the following 2 Front Ends (One for Branch, One for Staff) 1 Back End (Where the tables are located) You would then link the Front Ends to the Back End.

See this article. http://support.microsoft.com/default.aspx?scid=kb;en-us;75517 Since you can only redim the rightmost subscript, one way to get the dimension that you want is to know upfront how big you need to make the left subscript(s). You could also look into other possible solutions...

Make a copy of this MDB Leaving the Original alone (Don't touch it) try and compile the copy and see if you can access the modules. If not then look into Decompile http://www.mvps.org/access/bugs/bugs0008.htm AGAIN I DON"T THINK I CAN STRESS THIS ENOUGH. DON'T DO THIS ON THE ORIGINAL, DO...

Just a question. Why not just put the forms in each of the Tabs through the Designer?

1. Place this code in a Public Module 2. Add the word "Required" (or "NumberRequired" for number fields) to each control on your form that you want to have validated. 3. From an event (Button Click, OnSave etc) call the fnValidateForm by passing the form object. Example...

Place this in the Current Event of the Form. That way everytime you switch records it runs.

'Using the Formst Recordset check the value of the previous record Dim rst As Object Set rst = Me.RecordsetClone 'Places the recordset clone on the current record rst.Bookmark = Me.Recordset.Bookmark rst.MovePrevious If rst.BOF then 'Trap for not having a previous record Else...

Using ADODB and the Forms Recordsetclone Dim rst As Object Set rst = Me.RecordsetClone Do While Not rst.EOF 'Check Field rst.Fields("{FieldName}").Value rst.MoveNext Loop Set rst = Nothing

I ran tests and it seems that the fix line is using some mathimatical presidence. You can fix this issue by changing your code as follows: This will force the Amount * 100 calc prior to the Fix Function MakeAmount(Amount As Double) As String Dim x As String x = (Amount * 100) x =...

You are not getting an error, because an Error did not occur. This issue is that the Provider you choose does not have those properties therefore the connection variable cannot display them. However, the question really comes down to what comes after the connection. Do you get data? You are...

For a single Field such as in your case you can use DLookUp to return the Level and populate a variable. From There you can use the varable to determine you settings. For more then one I would use a recordset. This reduces the # of calls to the backend data.

MS Knowledge base

SELECT [tblRR25_(Third-party)].[Opco Code], IIf(ReturnVariableX()="ALL",[Opco Code] Like "*",ReturnVariableX()) AS Expr1 FROM [tblRR25_(Third-party)] GROUP BY [tblRR25_(Third-party)].[Opco Code], IIf(ReturnVariableX()="ALL",[Opco Code] Like "*",ReturnVariableX()); Look at what the SQL would...

You can Automate a Task Request. This does not directly create a task, but sends an email to a person letting them know that a task has been requested. They get to accept/decline the request. Most of the Code is the same, just use Outlook.TaskRequestItem instead of Outlook.TaskRequest

Try this site www.4guysfromrolla.com/webtech/041404-1.shtml Simple answer is to open an ADODB recordset and use the Save function with the adPersistXML rst.Save "c:\x.xml", adPersistXML

That Line did not confuse me. What is confusing me is the Idea of 1000 at a time when you could do Insert Into [TBL1] (Field1, Field2 ,Field3 ,Field4,Field5) Select Field1, Field2 ,Field3 ,Field4,Field5 From [TableName of rst_RS] But now I see that you have two different DB's. Have you...

You could try a striaght Append Query (Insert Into). You have not made it clear why you want to break this down into 1000 records at a time. Is [ID] the primary Index?