I believe there is limited security in msaccess for what you are wanting. I don't believe it is with ado or dao though I think it is ADOX (Microsoft ADO Ext 2.8 For DDL and Security ). YOu would do...

Text1.Text = MonthName(Month(DateAdd("m", -1, Date)))

the dtpicker seems to work best for most of my applications.

It looks like in the CopyMemory function the ByVal is the length of the data passed from destination to source or vice versa. Check this value debug.print byVal in the function to see what it...

use instr.

if instr(text1.text, "little") Then variable = yes

shell "cmd.exe /c"

will get you to the comamnd prompt. Shellexecute will give you more options and handling and return values, but if you just need the prompt, there you go.

mediaplayer1.filename="intro.mpg
should be changed to
mediaplayer1.filename=app.path & "\" & "intro.mpg"

I ctually tried it. It might be my version of windows media player, but this did not...

it will go whereever the cursor is located. If you want someone to push a button and have "COLOR" input in a text box, you must first change the focus.

Private Sub Command1_Click()
text1.setfocus...

What object are you using for the ip information. There should be a method there to calculate the bytes used.

Option Explicit

Public Sub Command1_Click()
If Command1.Caption = "SAVE" Then
Command1.Caption = "ADD"
'Put Save commands here
Else
Command1.Caption = "SAVE"
'put ADD COMMOND BUTTON Commands...

Public Sub Command1_Click()
if command1.caption = "SAVE" Then
command1.caption = "ADD COMMOND BUTTON"
'Put Save commands here
else
Command1.caption ="SAVE"
'put ADD COMMOND BUTTON Commands here...

Dim Conn As ADODB.Connection
Dim rs As ADODB.Recordset
Set Conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.open {Connection String}
rs.Open "Select * FROM TABLE;", Conn, 3, 3, 1
...

public sub command1_Click()
Me.PrintForm
End Sub

Create a new colum for the revisions part numbers. I would also add a last modified date colum as well. Then the sql query will allow use to differentiate the two types of numbers.

Or you could...

Put either a command button, image, or make it a hot key and teh use Me.PrintForm to print the form.

for just pictures, you can add textbox or variable values to the picture object to load a new picture if you use the correct format.

image1.picture =loadpicture("c:\vbrox.bmp")
image1.picture...

make sure the stretch property is set correctly

Debug.Print TextWidth("XXXXX"), TextWidth("iiiii")

it would help to have the function name.
basically you would use the function name and pass the variables to it.

{FunctionName} lptr,iwrite

public Sub Die()
dim f as form
for f in forms
unload f
next
end
end sub

the languages are very similar witha few differences. Try planet-source-code.com

What program are you wanting it to "click" on?
What operating system?
Will you feed it the co-ords for the clicks or will it be prerecorded?

While moving the mouse to a particular location...

I would probably shell it out.

shell "net.exe time \\server"

That's correct. Global Variables defined in a mod use the global prefix. Global Variables defined on a form use public. That is about the only difference.

update inventory set location=NULL where x=y

ctrl-Z will undo most operations in a text editor. other wise you will need to create an array to hold the previous changed information until the users are satisfied and submit the text.

an Undo operation on what?

Thats' a large project. If you are working on this alone and are fairly competent in vb you are looking at about six to twelve months programming.

Start with the database and the reports. Gather...

Well you have your choice. You can use VB to create any program you want, from games to complete hospital accounting systems to virus, to security analizers. Decide what you want to create, and we...

try using this instead.
it will unload all forms and then end all processes.
dim f as Form
for each f in forms
unload F
next
end

txtMN.Text = dtaMember.RecordSource = "SELECT Name FROM Mem_Mast WHERE ((Mem_Code) = '" & txtMC.Text & "');" = ' " & txtMC.text & " ' ) ; "

needs to be seperated
dtamember.Recordsource = "SELECT...

post the sub where you are getting the error and we'll see if we can figure it out.

free component call vbsendmail.dll makes sending mail with attachments very easy.
Ithink you can find it here.

http://www.freevbcode.com/ShowCode.Asp?ID=109

Public Function...

might try form2.setfocus . POst the source and we'll see what we can do.

Try using different widths of lines

Ar eyou still needing help?

www.planet-source-code.com

try using the text1.change() event That way it is automatically change whenever you type something

public Sub text1_change()
form1.label1.caption = trim(text1.text)
end sub

same as using ado and ms access change the connection string :

"Driver={SQL Server};Server=BMC;Address=xxx.xxx.xxx.xxx:1433;Network=DBMSSOCN;Database=dbPos;Uid=SQL;Pwd=sql"

put this on a form. six command buttons one row on top,one textbox below buttons,one webbrowser window below textbox


Private Sub Command1_Click()
WebBrowser1.Navigate Trim(Text1.Text)
End Sub...