Visual Basic :: Webbrowser Problem/limitation?

DB Limitation And AD
Hi all,
I am currently evaluting a small project that needs to displays appropriate text to different groups of users by using ASP, the access right and group information will be obtained from Microsoft Active Directory. And I need a DB to store the text to be displayed for different user groups.
The questions are:
1. I am choosing between SQL server or Access as the DB server, does anyone know the limitation of Access in terms of connections or filesize? any suggestions?
2. Anyone knows how to get access right data from Microsoft Active Directory?
Thanks.
Joey

SQL Limitation
Does anyone know of a method to overcome the 99 Limit on ANDs in SQL Select Statement as outlined in

http://support.microsoft.com/default.aspx?scid=kb;en-us;209761

I need to overcome it using visual basic code

THANKS

Limitation
Hello,

Can anyone tell me how can restrict my software to install on different computers.
for example if i have installed my program on one computer it should not install on any other computer.
is there any registry to be modified.
if anyone having any example plz send here.

thanks
Zubair

ADo Limitation
I am calling a stored procedure which has output parameters and a recordset coming back. How can I collect both of them in VB.

dbCmd being a command object with the parameter objects and dbRs being a new recordset.
If you do a

set dbRs = dbCmd.execute

then it just creates the recordset and does not provide the values of the parameters.
If you do just a dbCmd.execute, then it provides you the parameters and not the recordset.

How can I retrieve both of the information.

Seletion Limitation
Hey everybody!

I would like to limit the area of selection, as it is now the function appears on a click in any cell. How do i limit the selection to only cells with content?
This is the code i am using:

Sub Worksheet_SelectionChange(ByVal rTarget As Range)

Dim wb As Workbook, FileName As String

ButtClicked = 0

UserForm1.Show vbModal

Select Case ButtClicked
Case 1
FileName = rTarget.Value & "inköp.xls"
Set wb = Workbooks.Add("c:vbinköp.xls")
Case 2
FileName = rTarget.Value & "logistik.xls"
Set wb = Workbooks.Add("c:vblogistik.xls")
Case 3
FileName = rTarget.Value & "kvalitet.xls"
Set wb = Workbooks.Add("c:vbkvalitet.xls")
Case 4
FileName = rTarget.Value & "utveckling.xls"
Set wb = Workbooks.Add("c:vbutveckling")
End Select

wb.SaveAs ("c:VB" & FileName)

Set wb = Nothing

End Sub

Limitation Of Text Box
I do a huge conversation with the server and send the report to a text box.
It seems that there is a limitation with text box, sine it stops at a point and don't show the rest of report.
However, I have some questions:
1- Is there any control except RichTextBox with no limitation?
2- Doesn't RichTextBox control have any limitation?
3- Is it possible to disable the context menu in the RichTextBox when right clicking on it?
Thanks everyone

256 Character Limitation
I'm trying to copy from one sheet to another and have found that there is a 256 character limitation. Is there a work around for this. The way I'm copying is doing a past special to allow manipulation of the data at a later time. Any ideas would be helpful.

Hex Function Limitation
Is it possible to get the hexidecimal equivalent of a number greater than 2 ^ 32 / 2 - 1 in VB?

MS Calculator will but VB's Hex function seems to have that limit.

ie Debug.Print Hex(Val(4294967296# / 2 - 1)) is OK but any number higher returns with an Overflow error

VB TextBox Limitation
If one RIGHT CLICKS in a VB TextBox Control, the cursor position in the text doesn't get modified. For example, if you right click in MS Word etc, the cursor position (the text caret position, more explicitly) gets modified. Is there a way out to modify the cursor position on right clicking in a standard VB TextBox Control? Please Help as soon as possible. Thank you in advance

Listview Limitation
can someone tell me what is maximum data that listview can list at one time.
thanks

Limitation Of Access
I just wanted to know if there is any kind of limitation that access has in number of recordss in each table?

or its that i can put as many as i like

because the program that i am writing will have about 40 to 50 records each execution, so will it stop functioning at any point or will it keep on storing data?

Thanks in advance

Mdi Form Limitation
I realised that the mdi form does not support the 'key press' event. Is there anyway that i could do something similar to the keypress event in the mdi form?

Recordset Limitation?
I'm trying to get data from SQL server, everything is fine, there is just one problem:
one column in the table is of type text
when testing the column for NULL value the result is OK, but then when I try to set a variable to the not NULL value, i always got an error

here's my code:

Dim rsFarby As New ADODB.Recordset
Dim conFarby As New ADODB.Connection
Dim strCode As String
....
conFarby.ConnectionString = "driver={SQL Server};" & "server=serverdb;uid=user;pwd=password;database=database"
conFarby.Open
rsFarby.Open "SELECT * FROM AtrakcieTbl WHERE IdAtrakcie = " & intIdAtrakcie, conFarby
...
If Not IsNull(rsFarby("AtrakcieHTML_1")) Then 'here is everything fine
strCode = rsFarby("AtrakcieHTML_1") 'now it's NULL???
End If
....

is there a problem with the text data type, recorset can't handle it or what?
anyone??

Event Limitation
i am using the mouse up event. When i add additional code an error is reported which if a save the file on longer occurs. The event is large, and i was woundering if there was a limit to the amount of code you can have for an event.

Tom

Limitation Of MS Access
What is the limit of Access database everyone has experienced?

Observation of various small projects based on MS Access Db at work, records above 200,000 or 50MB seems to be more prone to corruption.

what is the prudent limit (not the theoretical one) everyone keeps their access database within vis-a-vis record numbers?

ListBox Limitation
hi all,
does anyone know of a way to limit listbox to a certain amount of elements? (when reaching the limit, new element will replace the oldest one).

thanks a lot!

Avi.

Combox Limitation
I have about 110,000 items to load into the combo box for the user to select/find. The combo box only shows half of the items on the drop down. But when I typing the last item, the data shows up on the control. Does anyone know how to solve this problem or there is limitation?

Textbox Limitation
I have 64299 characters in my text box and I need to add more, but it won't
take anymore.

I am displaying lines of data from my database and need about 300 more
bytes.

Is that the limit VB6 will take?

Is there a way around this?

I don't want to use richtextbox as it is too expensive.

Thanks,

Tom

Exe Size Limitation
Hi. Is anyone aware of any limitation that exists on the size of an executable produced by VB6? My project has been evolving for years, and constantly growing, but due to certain design decisions way back, it is not a trivial task to split into several exes or dlls. I know that this problem should be tackled, but in the meantime I'd like to know whether I'm close to the limit, if any. My exe currently stands at close to 12Mb.

Limitation For IN Keyword Of SQL ???
Hi

I am writing SQL in VB code, where a table is to be updated.

There is one list of members and records of selected members are to be updated. For that query will be something like as follows

UPDATE MemberTbl SET Address = xyz, Tel = 9999, etc.
WHERE MemberID IN (m1, m2, m3, m4, ---------- and so on)

Now it is not possible to know how many members will be selected.

IS THERE ANY LIMITATION for IN Keyword ???

Pls. kindly let me know ASAP.

Best Regards
Mahesh

Time Limitation
Hello,

say i wanted put a time limitation on a demo using the current date on the computer that its being used on.

If somebody changes the date on their computer after the start of the tmie limitation does this affect it at all?

Also is this a save way, using the date f proteccting your prog ?

thanks!

Access XP Limitation
How many User supported by MS Access XP Database?
Maximum Records?
Maximum Disk space?

Limitation On Immediate Window
I just noticed in another thread the question of whether or not one can increase the limit (around 200 lines) on the immediate window. I've occasionally found this annoying myself and think it's important enough to start a new thread/topic.

Can we increase the number of lines?

Thanks for your time.

Character Limitation
I have a combo box and I want to limit the entries to 10 characters. I also want to have capital letters. Here is my code. Any ideas?Thanks.

VB Code:
Dim OldText As String Private Sub Combo1_Change() If Len(OldText) = 10 Then Combo1.Text = OldText Combo1.SelStart = Len(Combo1.Text) ElseIf Len(OldText) <> 10 Then OldText = Combo1.Text End IfEnd Sub Private Sub Combo1_KeyDown(KeyCode As Integer, Shift As Integer) If KeyCode = vbKeyReturn Then Call Command1_Click End IfEnd Sub Private Sub Combo1_KeyPress(KeyAscii As Integer) Char = Chr(KeyAscii) KeyAscii = Asc(UCase(Char))If (KeyAscii >= 65 And KeyAscii <= 90) Or (KeyAscii >= 97 And KeyAscii <= 122) Then If Len(Combo1.Text) = 10 Then MsgBox "There is a 10 character limit to your word. After all how long a word can fit on your screen???", 64, "Error" End IfElseIf KeyAscii = 8 And Len(Combo1.Text) = 10 Then For i = 1 To Len(Combo1.Text) - 1 y = y & Mid(Combo1.Text, i, 1) NextEnd IfEnd Sub

.INI Size Limitation.
Eventually it had to happen - I've run into the 64K .INI file size limitation. Does anyone have a cls module I can use to simulate the Get/WritePrivateProfileString APIs to overcome the size limitation?

Tnx, Bob.

COM Port # Limitation
Hi I would like to know if there is any limitation of creating COM port (16) using VB6. Anyway to get more than 16 of COM port? Thanks!

SQL String Limitation
I am trying to run a qry but my string is longer than 256. When I change the string and define it as String * 300 it is still only 256 in length and it cuts the command off.

Any ideas?

VB' Limitation On Controls
If i remember correctly, VB only allows 255 controls on a form. (Arrays count as one)

Winsock Limitation?
Hiyas,

I'm using Winsock to retrieve some data, which is only one line of text. However, I had some trouble getting the entire line (it was long).

At first I could only download 354 characters, iirc. The latest attempt was about 406 characters, I think.

Is there a limit to the amount of characters Winsock/VB can get on one line of a string? If there is, how do I get around it? =) And if not, what could be wrong?

Please help, this is really anoying!

-Git

StretchBlt Limitation?
I have found what seems to be a limit to how much stretching or shrinking the StretchBlt api can do. The same thing happens for the standard image control, so it seems to be a limitation of windows. For example, stretching an image that is 397 wide x 263 high by a factor of more than about 7.8498 results in no image being rendered at all. Resizing an image that is 1200 x 900 down below .035 or above 3.9994 has the same effect. I guess I could do half the stretching/shrinking and store the result temporarily, then perform the rest on that new image, but what about images that are really huge or really small? I don't see any relationship between the original size and the limits. Any ideas?

Character Limitation
Hello!

I'm working vith VB in Ms Access and I have run into a problem.

I have a command button "createmail" that opens the mail window in Outlook with default values as follows:

createmail.HyperlinkAddress = "mailto:" & Me![address] & _
"?subject=" & Me![subject] & _
"&body=" & Me![body]

The problem is that this is limited to 255 characters. I would like to create a standard template (in the body part) that is longer than theese 255 characters. Is there anyway I can do that?

Very thank*** for replies!!

/Le Goldorak

MS(H)FlexGrid Row Count Limitation?
hi there,

does anyone know how many rows a flexgrid can handle? i have a recordset with about 5000 records and there are only 370 added to the grid....

fast help needed!

thanks a lot.

btw: i didnt find any information on this on the net! is that possible??

here is the code:
----------------------------------------------------
i% = 0
Do Until rs.EOF
i% = i% + 1
rs.MoveNext
Loop
Debug.Print "Records in RS: " & i%

Set grdNamespaces.DataSource = rs
DoEvents

Debug.Print "Records in Grid: " & grdNamespaces.Rows
------------------------------------------------------
results:
Records in RS: 5071
records in grid: 370

thanks for the help!

matthias

How To Overcome FSO DeleteFile Limitation
C:OldFiles contains aKilly.exe and someother 10 files. aKilly.exe contains the code FSO.DeleteFile "C:OldFiles" which doesn't work because of the limitiation of this command as discribed in MSDN as
The DeleteFile method stops on the first error it encounters. No attempt is made to roll back or undo any changes that were made before an error occurred" The first error here is that a file (aKilly.exe) cannot delete itself.
OK, The question (what code is better) or how can I make aKilly.exe (when activated) deletes at least the other files (we do not know their names) in the folder C:OlderFiles, there where aKilly.exe is located?

Thanks alot for any clever respond

Limitation Of Formula Length In VB ?
Hello

I am trying to execute the following code but I get an error message

Run-time error '1004':

Unable to set the FromulaArray property of the Range class

[vb]

Range("F4").Select
Selection.FormulaArray = _

"=IF(SUM(('Break Details'!R2C1:R86C1=""Open Break"")*('Break Details'!R2C3:R86C3=""NYC"")*('Break Details'!R2C9:R86C9='MIS NYC'!RC[-5]))= 0,""-"",SUM(('Break Details'!R2C1:R86C1=""Open Break"")*('Break Details'!R2C3:R86C3=""NYC"")*('Break Details'!R2C9:R86C9=MIS NYC'!RC[-5])))"

Have any of you experienced the same issue ?

Any help would be appreciated

Thanks

Bypass Command$ Limitation ?
Hello all,

I'm creating a program that mimics the old W98 powertoy "SendTo". My App is added to the Send To right click menu option, then it offers to copy or move all selected files to another location.

My problem occurs when too many files are selected, it looks like the command line run on a "overflow" and windows sends a message saying "files not existing or not reachable".

Do you know how to bypass this limitation ? Or maybe how to get the list of selected files in Explorer ?

I used the GetCommanLine API, but the limitation is still there.

Thanks

TextBox Limitation Question...
Hi, I can't find any info on RichTextBoxes. I know the text propety of a regular TextBox, with the multiline property set to true, is limited to 32K.

What is the text property limit in a RichTextBox?

Thank you,
Rel

Limitation Of Parameters In Functions
Hi,

I am just wondering, is any visual basic functions has a limitation of parameters you can pass.

For example:

Private CreateReport(ByVal ID, bayval tID .......) as boolean

.. The Code

end function

Thanks

User Access Limitation
Currently i have 3 tables in my access databse, the relationship looks like this:

Staff--(one to many)--Staff/Course--(many to one)--Course

So basicaly, my system invovles a meber of staff chsoing a few courses they wish to partake in.

I am making the fron end in VB using ADO connection and i was wondering if it is possible for me to have a log in screen where the person can enter his/her username and password, and then can ONLY choice courses using their name.

For example, when someone wants to chose a course, i want the the course code to be filled into the course/staff table, and the staff id will be automaticly enterd.

How would i go about doing this???

Also, when would i need to close my connection?? right at the end when closing, or after each form has shut, then open a new connection when another form is opened??

Thanks alot

Variable Precision Limitation Help
Trying to implement a gammaln routine found in numerical recipes in VB6. This is to greatly speed up my program so I do not have to call the Excel function...but I cannot enter in their constant values or even variable values and their code is probably 10 years old. e.g.

They have one line where they set

ser = 1.000000000190015

when I enter this, VB automatically changes this to

ser = 1.00000000019001

I've tried double and variant for variable types, but I think it is something else that's recognizing it and cutting it off. Any ideas? Any work around?

Thanks!

Combo/list Box Limitation
List box control or combo box control has one limitation that it can add only 32767 no. of items in it.
because it's index is of type "Integer"
thus, anybody knows to overcome on this limitation ?

Access Field Limitation
hey,

I was wondering is there a way you can get rid of the field limitation in access????

well each field can only hold 255 charactors is there a way i can hold more than this in access

cheers

Also please take a look at my other thread

http://209.120.143.185/showthread.ph...hreadid=180549

cheers again

Toolbar Limitation Questions
Using a toolbar, can you make the buttons just have text. Without the space for a picture to go. Similar to having a command button on the control (which isn't what i want unfortunately).
What seems to be happening is i get to put the text onto a button in a toolbar, but there is still a space on the button where an image should go.
sorta like

________
|.......Text|
|_______|

Heh, thats pretty much it.. (the fullstops are spaces it wouldn't let me put in just spaces)
Any ideas how to get it look like this

______
| Text |
|_____|

Ok that one looks a little more crap but you get the idea. I don't want the extra line under the "Text" (but it was easier to "draw" like that).
Any ideas? have i missed something? I've looked at nearly everything in the property pages, and had no luck.

BW

Get Pass Timer Limitation
Thanx for reading my thread...

When using the Timer.. The time interval value is between 0 to 65,535.. is there any way to get the timer event to fire between 0 to 7,200,000??? Cause i want it to fire every 2 hours or less?? Suggestions would be appreciated! =)

VBA -- Limitation To # Of Events Per Object ?
Hi,

I have noticed that there are time when some of the VB events simply don't seem to work.

Such as when I have code for textbox.exit() , and then attempt to use textbox.getFocus(). Even though the exit() event still works, the getFocus() will not take, or will take untill i restart the program.

Is there some underlying rule concerning how many events can be used per object? Or, is VB just real unpredictable with this ?

Limitation On VB-project Size
Is there a limit in expanding a VB-project? My compiled project already reached 4920 kB. I found the following about controls but nothing about the max size for compiling :

Project Limitations

A single project can contain up to 32,000 "identifiers" (any nonreserved keyword), which include, but are not limited to, forms, controls, modules, variables, constants, procedures, functions, and objects. Note that the actual number of identifiers is limited to available memory.

Variable names in Visual Basic can be no longer than 255 characters, and the names of forms, controls, modules, and classes cannot be longer than 40 characters. Visual Basic imposes no limit on the actual number of distinct objects in a project.

VB6 String Length Limitation?

I am building a SQL string using the following method.

A = string data (Lots of string data)
B = lots more string data
C = lots more string data

Then

SQLcommand = A & B & C

When I display SQL, part of the C string is not displayed. If I delete data in the A or B string then more of C is displayed. This indicates to me that string variable in VB6 has a length, which makes sense but I can't find out what that length limitation is.

So I guess the question is how do I make a really long string to use as an SQL command.

I have run out of ideas and perhaps knowledge.

Thanks.

Gary

VB6 Data Filesize Limitation
Hi,
when creating a data file the max. filesize, under VB6, seems to be 2GB.
Is that correct and if so, is there a way around that?
Any help would be appreciated.
Thx,
Peter

Listbox Limitation Problem
Is there any way to have more than 32768 items in a listbox control.

We use a textbox along with a listbox to search for items in the listbox while typing(like help index page) using a Win32 api call. And this technique is only works with listbox control. Is there any workarounds to achieve this functionality with more than 32768 items??