Search results for query: *

I was wondering if anyone had any experience using Oracle as a back end for asp.net. I am using an Oracle database with Microsoft's Web Matrix. I would like to use their controls and edit the data source to use the oracle database. Can this be accomplished? Any help would be appreciated...

I was just curious what the best data type to use if I have a large body of text(sometimes a whole page) that could be filled with special characters (such as semi-colons and commas). I thought about using varchar or a CLOB. Thanks in advance for any suggestions. Steve Carrier

I am using a bunch of dummy forms as SQL recordset containers. Once my code is finished and the program returns to the form I have noticed if I go to the Unhide forms option in the window menu all of the dummy forms that my code used are still in memory. I believe this is causing an Error 2101...

I have a list box which gets populated with Page Numbers which meet a certain criteria. When the criteria is not specified, the list box fills with all page numbers(185 in total). I then have a button which when clicked sends the page numbers one by one into my program which finds what goes on...

I have a database with a bunch of tables and procedures that manipulate the data in the tables. Everything works great but now I need to make the data available to be edited or accessed through some data access pages. I realize now that these pages used slightly different VBSCRIPT coding rather...

I have a database with a bunch of tables and procedures that manipulate the data in the tables. Everything works great but now I need to make the data available to be edited or accessed through some data access pages. I realize now that these pages used slightly different VBSCRIPT coding rather...

Hello, I am trying to transfer the contents of certain cells in a spreadsheet to fields in a database. The TransferSpreadsheet method works okay if your spreadsheet has large ranges of relevant data, but I am going to have to sift through the spreadsheet with some code to locate certain records...

Hello, I am trying to transfer the contents of certain cells in a spreadsheet to fields in a database. The TransferSpreadsheet method works okay if your spreadsheet has large ranges of relevant data, but I am going to have to sift through the spreadsheet with some code to locate certain records...

Hello, I am trying to transfer the contents of certain cells in a spreadsheet to fields in a database. The TransferSpreadsheet method works okay if your spreadsheet has large ranges of relevant data, but I am going to have to sift through the spreadsheet with some code to locate certain records...

I was wondering if anyone knew a good place to look where to get info about transferring data from Excel to Access in VBA code. Referencing different cells and taking the info and inserting it into some Access tables. Thanks in advance. Steve Carrier

Hello. I have a field in a table which I want to clear at the start of a subroutine. The routine goes through a loop and keeps adding different strings to the field until the end of the recordset. The table must be updated to clear the field before going through the loop, however. This is my...

Hello. Is there a variable that will hold more data than a String? I need a variable that will concatanate a massive string together so that I can combine many fields and then dispense them into a memo field I made. Thanks in advance. Steve Carrier

Hello This is a very generic post but I was wondering if anyone had experience with transferring data from excel into access. I know that it can be done from the VBA code by referencing the different cells but maybe there is some resources to follow on a web site. Thanks in advance. Steve...

Hello. When you have a recordset which contains null values is there a way for you to instruct the SQL to replace the null values with some other value, such as ""(an empty string?). I may have, for example: Select ProductID, ProductDesc, ProductSDesc, ProductMDesc from Product...

Hello, When you have a recordset which contains null values is there a way for you to instruct the SQL to replace the null values with some other value, such as ""(an empty string?). Right now I am using some isnull() tests in my code but it is very sloppy so I would like to improve...

I have a module which changes the recordsource of different forms with new sql statements. It works for most of them, but for a couple I get a weird error when it tries to assign the new sql to the recordsource: Run Time Error '2001' You cancelled the previous operation. Has anyone seen this...

Hello, I am using a select case for a project where some cases will have the same result, i.e. if x = 2 or 4 then the same lines of code are applicable. ie. Select Case strValue Case 1 or 2 or 12 <------this doesn't seem to work --do these lines of code-- Case 3 or 4 or 5 or...

Hello, I was wondering if this syntax is correct cause I am having some problems with it. strValue = Form_frmTest.[strFieldName] I need strValue to equal the value of the field contained in the variable strFieldName. For example strFieldName might contain pgCategoryName and therefore I need...

I have a table with two columns, one that holds a variable name and the other that holds a reference to it's related field. For example the first record might be: varName = strCategory varValue = Form_frmTest.pgCategory and the next: varName = strTitle varValue = Form_frmTest.pgTitle I have a...