Search results for query: *

When I create a tableadapter in VS2008 which calls the ora_hash function (oracle 10g db) AND if I pass the password string as a parameter (:password) rather than passing the password as a string ('hrss3k') I get a different hash value than if I execute the same hash statement in oracle. I get...

When I create a tableadapter in VS2008 which calls the ora_hash function AND if I pass the password string as a parameter (:password) rather than hardcoding the password as a string ('hrss3k') I get a different hash value than if I execute the same hash statement in oracle. I get the same hash...

Our office is in the process of moving to 10g and I am having trouble reviewing job details after I have setup an export to run through a job. Does anyone know how you review the parameters - there is a tab for parameters when you view definition, but it only ever says there are no parameters...

I am hoping someone can help point me in the right direction. I have developed a web service that is pulling/returning a datatable from an Access database located on the c: drive of the IIS server machine. But when I change the web service to look at an Access database located out on the...

I am learning the ropes in VB.Net and want to learn how to implement a global error routine in my VB.NET Windows Application. I have found many textual examples of this, most talking about adding the controls to the main() sub. But I am just not getting it to work. I can create a main() but...

I want to have a base form where I define a button (btnExit) through the code and the base form contains an event handler to execute me.close I have the base form created. I can create the button through code and I used the Public WithEvents BtnExit as system.windows.forms.button I created a...

I have recently installed Visual Studio on my machine and of course Crystal is packaged with that. But I support Crystal users and need to edit reports that have nothing to do with Visual Studio. Does anybody out there have Crystal running on a machine that also has Visual Studio on that same...

Does anyone know of how to make a parameter box wider? The default box that comes up isn't wide enough to show all the text.

Does anyone know how to capture the DateModified for a form in Access. I can right-click on the form name in the database window and get the correct date from the properties option. But referencing the MSysobjects table's DateUpdate field isn't always correct.

Can you have the user type a person's last name in a field and then use that value to populate a dynamic prompt of 'case numbers' that are available for that name. I can create two drop-downs that do this: drop-down of last names and then a drop down of case numbers. But doing this is clumsy...

I have an evaluation copy of Crystal XI and have found that the dynamic prompt (parameter) is showing only around 1000 records. There appears to be all kinds of setting changes suggested to the registry but I can't get anything to affect the number of records returned. Same problem exists...

I am working on someone's database that has a column called: Serial Number When I try to reference that column in a function like DLookup: DLookup("Social Number", ...) I get an error message saying my expression is not valid... When I try the same statement with a field that is not named...

I wrote a function called isbarren() that takes a variable and checks isnull, isempty, = "", and = 0 and returns TRUE or FALSE. I've used it happily until yesterday when I noticed that when I pass a string value of "2000D-473" it returned TRUE. Upon examination, I...

I have a form with two subforms. The two subforms refere to differnt fields in the same table. One of the subforms shows the navigation buttons and one does not. When I use the navigation button to change a record, I want both subforms to go to the same record in the underlying table. Right...

I am useing an ODBC driver to connect to an Oracle database through a ADODB connection in Access vba. However, I'm running into some settings-problems with the connection. I have access to, and can set about 13 connection properties prior to executing the conn.open statement (including the...

This may be simple (I hope) but I'm missing something: I want to create an ADO connection in code that I can reference/use from other Procedures or Functions. Right now I can get the connection but when the Procedure ends, the connection can no longer be referenced. My hunch is that I have...

I have programmed a form to allow the user to construct a SQL statement and pull(for display) records from an Oracle database. What I would like is some sideline entertainment while the records are being pulled from Oracle. My ideal would be to make an object appear before the query stuff...

The short example of what I'm doing is: ... Me.CCBR_subform.Visible = False ... 'Connect to Oracle via ADODB connection to get recordset Set Me.CCBR_subform.Form.Recordset = rs If rs.RecordCount > 0 Then Me.CCBR_subform.Visible = True End If ---------------------- Problem is...

I am doing some research to get together a list of properties and their settings for an ADO connection. I have a list of 90 different properties (i.e., prompt, null concatenation behavior, outer join capabilities...), but am having trouble finding the values for and definitions of each of the...

I have a database that maybe 3 different people will be in at time. It is on a network drive. However, yesterday when I tried to open it, I got the following: The database had been placed in a state by user <name> on machine <name> that prevents it from being opened or locked. (Error 3734)...