|
|
| Subform updating in error |
| I have this written this in ACCESS 2007:
Private Sub USAGE_PERIOD_AfterUpdate()
If DCount("*", "tblImportTracker", "[FileName] = '" & Me![FILENAME] & "' And
[RunNo] = " & Me![RunNo] & " And [UsagePe... on 13-Nov-09 |
| |
|
| Windows Photo Viewer |
| Hi, everybody
I want to show a ".jpg" pic in Windows Photo Viewer in Access 2000 by Shell
Command. Now I do it by using
BildErgebnis = Shell("C:\Program Files\IrfanView\i_view32.exe " &
allgKZalph1... on 12-Nov-09 |
| |
|
| Nz Question |
| Hello all,
My formula works perfectly so far:
Me.inv = Nz(DCount("[OrderID]", "Orders", "[Transaction Type]=2"), 0) + 1
It returns a number that is exactly what I want. However, I am not sure how... on 12-Nov-09 |
| |
|
| How to update MsDataShape/NEW field in forms |
| Trying to update a virtual NEW field from a shaped (ADO-) recordset in forms
results in an error: "Field [fieldname] is based on an expression and cannot
be modified.
Similarly, on a virtual table fr... on 05-Nov-09 |
| |
|
| Refresh links in ACCDE |
| Hi everybody, I have a problem with the code below. It works fine when it is
in a accdb but when I create an ACCDE it does not work. Any idea on how to
solve this issue ? I am trying to connect to ... on 21-Oct-09 |
| |
|
| ADO cannot write to SQL server |
| I am trying to edit data on the sql express server. I can edit data in table
(machine ODBC data source) but I cannot alter data by using VBA.
Public Function fnODBC()
'DAO
Dim ws As Workspace
Dim db... on 07-Oct-09 |
| |
|
| Is there an Access size limit? |
| I am about to take on a project with Access 2003. I have not seen the data
yet, but I am told that the current program size is between 10 and 15 meg,
and that there are 7000 master records. Further... on 01-Oct-09 |
| |
|
|
|