This could be caused by many different things. Did you receive any error messages? Has the problem repeated? What were you doing when this occurred? There are many questions to be answered. My...

only one field is displaying? if this is the case you need to add another listbox add to the loop

While dr.Read()
ListBox1.Items.Add(dr(2))
ListBox1.Items.Add(dr(3))
End While

took a quick, very quick look. to add the condition you need to finish the WHERE

cmd = New OleDbCommand("SELECT * from UMP WHERE ", cn)
'to
cmd = New OleDbCommand("SELECT * from UMP WHERE field...

Are you using textarea?

so you can change the table name in vs? i didnt think you could thats why i recommended sql management studio

you should see a button that says solved

did this problem get solved? if so mark it as solved so if others run into a problem then can see the solution and create another thread for a different problem

sorry about that take out the first order by srno and that should fix it

rs.Open "select srno, productname, qty, unit from mrtemp where req_no = " & strlistrequest & " order by srno", con,...

try changing the query to

rs.Open "select srno, productname, qty, unit from mrtemp order by srno where req_no=" & strlistrequest & " order by srno", con, adOpenDynamic, adLockOptimistic

button click

is there an error number with that?

need to add & " after strlistrequest

Do you already have your connection strings setup for the mdb? I will go with yes :)
are you sure that the search will only return one entry in the db? i would probably go with either a listbox or...

go here. http://www.vb6.us/tutorials/formating-dates-and-times-vb6
it gives different date formats and examples

Not sure if that is possible. Can you not install management studio express to make any changes to your DB?

in management studio right click the table you want to edit. you will see modify. click it. this will bring up the column properties. from here you can change anything you would like.

If you can create a partition on your HDD you can setup dual booting where you will be able to select what OS you want to boot into. Or if your computer has plenty of RAM you can setup Virtual PC and...

and this is how you reply to somebody trying to help. obviously other people have been able to figure it out. figure it out yourself.

not sure if this will help you much
http://bytes.com/groups/net-vb/356895-openfiledialog-problem

just to get an idea can you show your connection strings to both instances?

Primary key is the unique identifier of a row of data. like:
table Dogs:
dogid=1(pk)unique
dogname=spot
dogbreadid=5(fk)
age=3

dogid is the dog spots unique identifier in the db. dogbreadid...

you can send it through the address

<a href="yourpage.php?info=imageinfo">


then on your other page you can grab the info using

$info = $_GET['info'];

this will grab whatever info your...

looking in your db i noticed that you do not have any orders in February. This will be one reason why you cant pull anything from the first query. change the date to 6/2/2008 and BAM its full of data...

here is a long and hectic procedure available to restore the registry so that we can use System restore to roll back out system to the time when it was working fine !!
How to recover from a...

Do you have an example?
Not sure what type of situation you are referring to.

Missed your email question. I have used this in the past.


$emailcheck = $_POST['email'];
$check = mysql_query("SELECT email FROM users WHERE email = '$emailcheck'")
or die(mysql_error());...

Sounds like you got it right. I had ran into the same problem. I had created the random password and inserted that into the db as their password. Sent them a link including and identifier...

your welcome. would you mind marking this as solved so others will know the solution is displayed.

the reason you are getting this error is because all headers must be sent before anything is displayed. moving the php code to the top of the script may take care of your problem.

you are pulling from all rows in the db. your variable will only display the last rows info. but yes that should work for using that var later in the page.

would it be easier to only let the user select a date instead of insert? maybe change the textboxes to comboboxes and in the form load event do something like this:


Dim y As Date
y = Date.Today...

was no problem :)

i will agree with that. more secure the better if its being stored. didnt really think having a SSL setup was needed since it is a class project but if its live it is a must have.

you can store the data in the db but you definatly need to encrypt. i would suggest not even storing it personally. But that is just me.

ok i thought the pilotid was an int. so change the second query to:
[code=php]
$arrival = mysql_query("Select arr_airport from flight2 where pilotid2 = '".$row['pilotid1']."' order by...

The CPC912 is an aircraft type correct?
sorry its the other query i was needing. the second query and while loop.

can you post what you have for line 44? (the query)

give this a try. i added another query to pull the arr_airport by date below. its pretty straight forward.

$query = "SELECT firstname, lastname, pilotid1, pilotid2, COUNT(flight_time) AS flights,...

ok your grouping this by pilotid. this is taking the info from the tables and displaying the information in one row per pilotid. and you want this to display with more then one row per pilotid?

would it be possible to get a couple examples so i can insert into my mock db and test?
ok i got the data in. give me a few minutes to use this query