vb5prgrmr

Is the drive mapped? Then DriveLetter:\Path\File.Extension NO? Then use a regular UNC path format. Good Luck

Use the DateAdd function... [code] ?now 7/10/2009 9:26:48 AM ?dateadd("d",-1,now) 7/9/2009 9:27:13 AM [/code] Good Luck

Use the data form wizard with the ODBC option. Then to get rid of the ODBC DSN see [url]http://www.connectionstrings.com[/url] for a DSN Less connection. Good Luck

All of the above is possible, just remember that you need to manipulate the enabled and interval properties correctly. Good Luck

Then you have no way to uniquely ID the record which means you could get erroneous results if you have any kind of parent child relationship. Good Luck

Call this my own little quirk but I like to check all three indicators when returning a recordset. (I also for readability like to do it long handed.) [code] If rs.RecordCount <> 0 And Rs.Bof = False And Rs.Eof = False Then TxtPosition.Text = rs.Fields("Position").Value Else TxtPosition.Text = vbNullString End …

You will have to either create arrays to hold the individual values or you can simply test for them via if statements. Good Luck

Not that I have done this but I read somewhere in some forum that you should change the image field to a binary field and load the binary data into it. Now, as for asking for full code, that is one of the fastest ways in which to have your …

I've answered this already, have you seen that reply?

I find CR to be more flexable especially when it comes to program maintence.

[code] If data="no active" then send to table 1 strSQL = INSERT INTO Table1... ElseIF data="active" then send to table 2 strSQL = INSERT INTO Table2... EndIf [/code] BTW: You should never use the END statement to stop your program. Good Luck

[QUOTE=cguan_77;909678]try this: [code] Sub xx() Dim txt As String Dim x As Variant Dim i As Long txt = "10,11,12,13,14,15,16,17,18,1,2,3,4" x = Split(txt, ",") For i = 0 To UBound(x): Next i MsgBox "There are " & i & " numbers in your text area" End Sub[/code][/QUOTE] Ahhh.... Why not …

One table at a time. First Parent table then child table records. You can use the .AddNew method if you have a seperate rs for each table or use an insert into statement and execute it with the command object. Good Luck

So then you are using this as your mask? [code] MEB.Mask = "##/##/####" [/code] And you have a problem with the way the control displays this in the standard way that people have come to know?

Check out [url]http://www.shrinkwrapvb.com[/url] Good Luck

If CR is installed correctly on your system and you are actually using VB 6.0 and not VB.NET then you should be able to find the references under Project>References. For the control, if any, right click on toolbox and select components. Use their help files to see the examples on …

I have requested this thread to be closed because it sounds to me like you are wanting to hack the username and password off of a users/multiple users systems. [b][u]THIS IS AGAINST THE LAW![/u][/b] If this is [b]not[/b] your intention. Please start a new thread with a better explanation of …

That all depends upon if you allow those fields to default to their default values or not. As for changing those default values lets see your table creation code...

Look up INNER JOIN in either SQL's Help files or Access's help files Good Luck

The simplest way I know of is to use a mask color to hide portions of a form but allow the controls to still show. I'm sure if you search vb6 transparency or vb6 form transparent/transparency at you favorite search engine, you will find plenty of examples. Good Luck

To add items to a list box you use the additem method... [code] List1.AddItem "MyString" [/code] To make your list box allow multiple selections set its multiselect property to true on/in the property box. To run through the list to test which one(s) have been selected. Use a for loop... …

The simple answer is... [code] Printer.Print Text1.Text [/code] Good Luck

This has been discussed in many a forum and to get to the short of it. NO. You cannot guarantee that some user who has bought a license will not install your app on several machines. Well what about hard drive serial numbers? They change if you format them. How …

Hmmm... I thought we were in the VB Classic forum!!! Yes, just opening the IDE and creating a program alters the registry of the machine the program was designed on. Oh, you mean when you install the program? Yes, when you install the program on another machine there will always …

IsDate anybody??? Good Luck

I think we are going to need a better explanation of what you want to do, because from reading your OP I can think of several things and some of them seem to be contrary to what you little sentance says... So are you wanting to create a wizard like …

See the following in VB's help file on the index tab... FreeFile Function Open Statement Input Function Line Input Function Print Statement Close Statement Good Luck

very vague question, perhaps some code or a further explanation of what you mean. Good Luck

To [b]display[/b] version number... [code] Option Explicit Private Sub Command1_Click() MsgBox App.Major & ":" & App.Minor & ":" & App.Revision End Sub [/code] Good Luck

Look up tables [B][U]tblBadges[/U][/B] iBadgeID (AutoNumber, Primary Key) iBadgeNo (number) [B][U]tblEmployee[/U][/B] iEmpID (AutoNumber, Primary Key) vFName (text) vLName (text) operations table [B][U]tblBadgeStatus[/U][/B] iStatID (AutoNumber, Primary Key) iBadgeID (Foreign Key) iEmpID (Foreign Key) bActive (Boolean T/F Active or not) iRecycleStatus (number) dIssueDate (Date) which can also double as your history table …

Okay, if one table is a listing of ID badges and the other table is a log table of when that badge is used (login/logout) then yes, that sounds like the correct database structure. Good Luck

seems like there are plenty of resourses out there... [url]http://search.yahoo.com/search?p=vbscript+active+directory&fr=yfp-t-501&toggle=1&cop=mss&ei=UTF-8[/url] Good Luck

Unfortuantly, as CRMatthews pointed out Sleep will lock up the entire application but what they did not say is that if done for a long enough time, the application will become unresponsive in task manager and any kind of attempts by the user to interact with the program will only …

Start new standard exe project Goto vb's ide menu Add-Ins > select add-in manager. Look for VB 6 Data Form Wizard, highlight > Look at frame in bottom right corner with caption Load Behavior > select Loaded/Unloaded so check mark displays in check box. > OK VB IDE Menu Add-Ins …

Please post something else that cannot contain macros that can hurt our computers... Thanks

You can use the Printer.Print "some text", or the shellexecuteex API with the print keyword and notepad should handle it for you... With first suggestion if you do not know how to read and write text files, look up the following in vb's help on index tab... FreeFile Function Open …

Search for ADO Turorial VB6 on web or site. Also search this site for my handle (vb5prgrmr) and Data Form Wizard. Good Luck

Start new standard exe project Goto vb's ide menu Add-Ins > select add-in manager. Look for VB 6 Data Form Wizard, highlight > Look at frame in bottom right corner with caption Load Behavior > select Loaded/Unloaded so check mark displays in check box. > OK VB IDE Menu Add-Ins …

See my reply, post #4 in this thread... [url]http://www.daniweb.com/forums/thread181952.html[/url] Good Luck

App.HelpFile = App.Path & "\" & HelpFileName.hpj/chm Good Luck

Here are a couple of ways and by no means are these the only ways... [code] Option Explicit Private Sub Form_Load() Dim M As Integer, D As Integer, Y As Integer Dim S As String, LastDay As Date M = Month(Now) D = Day(Now) Y = Year(Now) If IsDate(M & …

See post #4 in this thread [url]http://www.daniweb.com/forums/thread181952.html[/url] Use ODBC option for the Data Form Wizard and then goto [url]http://www.connectionstrings.com[/url] to change it if you want Good Luck

DataGrid1.ReBind ??? Good Luck

Table structure... [U]tblBadge[/U] iBadgeID AutoNumber iEmpID Number Foreign Key dTimeIn date/time dTimeOut date/time [U]tblEmployee[/U] iEmpID AutoNumber vFName text (25) vMI text(1) Optional allow blanks/nulls vLName text(25) Then, see my reply in this thread post #4 [url]http://www.daniweb.com/forums/thread181952.html[/url] Good Luck

I take it you are using the DriveListBox, DirListBox, and FileListBox, well maybe not the FileListBox but with the DriveListBox it is as simple as this... [code] Private Sub Command1_Click() MsgBox Dir1.Path End Sub [/code] Good Luck

Yes. At least is sounds like you can if this is a parent child relationship, meaning that table2 contains the foreign key from table1's unique ID field, or for some reason you are using two tables to contain unique information. Look up INNER JOIN. Good Luck

see.... [url]http://www.shrinkwrapvb.com[/url] to see if any of that code can help you. Good Luck

[code] DataGrid1.Columns.Add 2 [/code] Good Luck

It is possible but the results that you will get will not be in an easily readable format. Some decompilers break the code of an exe down to assembly, or C. While some say they break it down to VB code, you will not get the original code. What you …

FileCopy "Path File Name Of Source File", "Path File Name Of Destination File" Good Luck