Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by rohalyla
-
Exit Access Application
Couldn't find code anywhere to close/exit access - so thought I'd post it. I think you can use the button wizard to create a button to do this too, but I usually don't use the wizards and go straight to event code. This is something I've used many times in my databases - surprised it wasn't a... -
Drop Down Calendar Not Displaying in Crystal XI Parameter
Hello, If you have a CrystalReportViewers virtual directory on your prod machine (check using inetmgr on your prod machine), verify it is using the correct version of .net. I had the same problem with my site (CRXIR2/VS2005 - converted from VS2003). When I looked at the configuration for the...- rohalyla
- Post #5
- Forum: Business Objects: Crystal Reports 4 Other topics
-
ODBC error on Access 2003
It sounds like you may have a problem with the ODBC driver. When you receive an ODBC call failed, it means it cannot connect to the db, so I don't believe the problem is with your query. Try updating the ODBC driver or viewing the SQLBase documentation to see if it is a compatible version with...- rohalyla
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Updatable ADO Disconnected Recordset..
Not sure if this would make a difference, but help doc. says you can only use a static cursor for a cursor on the client side. ohrstTotal.CursorType = adOpenStatic- rohalyla
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Run-time error '3421': Data type conversion error.
Glad it worked!- rohalyla
- Post #14
- Forum: Microsoft: Access Modules (VBA Coding)
-
Run-time error '3421': Data type conversion error.
if rs.Fields("NewTransDate") is a date field then try this: rs.Fields("NewTransDate") = cdate(Mid(strDate,6,2) & "/" & Mid(strDate,9,2) & "/" & Mid(strDate,1,4)) if its not a date field then: rs.Fields("NewTransDate") = Mid(strDate,6,2) & "/" & Mid(strDate,9,2) & "/" & Mid(strDate,1,4)- rohalyla
- Post #12
- Forum: Microsoft: Access Modules (VBA Coding)
-
Can the auto number be told to start at a particular number
You can make the autonumber field start at a specific value by using an append query. For example, if you want the autonumber field to start at 100, create an append query and append the value 99 into the autonumber field of the table. See...- rohalyla
- Post #2
- Forum: Microsoft: Access Tables and Relationships
-
microsoft access 97 protection
You can also hide the database window - if they don't need it to run queries, open reports, etc. Go to tools/startup and uncheck display database window.- rohalyla
- Post #4
- Forum: Microsoft: Access Other topics
-
Converting Access Database to Web
I work with Access97 and it has a Publish to Web Wizard Add-On. In Access, go to file, save as HTML and the Wizard will start and guide you through the process. If you don't have this option, you'll need to go into the setup program for installing access and select the Publish to Web Wizard. If...- rohalyla
- Post #2
- Forum: Microsoft: Access Other topics
-
Combo Box - Not in list Message
Try this code: Sorry its not that easy to read -- when I pasted it in here, I lost the formatting Private Sub sales_rep_NotInList(NewData As String, Response As Integer) Dim ctl As Control Dim strSQL As String ' Return Control object that points to combo box. Set ctl = Me![sales-rep]...- rohalyla
- Post #7
- Forum: Microsoft: Access Other topics
-
Connecting to db via intranet
I'm a newbie to web programming and I have a client interested in implementing an intranet. They would like multiple geographic locations to be able to access the site and run reports from an access database. Is there a way to have the client machine submit information to run the access report...
