I have a form that is bound to a table with two fields: StartTime and EndTime. I need the user to select the Date and Time for each. Rather than having a textbox for the user to have to type the date and time in (that is asking for problems), I thought to create a nice little interface.
First...
Hey diwin!... I came across your question looking for an answer to DTPicker myself. DTPicker doesn't have a "default value" that you can put formula's (=Now() ) in. It leaves a bit to be desired.
Anyway, it does have a "value" property. Check to see what yours is, my bet...
I have recently installed E2K on our Small Business Server 2000 Server and it is running about 90% OK (going for 100% here).
Right now, we have two virtual SMTP servers: "Default Virtual Server" and "Client Access Virtual Server". I have OWA going great... but to get both...
I Administer 11 Retail stores. Every Store has 1 computer running Win 2000 Pro and 3 computers running Win XP Pro. They opt to use MSN Messenger and Hotmail for their messenging. But 90% of the time they open Hotmail in IE 6.0 on the Win XP machines, it hangs. The IE window shows no active...
OK... I seem to have a pretty good grasp of VB now... but I am a bit confused on how programmer's know how to DECLARE Subs and Functions, and know what the functions do.
For example, the user32.dll... how do I get the functions found in the library and what the functions do? kernal32.dll...
I have a vb 6.0 program which I am trying to create reports on an access 2000 database. I have downloaded CR 8.5 which I have created a report. I do not know CR very well, but I am learning. One obsticle is that CR's help feature does work with IE 6.0 and I cannot figure out how to...
I am running a Terminal Server on Small Business Server 2K and I have 10-11 users connecting at a time. I have 20 CALs installed on the server (5 come with SBS, I added 15), yet I get the following warning message every few minutes:
"License usage for a product licensed in per server mode...
OK... the OVERWRITE EVENTS AS NEEDED keeps the error message from coming up, but I would like to diagnosis and fix the problem. The Error that keeps building up is:
Event Type: Error
Event Source: Perflib
Event Category: None
Event ID: 1008
Date: 8/22/2001
Time: 12:46:39 PM
User: N/A...
Help!
I do not know W2K Server well enough to diagnosis this problem. I keep getting a message that the Application Log is full and must be cleared. When cleared, the log fills up within minutes. A Comma-delimited file of the log can be viewed/downloaded at...
Here is the SQL:
SELECT [tblPSales].ID
FROM [tblPSales]
WHERE ((([tblPSales].StoreID)=[Enter ID]) AND ((Month([Date]))=Month([Enter Date])) AND ((Day([Date]))=Day([Enter Date])) AND ((Year([Date]))=Year([Enter Date])));
Store ID (under Enter ID) is a number 1 thru 9. I loop through enter the...
Yes... the form is the only thing using it.
I could enter the full path of "txtDateVal" into the query and get this one to work (which is actually what I did) but then I am stuck on another, similar query.
It is one in which the parameter value is the counter within a loop. Can't...
Well Pez... I get a different error now...
"Run-time error '2741':
The expression you entered as a query parameter produced this error: 'The object doesn't contain the Automation object 'Enter date.'' "
When I run the query, a window comes up with "Enter date" and an input...
I have tried a number of different arrangements of the quotes... could you please post the appropriate syntax, outlining where you believe the quotes should go and if they are double or single quotes?
About the error message, the double quotes surround the entire error message, the single...
I must have the syntax messed up or something. I have the following code in a Form:
intNum = DLookup("[Num]", "[qryDateExists]", "[Enter Date] = " & txtDateVal)
The query works great... but everytime I run the DLookUp, I get an error stating:
"Run-time error...
I am not familiar with setting up a W2K Pro machine to setup incoming connections; however, I did run into one problem concerning win98 VPNs vs. W2K VPNs. W2K uses PPTP and L2TP as their VPN tunneling protocols, while Win98 uses VTP tunneling protocol and it seems they cannot work together. W2K...
Yes... that seems to work when I have the INDEX (an integer) of the Form I want to hide, but not the NAME (a string). Is there anyway to use the NAME (vs. INDEX) in a variable to hide a forn or get the INDEX from the NAME held by a variable so that the above technique can be used?
Thanks again...
Is there a way to hide a form when you have the form's name stored in a variable? Obviousely, this doesn't work, but maybe this will help you understand:
strFormName = "Main Form"
strFormName.Visible = False
Thanks,
Chris
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.