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...

Use the cstr() function to convert anything to a string. For example: strMonth = cstr(cboMonth) strPayPeriod = cstr(cboPayPeriod) ----> this being the day strYear = cstr(Year) Than combine into one string: strDate1 = strMonth & "/" & strPayPeriod & "/" & strYear same for...

I would normally use a text field for the dates instead of a date field but I believe if you want to convert a string to a date you can use a Date(strDate1) function. HTH Steve Carrier

you are right about the query but it has to have # in front and after the dates: strSQL = &quot;SELECT * from table where date > #&quot; & strDate1 & &quot;# AND date < #&quot; & strDate2 & &quot;#;&quot; you then set your subform or form's recordsource property to this query...

Hello, In your query criteria you can set certain dates. For example if you only wanted to see the dates 01/01/02 to 01/15/02, set up variables called strDate1 and strDate2, and set strDate1 to the first date you want ie. 01/01/02 and strDate2 to the second date ie. 01/15/02. Then use this...

I used the import feature in Access. Is that what you mean? The data in my speadsheet is fairly ugly so the table it creates is just warehousing unsorted data. Can I use the DLookup function to find certain records in the table? I need to find every field that has order code in it and transfer...

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...

Tig, I would place the code in the Form_Load event for whatever form you want to resize. The code them becomes quite simple: Me.Height = 480 Me.Width = 640 Hope this helps! Steve

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

You can reference the forms height and width properties in the VBA code. For example if your form's name was frmTest the code would be: Form_frmTest.width = 640 Form_frmTest.height = 480 I am not 100% sure about a function that would check different resolutions but that would be good for an if...

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...