My guess is that a 'Materials' can have many 'MaterialRequisitionDetail' (1-N relationship).

Now, MaterialRequisitionOrder.requisition_no = 129 gives you a single 'MaterialRequisitionOrder'....

Something like that your code does seems to do. And what is the question?

To be honest, no :)

I was a bit lazy and didn't test what I wrote, sorry. Here's my previous code, slightly modified and with a bug fix:
Private InstNames() As String
Private InstPaths() As...

Lets combine what SCBWV wrote and arrays for "linking".

Use arrays to hold names in combo box(es) and actual filepaths
Private InstNames() As String
Private InstPaths() As String

Private Sub...

Hi smile4evr! I've been on holiday :) Have you solved your problem?

Your code is then ok. Assuming you do get only one record :)

Your code will actually display the last record found. Instead of the loop, check that the recordset is not empty and display only one (first) record. Add "Next"-button to the form and when the user...

Yes, a bit confusing. Without seeing the "big picture", I would allow user make the selection criteria in the first form. When user presses the button I would build a new SQL select statement with...

No, it's not possible.
If tCommand$
end if
is not a valid statement in VB6 so you can't get the code through the compiler.
Neither
tCommand = ".width <= 36"
If tCommand$ Then
wqty = 1
Else...

What is your "data report" and the DB where the data comes from?

QVeen is quite right, but basically it doesn't matter what is saved to DB. The original code works, if the saved data is read:
If RS("MyCheckField") = 1 Then
MyCheckBox.Value = vbChecked
Else
...

I don't see anything wrong in how you save checkbox's checked state to DB.
You do read this information back in to the form, right? You may have some error in how you read and set checkbox's state.

Hi Todor!
This is VB 4/5/6 (i.e. classic Visual Basic) forum. Post your question to DaniWeb's VB.NET (http://www.daniweb.com/forums/forum58.html) forum, you're more likely get your question answered...

Use parenthesis
Text3.Text = (3 ^ 1 + 3 ^ 2) - (3 ^ 0 + 3 ^ 1 + 3 ^ 2 + 3 ^ 3)

I'm not any MySQL guru. I use MySQL ODBC and the connection string:
"DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=test; UID=root; PWD=XXXX;"

If the problem comes from the...

Since rtb does not have a Justify property, you have to do it with API calls. Here's a one example VB6 - Justify text in RichTextBox (http://www.vbforums.com/showthread.php?t=275310) to start with.

Here's a slightly modified code:
Option Explicit

Public cn As New ADODB.Connection
Public cmd As New ADODB.Command
Public rs As New ADODB.Recordset

Private Sub removeMileDupes()
Dim...

I'm trying to re-produce your case.

Here's my simplified tables.
Temp-table:
USE [EditorTest]
GO
/****** Object: Table [dbo].[CASE_MILESTONE_TEMP] Script Date: 12/04/2008 10:35:36 ******/...

First, this is the VB 4/5/6 forum. You're coding with VB.NET which is a different forum in DaniWeb.

There's not a single, right solution. Here's one solution without any fancy UI, this more about...

You may try to ask that in MS SQL (http://www.daniweb.com/forums/forum127.html) forum. I think that's something you have to do at the database side.

A short answer: no.

There's a VB RezQ (http://www.vbrezq.com/). I haven't tried it. I highly doubt it can do what it claims to do and definitely I wouldn't pay $149 for a piece of s**tware.
And...

What is the exact error message that you get? What error number you get from oConn.Errors(0).NativeError (oConn being your connection object)?

A few things come to my mind straight away. Are the...

Like you said, there are attributes to hide folders. And also to unhide them.

If your purpose is to "hide" information, I suggest using an encrypted file. You'll find encryption algorithms and...

Here are the things to consider:
- what does an elevator do?
- how do you represent 4 floors in VB (a clue: you need a data structure)

And the problem is??? And where should I look at???

Ok. Here's a snippet from the code I'm using now:

Set oConn = New ADODB.Connection
ConStr = "PROVIDER=SQLOLEDB;Data Source=XXX; INITIAL CATALOG=XXXlab; User ID=XXX; Password=XXX;"
oConn.Open...

Then I'll refer to my first reply. At the point of error, what values does
oConn.Errors(0).NativeError
oConn.Errors(0).Description
have? oConn is your connection object. Also what type of...

You must double double quotes inside double quotes:
LoadCommand = "(load \""S:\Tools\Tools_Subfolder\MyStuff\test.txt \"")"

I see. I wasn't aware of that.

However, the article suggested a solution that should solve the problem. This is, if I did understood it right. Update MDAC (latest version is 2.8) and use a...

Do you need adorset.Move 0 ?
However, you do have a connection object. Check from the connection object which is the native error and description
oConn.Errors(0).NativeError...

Why don't you use
MkDir "C:\TempDir"
Ok. If you want to do it hard way:
Private Declare Function CreateDirectory Lib "shell32.dll" Alias "SHCreateDirectoryExA" (ByVal hwnd As Long, ByVal pszPath...

You have to loop the original string:
Private Function InsertChar(ByVal StringIn As String, _
ByVal CharToInsert As String, _
ByVal InsPosition As Integer) As String

Dim NewString As...

Hi! If your question is solved, please mark the thread as solved. Thank you!

Are you taking course on Visual Basic? AFAIK connecting with RMI or socket has something to do with Java :-O

smile4evr said there are also combo boxes. Could the validation fail with combos?

No. None of them is a complete solution and nobody can give one without seeing the whole code.

There may be a just a little spot everyone's missed. Can you give more details?

But few things to...

Use arrays or collections. Maybe even dictionary might work in that.

But maybe a simple array will do (pseudo code):
Const TotalOptions = 5600
Dim GrossPay(TotalOptions) As Single
Dim...

As far as I know "01/01/2008 23:00" and "02/01/2008 01:00" are valid UK dates.

You also need to convert string to date
d1 = CDate(AdHocData.Recordset.Fields("StartDate") + (" ") + _...

Here you are:

Dim LoanDate As Date
Dim LoanDays As Integer
Dim DueDate As Date
Dim DiffDays As Long
Dim Fine As Single
Dim Total As Single

' When loaned

Assuming you can convert start and ending times to valid dates, use DateDiff with "n" which gives you minutes:

Dim d1 As Date
Dim d2 As Date
Dim DiffMinutes As Long

d1 = CDate("1.1.2008...