you must make multiple tables and use the relationships to connect them. make use of foreign keys, etc.
Also the other option "the error message you get. click help at the bottom. it will explain about your "maxfilelock" <---something like this" what you have to do
is to change the maxlocks on...
i want to add a column to my access table using Visual express 2008.
can anybody show me how to refference my connection, adapters, datasets and update the table?
example code will be appreciated.
cheers
I think i know what you are trying to do.
listing unique values in a query, right?
the criteria is values which have a count >0
so it will look somehting like
criteria: = [row].[value].(count) > 0
i think..
???
I dont know if you preffer SQL, but just to add for your help, here is my code.
Although this one will change your source table, so
maybe you'd be better off using the SELECT IIF statement like pbaldy said
This will work only where ="0010" and change it to "0099"
Help with WMP10
Private Sub WindowsMediaPlayer6_ScriptCommand(ByVal scType As String, ByVal Param As String)
Dim Player As WMPLib.WindowsMediaPlayer
Dim AtName As Object
Dim AtValue As Variant
Dim i As Integer
Dim Dbs As Database
Dim Rst As Recordset
i = 0
AtName =...
Hi Guys. im new on the site. Looks like im going to love it here. CAnt wait to begin.
What brought me here is a little runtime problem ive been having. I have suspected my terminal as "Zombie" but i cant proove it. anyhow if noone is wrewritting my runtime, maybe it is actually my coding. so...