Search:
Type: Posts; User: munsworth
Search:
Search took 0.03 seconds.
-
The first book I ever read was in the Learn to Program series
by John Smiley. It's a great book for people with little previous
exposure to programming.
The order of the events really...
-
Change:
rpt.DataDefinition.RecordSelectionFormula = "Select * employee where empposition='"& "Programmer" & "'"'
to
rpt.DataDefinition.RecordSelectionFormula = "{employee.empposition} =...
-
In the .NET Configuration in administrative tools I added the
executable to the list of trusted assemblies. It also lets you
specify the permission level you want to grant it. For example,
you...
-
I figured it out, thanks.
-
I've got an executable that runs fine if it is located on my local
machine, but if I put it on a network drive and execute it I get
a security exception. Is there something I can do to solve this...
-
Dim var1 as String
Dim var2 as String
Dim var3 as String
Dim objItem as ListItem
Open File for Input as #1
Do While Not EOF(1)
Input #1 var1, var2, var3
Set objItem = Your...
-
You don't need a dataset to do any of that, but depending on what you are doing you may need one to store the data you retrieve from your DB.
As far as finding data, if you want a quick forward...
-
How would i go about wrinting a script that would generate an
HTML page with links to all of the mp3s on a given site.
Example:
On page one I want to specify a url http://www.--------.com
I...
-
-
Private Sub Command1_Click(Index As Integer)
Select Case Index
Case 0
'button command1(0) was clicked
Case 1
'button command1(1) was clicked
...
-
If the problem is that the file isn't being saved with the comas
and apostrophes, just change:
Write #FileNumber, ProductArray(iCounter, 0), ProductArray(iCounter, 1), ProductArray(iCounter,...
-
In the click event for one button, set the caption for another.
Private sub command1_click()
command2.caption = "Change Text Here"
end sub
-
WHat do you want to do?
Do you want to display it from within your app?
-
Amen! :)
It would also help make your code more readable if you created some functions or sub procedures to break up all that code in the one click event.
ex.
Private Sub...
-
What are you trying to do? :confused:
-
That code needs help. :eek:
-
You shou have code similar to this somewhere in order to access the fields on the report.
Dim crxApp As New CRAXDRT.Application
Dim crxRpt As CRAXDRT.Report
Set crxRpt =...
-
I don't see where you even open the report. What you posted is the equivalent of declaring a recordset object and wondering why you cant populate it with data from a database you're not connected to.
-
I've got a program that I wrote in VB 6.0 which accesses an
Access database and prints reports. The following code is
used to preview the report:
Dim acc As...
-
I've got a program that I wrote in VB 6.0 which accesses an
Access database and prints reports. The following code is
used to preview the report:
Dim acc As...
-
I have an Access 'make table' query which is run
when my application is first started. This table is
deleted when the program ends. Can I create
relationships between this and other tables...
-
I've got an access database that contains 4 linked tables.
I also have one "make table" query.
The access database itself is not password protected,
but the tables are.
I'm using this code to...
-
You could use this function:
If you want hours and minutes displayed just pass the
string "hn" as the interval and it will return a string formated
as x hours x minutes.
Public Function...
-
You can save a picture but you have to set the data type of the field to OLE object and convert the picture to a BLOB (Binary Large OBject)
-
Your problem is probably in all of the Quotes/Apostrophes.
Try using the Chr() function instead. Example:
uName = "abc"
pWord = "123"
sSql = "INSERT INTO WRITER (username,password)...
-
-
-
Private Sub Command1_Click()
Dim sSql as string
Dim db as Database
Set db = DBEngine.Workspaces(0).OpenDatabase("path to database")
sSql = "UPDATE tableName SET Field1 = "
sSql = sSql &...
-
You can use the DateDiff() function:
DateDiff("yyyy", DOB, Now())
Where the first argument is the interval you want returned,
the second argument is the earlier date, and the last argument
is...
-
App.Path is the path to your VB application, Data1.mdb is the name of the database.
If you use
app.path & "databasename.mdb"
in your connection string your database must reside in the same...
-
What's your question? It looks like you're trying to use ADO is this correct? What are you trying to accomplish?
-
Did you see my relpy to your other post?
http://www.vbforums.com/showthread.php?s=&threadid=216797
You can do it the same way just use a different SQL statement.
-
You should put a message box or a break before the If. . Then to see what values are really in the fields before it errors out. Also check to make sure both fields are text fields.
-
Each time your timer event fires set up a connection to the DB and run a query looking for the current value you have for the URL and date. If the query returns an empty set then insert your URL...
-
If you go to Tools/Analyze, Access will document your whole database for you. Also, if you open the relationships window then go to File, Print Relationships should be available.
|
Click Here to Expand Forum to Full Width
|