Search results for query: *

i have records that i need to select for a specific user by date. The problem is that the date field is actually just a text field. here's my code so far: set objCnn = Server.CreateObject("ADODB.Connection") set objRS = Server.CreateObject("ADODB.Recordset") set last5RS =...

hi there. i have an asp page that is using the winhttprequest object to get the contents of an "external" website (just a page from another department here.. but a different server). Then i modify the html i get to suit my needs.. save it to a file, and then finally, i display this stuff in an...

i have a table that has a lot of fields on it. the user would like to be able to run a report by date. the initial results will show just a few fields... and then if the user clicks on a record, they want me to display another report with more info on it. i'm not quite sure how to do this...

hi there. i've created a little button on my form that launches the default find/replace dialogue box in access. i've noticed some odd behavior (ms access version 2000). sometimes, when i search for a word, it highlights the entire sentence instead of just the word that it found. and then...

hi there. i have a tab control with 2 tabs. on the second tab, i have 15 different textboxes & buttons. i've tried to set up the tab order by changing the tab index on my controls... but it keeps changing. i've tried to change all the 'tab stop' settings to NO first. and then one by one...

hi there. i have a button that calls a macro. this macro uses the runcommand to execute a "find". but when i click on this button, i'm now getting the message that the control the macros is attempting to search can't be searched. how do i include all fields on the form in the find command...

hi there. i have a list on our sharepoint website that my ASP web app needs access to. I am trying to use msxml2.serverXMLhttp to get the contents of the page. i'm getting the following error message: err.number = -2147483638 err.description = the necessary data to complete this operation is...

hi there. i'm trying to write some sql code that will search for the top 5 most frequently appearing items in a log file. The field I'm looking for is the top 5 "searchText" values. Right now, my code looks like this: set objCnn = Server.CreateObject("ADODB.Connection") objCnn.Open...

i have a vbs file where i'm trying to read in a csv file. my code (in part) looks like: set cnn = server.createobject("adodb.connection") set rs = server.createobject("adodb.recordset") cnn.open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & csvfilepath & "Extended...

hi there. i have to write some script that will accept a path and then search through that path and all subdirectories for specific file types. So far, to test my logic, I just assumed that we'll only have 2 levels of subdirectories. the pseudocode looks like: set fso = file system object...

Hi there. Can anyone tell me how i can force the Favorites window to open on the side and be "pinned" via javascript? I've been searching on the net and can't find anything... Thanks.

i have an svg file that I'm trying to load as an xml document. i create an msxml2.domdocument.3.0 object and try to load the svg file in to read it. it's failing with the error: the system cannot locate the resource specified. Error processing resource...

is there a way to capture when the user clicks on the X button to close the entire application? I need to log the event. thanks.

hi. i'm trying to select some records for reporting purposes. i know i have more than 1 record that matches my selection criteria, but the recordcount is always 1. My code looks like: Dim Rs As DAO.Recordset Set Rs = CurrentDb.OpenRecordset("SELECT * FROM [Client Info] WHERE...

Hi there. I've been asked to modify a production database. I have a form that needs to be split into two different forms. (for now, i'll call them FORM A and FORM B) However, the back end table that it writes to will NOT change / cannot change. AKA. Both forms will write to the one table...

Hi there. I'm trying to get around the error that I have too many controls on my form - I need to add a button to my form. i know i don't have more than 700 controls. Someone suggested that i create a blank database and import everything in as this would "reset" the number of controls. I've...

Hi there. I want to know if there's way to print all data on my form. i have a tab control with many tabs on it. So far, i've tried using the button wizard and i've tried both printing a form, and printing a record. Neither is what i want. what's happening is that it's only printing the...

hi. i need to display a graphic in a ms access form. this graphic / image will have several regions. each region will be assigned a value from 0 - 6. depending on where they click, i want to capture the region value in a database field. in order to do something like this, what type of an image...

has any tried running their ms access databases on a touch screen pc? (like the ones you can buy at best buy / future shop) does it just work or do you need to build/rebuild using special APIs? my gutt is telling me it should just work... ? thanks.

I'm using the code from FAQ181-291: Transaction Log for Ms. Access It works fine for new records. But when I edit a previously saved db record, the field that's been updated is written out twice to the audit table. it's not obvious to me why this is happening... Thx.