|
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 )
|
|
|
|
|
I tried using .remove() method. i also tried using .removeat() but it has an error.
|
|
|
|
|
How do i remove all the items form the listview?
gt
|
|
|
|
|
Collections usually have a Clear() method you can call.
|
|
|
|
|
i hv developed one small software using VB 6.0 as FrontEnd and MS-Access as BackEnd which stores customers records. the Key feature of software is dialing customer's mobile number or land line number and storing corresponding comments.When I dial number through code using(0,)eg ,9834567876 it shows invalid number and if i dial same number through phone dialer directly it shows valid number and i m able call to another person.I am using (0,) for EPBX purpose.Because when i directly dial widout sing(0,) I am able to speak with recipient party the problem is with EPBX only
code
|
|
|
|
|
It could be that your dial isn't pausing long enough after the 0 in the string, or there is an issue with interfacing your modem with the PBX system.
Your problem really has nothing to do with VB.NET itself.
|
|
|
|
|
hello all,
I have some work with me over the Vb Accelarator's Explorer bar.Well using the earlier written code the explorer bar is initialised once and could be used by changing its visible property. The explorer bar is made on a picture box. The problem is the new explorer bar strip which i have made on the existing one's is not visible when the property is set as true. Please help me out with this.
Thanx in advance
Neema
|
|
|
|