|
hi to all.
i am beginner in vb.net. i was reading a tutorial to make address book in vb.net but that tutorial was using vs.net 2002 in which dataform wizard is available. I am using vs.net 2005 and unable to find such sort of wizard. Please guide me how i can show data from data base to seperate fields in form using wizard or through any graphical process instead of coding.
thx
|
|
|
|
|
You can get an introduction by watching the "Forms over Data Video Series" here[^].
|
|
|
|
|
can i catch any windows focus in vb ?suppose i am running any vb application & i have clicked any windows apps then can i check in vb that focus is on any other window?my os is win 2000.
rahul
|
|
|
|
|
You'd have to implement the "CBT Hook" to get this information. There is no event or class in the .NET Framework that will do this for you. All you have to do is Google for "VB.NET CBT Hook" to find some examples. Warning! There is very little documentation specific to VB concerning hooks. You'll have to translate code from either C++ or C# to get it working.
|
|
|
|
|
thankx for solution.also we do the same by getactivewindow api.
rahul
|
|
|
|
|
That'll give you the active window, but not the active control window.
|
|
|
|
|
I was wondering how a you can check for a version of abode reader from vba in excel. I am using a 8.0 plugin version on reader in a form and when a user without the 8.0+ version installed on their machine is getting an outofmemory error if they try to run it. thanks.
Regards,
Oz
|
|
|
|
|
Yes - find out by looking in the registry.
Below is an example of how I find the location of the Access 97 exe by looking at the registry.
This is vbscript and the good news is that you can use vbscript within vba:
<br />
Set SysVarReg = WScript.CreateObject("WScript.Shell")<br />
accessLoc= SysVarReg.RegRead ("HKLM\SOFTWARE\Microsoft\Office\8.0\BinDirPath")+"\msaccess.exe"<br />
What you will need to look for is to see if the following exists:
"HKEY_LOCAL_MACHINE\SOFTWARE\Adobe\Acrobat Reader\8.0"
If it does then you know the user has version 8.0
I hope this gives you some idea of what to do.
You always pass failure on the way to success.
|
|
|
|
|
I am using Crystal Reports in my application I made using Visual Studio.NET.
I installed my application on the client machine, with all the DLLs
required(added the merge modules), the engine and the rest. When I start my
application and, from it, try to open up a report I get an exception "Query
engine error: C:\WINDOWS\Temp\temp_*******.rpt" with some wierd numbers
instead of *******. Can anyone tell me what the problem is here and how to
solve it. I am running the application on Windows 98.
|
|
|
|
|
windows 98? hmmm....how much memory [RAM and paging file size] does that machine have? Crystal reports and your application could be hogging on the system resources; making it impossible for the query to run successfully. Try the installation on more superior client machine.
---------------------------
Both optimists and pessimists are important in technology. The optimist invented the aeroplane; the pessimist invented the parachute.
Regards,
Hesbon Ongira
Nairobi, Kenya.
|
|
|
|
|
I have the codes
dim dataadapter as new oledb.oledbadapter("Select * from ITEM where dateAcquired between '9/20/2004' and '9/20/2007'
and it doesn't work.
What seems to be the problem?
gt
|
|
|
|
|
Impossible to say
1 - what does 'doesn't work' mean?
2 - what happens when you plug this code directly nto the DB
3 - what does the rest of your code look like ?
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Try the SQL statement in Query analyzer (SQL 2000) or Design a query and switch to SQL View in Access to see what are the results.
|
|
|
|
|
I tried it and it has an error which is criteria mismatch. What does it mean?
|
|
|
|
|
gt2 wrote: dim dataadapter as new oledb.oledbadapter("Select * from ITEM where dateAcquired between '9/20/2004' and '9/20/2007'
for date's you can use the convert statement (for sql server)
Select * from ITEM where dateAcquired between convert(datetime,'9/20/2004',102) and convert(datetime,9/20/2007,102)
or for access
select * from ITEM where dateacquired between #9/20/2004# and #9/20/2007#
hope it helps
If my help was helpfull let me know, if not let me know why.
The only way we learn is by making mistaks.
|
|
|
|
|
convert(datetime,'9/20/2004',102)
What does 102 mean?
|
|
|
|
|
|
Using VB.net 2003
TXTBEGIN,TXTEND are indicate Datetimepicker
Dim DATEBEGIN, DATEEND As String
DATEBEGIN = TXTBEGIN.Value.Year & "-" & TXTBEGIN.Value.Month & "-" & TXTBEGIN.Value.Day
DATEEND = TXTEND.Value.Year & "-" & TXTEND.Value.Month & "-" & TXTEND.Value.Day
dim dataadapter as new oledb.oledbadapter("Select * from ITEM where dateAcquired between Between '" & DATEBEGIN & "' and '" & DATEEND & "'"
|
|
|
|
|
Not a good solution to begin with, and it won't work with an Access database.
|
|
|
|
|
if logged in successfully, i have the code me.close and form1.show.
The problem is the form will not show and it terminates the program.
if the code is me.hide and form1.show, form1 will show but when i close it the loginform will not.
What should be the code when closing the loginform?
gt
|
|
|
|
|
The most logical thing is for your main window to be your start window ( and for it to have a more logical name than form1 ). Then, it shows the login window, and if login fails, the app closes, otherwise the main window is shown when the login window closes.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
|
Do NOT use SMS speak in the forums. It makes your posts difficult to read. You've got a full 101+ key keyboard in front of you, use it.
|
|
|
|
|
how do i delete all the items from the listview?
gt
|
|
|
|
|
You remove the item from the items collection.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|