Search results

"[ANALYSIS DATE] >= #12/31/1999# Or ( IsNull([ANALYSIS DATE]) And ( [Parts type] = 'Fuel' ) )"

I think it possible. If local Access file is linking to network database version you can create a logic which will compare local table data versus network table data. Write VBA code with SQL statement/append query and insert missing data in the network version table.

SELECT * FROM YourTableName where Month(YourFieldName)=Month(Date()) and Year(YourFieldName)=Year(Date())

You have to purchase Microsoft Office Developer Edition. It creates run time files and allows you to load database .mdb file as a software without having MS Access on client machine.

Private Function PurgeNumericInput(StringVal As Variant) As Variant On Local Error Resume Next Dim x As Integer Dim WorkString As String If Len(Trim(StringVal)) = 0 Then Exit Function For x = 1 To Len(StringVal) Select Case Mid(StringVal, x, 1) Case "0" To "9" WorkString =...

I just come up with solution to view SQL in text box(Text11) Dim aa As String aa = cboYear.RowSource Text11.ControlSource = "=" & aa It is not exactly you need but you can submit changes in textbox and assign(force) a new SQL. If SQL contains String data type criteria this method won't work:(

Add in References MS ADO 2.7 Ext for DLL and Security Then paste code: Dim cat As New ADOX.Catalog 'Data base Catalog Dim tbl As New ADOX.Table Dim cnn As ADODB.Connection Dim rst As New ADODB.Recordset, lngCode As Long Dim strAccessErr As String Const conAppObjectError = "Application-defined...

Try to press F11 if you ever not disabled this.

Never mind. I already tested this issue. There is no conflict.

Hi everyone, Here is my question. If I use MS Office Developer Edition2000(run time version on my clients machine) and my application locates in Network directory , is it a matter that my user has MS Access97 or 2002 installed locally? Will conflict occure for them? Thanks.

Use Combo1.Column(0) for the first field in combobox.

I am aware how to play AVI file in Visual Basic. Is there a way to play AVI in MS Access2000. Thanks.

Then specify location for user individually. First, search "msaccess.exe" in MyComputer. It could be more than 1 if you installed MS Access97 and 2000 versions on the same computer.

Re: anyone have an example of how to layout the tables for a zip code autofill look up? 00000-9999;0;_

Private Sub cboYear_AfterUpdate() On Error GoTo MYERR Me.RecordSource = "Select * from AllYears where MyYear=[ENTER YEAR]" MYERR: If Err.Number = 2001 Then MsgBox "User Canceled" End Sub

Network guys should set up 1 group of users with the same rights(read,write) .It is enough in order to prevent users for deletion and share db file between users. But you as a creator/developer can have different rights included "erase"(allow to delete db file) and not being in this group.

Hi I think problem is that some of your user have 2 versions of MS Access database(Access97 and 2000) at the same time on the same computer. No need to compact or repair databes(this action just help to convert 97 to 2000)-that is why after all user can use converted database. All you have to do...

Assign value to textbox bouded to a field like txtFieldName=Last("fieldname","tablename")

Open table that you can see data, then use right mouse click. Choose "Unhide Columns".

What if you remove first "password" format from field property. You'll see a real passwords.