Recent content by CFields

Something like this can do the trick Private Sub MCN_AfterUpdate() If Me![DOCTYPE] = 2 Then Me![MCN] = Me![MCN] + 0.1 Else Me![MCN] = CInt(Me![MCN]) End If End Sub This adds one and reverse to subtract or something like below depending on your own needs, again this is just...

MonthYear: CStr(Year([Work Day]) & CStr(Month([Work Day]))) something like this or use datepart. In order to use the report wizard to total and average make it 2 fields and number on table. You can't total text fields by the wizard. Also if your using access they have an order database that...

Are they part of the workgroup? One may be signed in as admin and/or opened exclusively. Have they changed their options, they need to have their default open mode to shared and the default record locking to edited record. These are under tools, options and I believe the advanced tab. We've...

I'm using a query on a form that you open to find a record, then I use a command button to put this information into a subform. The code works the first time opened and then stalls. You have to shut down the form and come back in for it to work again. This is my code, what am I missing or...

You can use the ODBCConnectStr property in an SQL pass-through query to specify the Open Database Connectivity (ODBC) connection string for the query. Note The ODBCConnectStr property applies only to pass-through queries. Setting Enter the ODBC connection string that defines the connection...

Import or link (read-only) HTML tables and lists Open a database, or switch to the Database window for the open database. To import HTML tables or lists, on the File menu, point to Get External Data, and then click Import. To link HTML tables or lists, on the File menu, point to Get External...