hi, im trying to view my php page on the browser on iis and i got this error : call to undefined function mysql_connect(). im not sure why this happened, tried googling but found only solution on...

bapu435, the answer is in the zipfile provided by choudryshouvi

i have a global variable that is of type date.

public r_date As date


i use it in my program and once i'm done with a single operation,i'd like to flush away the value inside the variable.if...

hi.i need to use form names as i want to refer certain controls in certain forms to other forms.i want to retrieve the form name and store it in a variable.
for example :
i declare a variable
...

i think i might as well give details about my tables.

1.master table(reservation)
fields : reserv_id, reserv_date,cust_name, cust_contact, fac_id.

2.child table(TF)
fields :...

hi.attached are my table structure with relations.i have tried buliding query using both tables that i need to use,connect it to adodc and try adding data but it still does not work.
table...

i've made correction on that part
if check8.value = vbChecked but i'm getting the same error which is
run-time error
you cannot add or change record because a related record is required in table...

my database consist of 4 tables and all tables are related following the primary and foreign key.i followed the instruction but still stuck at the second table.my codes are:

With Adodc1...

thank you for the reply choudry but how do i implement that,can u explain to me?im currently using two Adodc to refer to both tables.

With Adodc1
.Recordset.AddNew
............................

hi.i have problem adding record into access database because these tables i've created has relationships.i need to add record (from a single vb form) into 2 different tables. these 2 tables refer to...

i got a sample program from the net that uses requery and it works fine in my login form.that's why i thought it is crucial when making queries(not knowing the real flow of it).i've altered my codes...

an addition:
i tried making queries with only one criteria which was

with Adodc2
.RecordSource = "SELECT time_id FROM TF WHERE fac_id = " & fac_type & ""
.Refresh
end with

there is a...

i tried implementing the method given but still my query returns no result.:(
anyone care to have a look at this problem..?i've attached my codes here..

i had :

With Adodc2
.RecordSource = "SELECT time_id FROM TF WHERE fac_id = '" & fac_type & "' AND reserv_date = '" & booking_date & "'"
.Recordset.Requery*
.Refresh


but i get an error that...

thank you very much for the infos.there's another thing i'm curious about.
usually,when we make an sql statement in vb,for an example :-

Adodc1.RecordSource = SELECT * FROM Student WHERE...

i still can't get it right..i wonder is it actually possible for the query to retrieve values from variables in vb at vb run-time..:(

debasisdas,
i tried but it keeps giving me a syntax error.could something be missing?do u mean to write :
fac_type as ' " & fac_type & " ' and
booking_date as ' " & booking_date & " '?

i faced the same problem 2.using the name 'user' as a table name doesnt work.i tried searching for ways to overcome but failed.n now i know why.thanx evryone;)

thank you 4 the help choudry but what im trying to do is the reverse.instead of creating an sqlstatement in vb, i'd like to create query in access by using variables declared in vb.let say i code sql...

hi all, i have problem creating queries in access.this is because i do not know how to call the value from a variable in vb into the query in access.
let say in vb i've created :

Public...

i got it.thanx a lot plusplus;)

i have another thing to add.i want to detect whether date clicked falls on weekend or weekdays so that different form will be loaded.how do i retrieve "day" from the date clicked so i can check...

hey, i think i'm using it,the monthview you said.i used this :

Private Sub MonthView1_DateClick(ByVal DateClicked As Date)
booking_date = MonthView1.Value 'add values into a global variable for...

i now realize that my main problem is : "i don't exactly know how to use it."
do u mean that by just placing the calendar control on the form, i can straight away use them without having to program...

hi, i need help on calendar picker.i placed a calendar control on a form.once i click on any date,i want the date value to be inserted into fields in database.i tried searching for the codes bt what...

plusplus,i already found the answer.thank you very much 4 ur concern.;)thanx again.

plusplus, thank you for your effort to help.does it really point to the current record because it didn't seem to work.maybe there is an error in other parts of the codes..

n choudhuryshouvi,thank...

hello, i neeed help badly.my problem is i want to retrieve the record that has just been added.
let say:
step :load RESERVATION form->fill in details->click the save button->load RECEIPT form
as...

veena. i hv gotten it. it was actually a mistake on the arrangement of codes.thanx so much for your help n concern.really appreciate it.
thanx again :))

veena, thanx for the reply.but i am currently using adodc to connect to the database.my codes are as follow:

'if inserting values from textbox,it will be...

hi, im having problem with my current project which is to insert values from variable into fields in access database. i know how to insert values from textbox into access but im having problem using...

hi, im a student and im very new with vb.i am currently doing a project.i want to use calendar to show whether reservation on specific dates have been fully booked or not.i plan to make the date...