o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

An easy question for All VB Masters -

Hi there, i need some help with this problem....


SELECT * FROM [Date] WHERE (date.date = #datevar#) AND (Date.RoomId = Roomvar)

datevar = date()
do...
make date
create SQL
if record count <> 3 then
add date to list
end if
loop until (365 dates checked)

I am trying to a rooms availablity for a date, if the room is free then add it to a list box.

The method listed above is really slow because you have to keep generating a record source for each date.

I you have any ideas then let me know...

Rohan

 

An easy question for All VB Masters -
Hi there, i need some help with this problem.... SELECT * FROM [Date] WHERE (date.date = #datevar#) AND (Date.RoomId = Roomvar) datevar = date() do... make date create SQL if record count <> 3 then add date to list end if loop until (365 dates checked)


Help me out -
Hi friends I have four masters in my database. Addition, Modification are common among various application. so what i thought of doing is to write class modules for each master maintenance and compile into to activex dll. all these process went fine but when i use the dll and add


VB 6.0 Upon Exiting a Program (Are you sure Message Box) -
Hi to the VB masters. I'm using VB 6.0 and I know this is an easy question, but my textbook doesn't cover it. I was sick the day our professor went over it. He wants us to create an |Are you sure you wish to quit?| message box connected to the Exit command button with Yes and No


which would you prefer -
hello! i know there's a lot of programmer masters out there and you know guys i awe you that's why i have question for ya! which would you prefer? a. VB6 (Sp6) b. VB.NET c. C# please,explain why did you opted that programming language because i want to know if i will leave


which would you prefer pls. answer. -
hello! i know there's a lot of programmer masters out there and you know guys i awe you that's why i have question for ya! which would you prefer? a. VB6 (Sp6) b. VB.NET c. C# please,explain why did you opted that programming language because i want to know if i will leave


C ++ -
I have a question for those API masters.... Can you use the API with C++ or Borland C++ Borland?


:':For all of you with "Easy Questions":.: -
I don't get this!!! I see all these people post threads with titles "Easy Question" or "A Stupid Question" and so on. If it's really that simple and stupid, why are you asking it!?! I bet 80% of the questions asked can be found easily on the net... but people pr


Help me for Menu caption -
Hai! I am working with MDI form. there i am using menu, it consists of Masters, Transaction, Searches, Ledgers, Reports and Exit are the menus. I have above 10 Menu Items under each option except Exit menu...(eg: Masters menu consists of Account Master, Product master, Gr


This is an easy one =) -
Hi! I know its easy 4 u guys to answer this question considering your expertise in VB.. anyway, here's my question.. how do you make an html document run using Visual Basic? that's all THANKS!!


Easy question about filesize -
an easy question: How do I get a filessize from the path in a text box? Thanks in Advance! -Lumin


A very easy question -
Hi: I know this could be an easy question for you but, i'm a begginer.... ok, how can i close the same window which my program is running with VB Script??? ยก^_^ \/


Easy Question for MDI Forms -
This should be an easy question, but right now I'm stumped. I'm tryin to keep track of which forms are open in an application. Usually, I could use 'If Form.visible Then' to find out if it is open or not but if the form is a MDI child this line actually opens the form. I can't think


Is this so easy vb can't do it -
I am a newbie - so forgive me if I am doing it all wrong! I have come across a question so easy that try as I may, in any language, I can't do it! Can it be done in VB - or is it "too easy"? With a knife, I cut a potato with plane cuts right through. Each plane cut


Here an easy question -
I've never worked in VB before, C++ is my thing! So i know this is an easy question, and a dumb one but who do i format my output so it will skip to the next line rather then being on the same line. Trust me i've tried to find the answer, i've tried what i do in C++ but can't get it!


Easy VB.NET and ADO.NET question -
I have an easy question, how do I advance the record set in ADO.NET when using the tableadapter? I have tried : Me.CustomerTableAdapter.Fill(Me.DatabasetestDataSet1.Tables(*put integer here*)) But only when the integer is 0 do I not get an error. I know for a fact there are multip


Any Chess Players Out There -
I just renewed my membership to the Internet Chess Club. I let it expire and haven't played any internet chess for something like a year. I go through phases when I'll play a lot and then I'll just not play at all for a while. Even when I'm not playing any chess I like to solve che


EASY<EASY<EASY! -
Howdy! OK an easy question I have two text boxes on a form Text1 Text2 if i write something in text1 then press enter to set the focus to Text2 I get a BEEP! If I use the TAB key I get no beep, But If I use sendKeys Command for the TAB button, I get the BEEP again. HOW D


EASY Question for you -
This should be a very easy question for all of you however cos i am new to vb i am stupid and therefore do not know. What does API mean / stand for???


Very easy question I think - Please take a look. -
Sorry, I think that this is a very easy question, I just want to know how you can get the file size of a file using vb code. Any source would be great Thanks Hurgh


[resolved] Easy question (Linear Functions) -
Hi all, Glad I found this forum, it looks great. I've got a small problem which I imagine is pretty easy for you lot by the looks of things. Any help would be greatly appreciated. I am trying to come up with a mathematical formula to map the following numbers: 1 to 4 2 to 3


beginner's question -
Hi, I have around 2.5 weeks to come out with something by using VB and Access and Excel. Although I have read up and wrote some easy coding with VB last year, the memory doesn't flow into my head as easy as i thought it was. My question is... when I create 3 text boxes, what sett


Another Stored Proc. question! -
Hi VB masters! In my database I identify customers by their name and their birth date. How can I set the sql server to check that two customer cannot have the same name and birth date??? Stored Proc? Trigger? Sql script?


Directory and file question -
Hi all, my question may be very easy; excuse me for that. I finished one of my apps and I am making the setup files. Now my question, is there an easy way to find a directory if what I have is only the file name or the folder name? To be clearer I want to install a database that is nex


Message for MartinLiss -
Hi MartinLiss, Thank you very much for your help. It works great. But I still have one problem, wonder if you can help. Three listboxes list1, list2 and list3. list1 contains first name and last name "John,Smith". I would like to transfer first name to list2 and last


Status bar easy question! -
I know this is an easy question, but, how can I put a status bar in a form?? I thought that I will never have to use this before!!


easy question to answer -
hi, i am not a professional, my question is as easy as having a piece of cake. i am using DAO for access, and i want to relate my fields(form) to my tables, i have written everything r!(...) = me."....", but i dont know what else put there to link it, i've heard that i shoul


really easy question about strings -
hi all, this one is really easy. i have a string MyStr$, and i want to remove from it the first 3 lines and the last 2. thanks..


here an easy EASY question for someone -
I want to make the textbox show *'s for a password, how do i do that >=), mua ha ha


Easy Question (Application Path) -
Hello, I know this can be done, and its a easy question. In a program Im making, I would like to set the files I want to load in a seperate folder. The folder is in the same directory as the program. So Instead for example typing in C:\Program\Mine\Pic.JPG I could do something l


Worst movie of all time... -
For me its a toss up between Masters Of the Universe, and Flash Gordon.


Easy MDI form question! -
There's gotta be an easy way of doing this! I've written a small app as an SDI form. I now see that the first form needs to bring up another form - so I need to convert the first form I wrote to be an MDI form - is there an easy way of doing this? Cheers, Tarique


recommend c# books -
hello, Currently i program professionally in vb 6 (for about a year now)and i am studying java as part of a masters course. (for the past3/4 months) My work have .net and i figure it would be cool if i start developing in c# (mainly because the companies other developer is using


A useful question I'm sure anybody'd like to know the answer too... -
Ok, ya know how some applications have their own menus embedded in some of Window's standard menus? Take Winamp for example: If you have Winamp displayed in the Taskbar, and you right click on its button, you'll get the standard Windows menu (close, restore, maximize, etc.). But you a


Another easy Tab question...probably l guess -
rjlohan fixed my last question, and this one is probably pretty easy as well. Have a 5 tab control on my form. Am currently modifying tab 2, when l run the application the tab control always shows tab 2 as current and not the first tab. Why is this? Thinking the answer is obvious, a


What is a Class -
Hi All, Guess by the Subject you knew this is a NEW Bei... I have read MSDN's Class vs Modules, VB for Dummies ( ie Robin Moss), and MSPress MCSD book looking for a simple and comprehendable answer to this question. I think I have a vague idea but why would I use as class ?? If


[2005] Possibly a n00b question. -
Hiya all at VBForums, I am currently starting out doing some VB at my school in an ICT (IT) class. I was just wondering if it was possible (if so easy, if easy could someone else do it for me/mod an already made script) to make some thing to do this: If 'program.exe' has CPU usag


Easy Screenshot Question -
Heya all! I have a really simple question and I can't believe I don't know how to do it... I wrote a simple VB program. I need to take a screenshot of a few of the forms in action so I can incorporate them into a PowerPoint Presentation. What is the best way to do so?? I


User Control -
For you developers out there, I am sure this is an easy question. But for a newbie like me, well>>>> I am creating for the first time a program with VB6. I would like to add 2 user controls ( Date & Calander). These controls are not currently in my registry,


Easy question but... -
I have an easy question but im unable to find an answer so... I am using DAO data controls to link to my database. I was wondering how i can change data in one of the fields without using a data bound text box. I want to be able to take a value from one text box and put that value into


[2005] Several (I think) Easy things to do in DirectX (Help) -
Ok, I have a few questions, I have no idea how to use any of DirectX's functions, so I have to ask a bit until I understand Question 1: I need to change the color of the background, how can I do this (I've tried this): Question 2: How do I load a model from my computer? Qu