opie
Last Activity: Jan 3 '08, 07:46 PM
Joined: Nov 8 '07
Location:
-
I figured out part of the problem. It seems to only happen on pages that I used an ADODC. I also installed VB 6.0 that I used to create the program and it seem to fix the problem, but I can't install 6.0 on every computer that this program will work on. Any Ideas on a fix? -
Runtime error 91
I created this program on Vista using VB 6.0 with Access as the DB. When I created the executable and was trying to use it, on a XP machine, it gave me two issues. The first problem was it was missing the MSADODC.OCX file which I got and I also downloaded VBRun60sp6.exe.
Now I am getting Runtime error 91 and cannot figure out why any ideas? -
I have looked through the post several times. I cannot get this to work after about a week of working at it off and on.
It work fine when I insert the the exact date as the recordSource as shown below.
But when I try to refer it to a form that is still in memory (I have not unloaded the form) it gives me a syntax error. Now I am using MS Access Syntax...Code:SELECT * FROM tblLog WHERE EventDate = #12/7/2007#
Leave a comment:
-
ADODC by date problem
I am trying to move through records in a table using the ADODC tool. But I want to move through those records that occur on a specigic date, a date that was selected on a calandar using another form.
I was using the following code and I cannot get it to work.
Any Ideas?
Thank You in advance.
RecordSource = SELECT * FROM tblLog WHERE EventDate = #Forms!EditEntr yByDate!calLog# -
Great! Worked perfectly. Thank YouLeave a comment:
-
SQL SUM Function
When I print the data report the output does not display as I intended it to.
I want the Name to be displayed to be unique with the weights shown in MS Access for that indivdual to be SUMmed up.
Any Ideas?
[CODE=vb]Private Function CreateRecords() As ADODB.Recordset
Dim conLog As ADODB.Connectio n
Dim rsLog As ADODB.Recordset
'Open a connection to the Database... -
Data Environment Designer in VB 6.0
I cannot seem to use the Data Environment Designer. I have gone to Components under the Designers Tab, but it is not available. All I get is "Addin Class", "Data Report", "DHTML Page", "Microsoft Forms 2.0 Form" and "Web Class" as options. Any Ideas? -
I rewrote part of the statement and narrowed it down to the datDateTime variable as the issue since I can insert the rest of the data w/o incident.
Dim datDateTime As Date
datDateTime = Now()
("INSERT INTO tblLog (EventDate, EventTime, Entry, Initials, DateTime) VALUES (#" & datDate & "#, '" & strTime & "', '" & strEntry & "', '" & strInitials...Leave a comment:
-
Does anyone else have any other ideas?...Leave a comment:
-
Really? Double-check your codes again. I only see the datDate and datDateTime are enclosed with #, how about your strTime?
BTW, what is the the datatype of datDateTime? Is it really a date or a string?
Rey Sean
All my declarations are in line 1 thru 5 in my original post and written the way they were intendend to be written
Dim conEntry As ADODB.Connectio n
Dim datDate As...Leave a comment:
-
If PriceTextBox = "" Or SharesTextBox = "" Then
TotalTextBox.Te xt = "$" & Val(SharesTextB ox.Text) * Val(PriceTextBo x)
End If...Leave a comment:
-
I did use # signs as shown, but using Date or Time as a column in a table should not effect a query statement, but just to make sure I renamed them anyways and it still did not work....Leave a comment:
-
INSERT INTO MS Access DB with dates
I keep getting a syntax error everytime I insert a date or time into the DB. I cannont understand what I am doing wrong. Any suggestions?
Thank you
1 Dim conEntry As ADODB.Connectio n
2 Dim datDate As Date
3 Dim strTime As String
4 Dim strEntry As String
5 Dim strInitials As String
6 Dim datDateTime As Date
7 datDate = Date
8 strTime... -
I was able to fix it I wasn't using a variant
Thanks for your helpLeave a comment:
-
Run-Time Error 91
Thank you in advance for your help.
When I run the following I get a "Run-Time Error 91: Object variable or With block variable not set"
...Code:Function GetAddress() As Hyperlink Dim dbLogBook As DAO.Database Dim tblStation As DAO.Recordset Dim strSQL As String Dim hypAddress As Hyperlink Set dbLogBook = CurrentDb strSQL = "SELECT A1
No activity results to display
Leave a comment: