Recent content by SteveCarrier

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