Hi guys, thanks for replying to my thread. Anyway, I got another problem in my query. Im created a VB function that will return the value of TRUE if a particular time range does not conflict with the existing data. Assuming this is the data:
SchedFrom SchedTo
7:00 8:30
9:00...
You can try this logic below:
SELECT * FROM ServicesAdrian-Jxn
UNION
(SELECT * FROM ServicesAnnArbor)
UNION
(SELECT * FROM ServicesBattleCreek)
UNION
(SELECT * FROM [ServicesBayCity-Midland])
The logic here is to separate the SELECT statements from the UNION by using(). One more thing, my...
I want to know which is the best way to create a SQL statement in MS Access to query the Time range value.
Table : LOGTIMES
Sample: I got two fields that is used for storing the schedule (SCHEDFROM and SCHEDTO) and both are of the DATETIME data type
Suppose this is the schedule of an...
Hi, peepz!
I'm using VB6 how will I set the Microsoft Data Report designer (the one included in VB and not Crystal Report Designer) to display the details in Landscape format.
If you suspect your hard drives are failing better test those drives into another machine. If your drives will be successfuly accessed into the other machines then your problem must be because of the power supply unit.
I'm planning to create an attendance monitoring system, assuming my client bought the swipe barcode scanner already:
1. What are the next steps that I need in order to integrate that barcode to my VB app? Do I need additional OCX/DLL to read the barcode?
2. How will I know which symbology to...
Hi, Doug!
Thanks for the reply. I have a follow up question, assuming my client bought the swipe barcode scanner already:
1. What are the next steps that I need in order to integrate that barcode to my VB app? Do I need additional OCX/DLL to read the barcode?
2. How will I know which...
I'm a VB programmer planning to develop an attendance monitoring system that uses barcode. I haven't developed any application that uses barcode so could you please tell me what are the steps that I need.
a. Their ID has a barcode in it already - how will I know which type of symbology code to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.