Posts
 
Reputation
Joined
Last Seen
Ranked #4K
Strength to Increase Rep
+0
Strength to Decrease Rep
-0
100% Quality Score
Upvotes Received
2
Posts with Upvotes
1
Upvoting Members
2
Downvotes Received
0
Posts with Downvotes
0
Downvoting Members
0
2 Commented Posts
0 Endorsements
Ranked #2K
~7K People Reached
Favorite Forums
Favorite Tags

21 Posted Topics

Member Avatar for Halbo
Member Avatar for lover99509

[quote=WaltP;241275]I think we're getting away from the original question, which was Doesn't this mean:[INDENT]I have a number in a text box. How can I tell if I need an [I]Integer[/I] or a [I]Long[/I] when it's converted from ASCII to binary? [/INDENT]Or am I interpreting this wrong?[/quote] How about trying the …

Member Avatar for cool beans
0
3K
Member Avatar for jliu66

Where do you import the data from? Is it from a database? What database? Also you are mentioning that the volume is huge. Give an approximate number of records, you are trying to import or export.

Member Avatar for vb5prgrmr
0
188
Member Avatar for six888

[QUOTE] if i didnt click anything and close the open window = its error to my application if i click a file and click cancel = its error to my application [/QUOTE] These two errors can be fixed by the following condition FilNam = Me.CommonDialog1.Filename If FilNam =False Then Exit …

Member Avatar for six888
0
238
Member Avatar for td5223
Member Avatar for td5223
0
198
Member Avatar for Church

In VB by default all variables will be passed by reference unless you explicitly pass it by value (using 'ByVal' keyword). I think you better use a public variable defined in a common module.

Member Avatar for Church
0
106
Member Avatar for jtwister

If the user can select more than one email address, its better to use a list box. You can use <SELECT multiple> <OPTION></OPTION></SELECT> tags to achieve this.

Member Avatar for jtwister
0
83
Member Avatar for roopeshnp

WAN is a wide area network such as Internet. so you may want to make your application, a web application. But if you want a stand alone application that connects to database over the internet, then you need to have a domain name or static ip for your database server.

Member Avatar for yello
0
58
Member Avatar for nuBudDy
Member Avatar for zawpai

I can two problems with your code. 1. There is no End Sub for the sub routine ' Private Sub cmdRectangle_Click()' 2. In the function ' Public Function NewPointOnRectangle' you have defined a variable as 'ByVal y2 As Data'. If this is a user defined type you need to define …

Member Avatar for yello
0
114
Member Avatar for Yomet

Using the following API function you can get it!! [CODE]Private Const ABM_GETTASKBARPOS = &H5 Private Type RECT Left As Long Top As Long Right As Long Bottom As Long End Type Private Type APPBARDATA cbSize As Long hwnd As Long uCallbackMessage As Long uEdge As Long rc As RECT lParam …

Member Avatar for tzatziki
0
1K
Member Avatar for qulit
Re: time

Exactly what do you want to know? :confused: You want help on how to do something in vbcode? or you want somebody to implement all your business logic in vbcode?

Member Avatar for hopalongcassidy
0
147
Member Avatar for macy2323
Member Avatar for mimi_breeze

If you are talking about a client server kind of application, you can run the vbprogram on your machine and keep the database on the server. If you really want to run the application from the server machine, i. You can log into server using "Remote Desktop Connection" and execute …

Member Avatar for hopalongcassidy
0
125
Member Avatar for jagpreet

rs.open "SELECT C2 FROM Table_Name" C2R1 = rs("C2") rs.MoveNext C2R2 = rs("C2") compare C2R1 and C2R2 Hope this helps.

Member Avatar for jagpreet
0
119
Member Avatar for jimwall80
Member Avatar for laxman_project
Member Avatar for laxman_project
0
88
Member Avatar for plusplus

Try this query. adobau.RecordSource = "SELECT Liegenschaften.name,Liegenschaften.address,tblbau.date FROM Liegenschaften INNER JOIN tblbau ON Liegenschaften.Rimo_Liegnr = tblbau.Liegenschaft"

Member Avatar for plusplus
0
104
Member Avatar for Qpido

[QUOTE]Me.lstPrijs.AddItem (sheet.range("h5"))[/QUOTE] Change this to Me.lstPrijs.AddItem (xlSheet.range("h5").Value)

Member Avatar for Qpido
0
167
Member Avatar for hawisme000
Member Avatar for yello
0
127
Member Avatar for nuBudDy

If you are writing vbcode in the MSAccess module (access macro), then you can access the variable from vb. Also one more thing to be noted here is the data type of 'fac_type'. If it is an integer type you don't need to wrap the double quotes with single quotes …

Member Avatar for kehar
0
163

The End.