jwshepherd

from What I can Tell, You are only pulling one column that looks like it just list the reportID's or the PropertyID. I usually use a datatable to pull information going in to a combo box, so I can Have one Column to display( displaymember) and the ID Column "hidden" …

We all need help from time to time. What are you trying to do?

try using format(variable,"######")

I would use Audacity with the lame dll

Wow, I think you are making this way more complicated than it should be. Most of this can be done with batch files easier than with vb. 1. First off you haven't shown how to get the computer name. echo COMPUTER: %COMPUTERNAME% >>txtfile.txt 2. have the getmac command ( Assuming …

I'm sure your vigilance has helpa number of people, Thanks.

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

Views are basically a few tables group together by a server side query. [QUOTE]select * from X where Car=’Ford’ and Color=’Yellow’[/QUOTE] would return only Ford = Yellow [CODE]select * from X where Car=’Ford’ or Color=’Yellow’[/CODE] would return [CODE]Alfa Yellow Volvo Yellow Ford Yellow Ford Blue[/CODE] You can create a view …

Mad Max colum name = id data type = int down at the colum properties box change identity to yes identity seed to what number you want to start using identity increment to how much the seed is incremented each time.

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 all of the information you will want to be able to print out. Checks, reports, …

Just log into the router and turn off filtering. Simple

Service pack 6 would fix this problem and add the libraries techniner said. You do not need to change the format to 97. The access 2003 default database is created as an access 2000 database anyway.

Would it not be easier to use ? enum("COMPUTERNAME")

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 and clicking on it is simple enough, we will need the location(s). Specifying the "START" button …

[QUOTE=dina]Hey there everyone! I'm just about to start a database assignment for uni but don't know whether to use MS Access or MySQL. I am an adequate use of both but does anyone know the advantages and disadvantages of them??? Thanks ;)[/QUOTE] I usually do my initial layout, design and …

make sure your database connection string is for remote access and not limited to local.

start | programs | Microsoft Visual Studio 6.0 | Microsoft Visual Studio 6.0 Tools | Package & Deployment Wizard

change the resulting variable to type double

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

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

make up an address, in the US that is.

check the code snippets to the left there isone in there

The exe is compressed zip. Seems safe enough. I see if i can get the error.

We would probably have to see some form_load code before we could even start to make a judgement. Are you Sure that's where it is failing?

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 ' Sets focus to the txet1 textbox sendkeys "COLOR" 'Types COLOR in the text1.text end sub

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

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 better either upgrading to sql where you can set security …

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.

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. [code] image1.picture =loadpicture("c:\vbrox.bmp") image1.picture =loadpicture(text1.text) image1.picture =loadpicture(strImage) [/code]

[code]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 end if end sub[/code]

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 use only one of tehse under each correct button rs.MoveFirst rs.MovePrevious rs.MoveNext rs.MoveLast

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

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 append a -0 to all of the part numbers with no revisions. Either …

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

make sure the stretch property is set correctly

it would help to have the function name. basically you would use the function name and pass the variables to it. {FunctionName} lptr,iwrite

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

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 will try to help you through some of the hard parts.

I would probably shell it out. [code]shell "net.exe time \\server"[/code]

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.

another good resource is looking at code from other people. Try [url]www.planet-source-code.com[/url] for snippets of code and complete applications.

Not quite sure what you mean. If I read it right you might try not populating the textbox until the form has focus.

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.

txtMN.Text = dtaMember.Recordsource = "SELECT Name FROM Mem_Mast WHERE Mem_Code = txtMC.Text" needs to be changed to include the variable text txtMN.Text = dtaMember.Recordsource = "SELECT Name FROM Mem_Mast WHERE ((Mem_Code) = '" & txtMC.Text & "');" = ' " & txtMC.text & " ' ) ; " That's equal, …

Ar eyou still needing help?

Put two textboxes, one label and one timer on a form . Copy and paste [code]Dim i As Integer Dim starttime As Date Private Sub Form_Load() Text2.Text = InputBox("Enter Time", "Set Time", "3:40:00 PM") Timer1.Interval = 1000 'set to one second Label1.Caption = Time End Sub Private Sub Timer1_Timer() Text1.Text …

Try using different widths of lines

[url]www.planet-source-code.com[/url]