Search results

I have an ODBC connection using the Microsoft ODBC for Oracle driver. I am attempting to link a set of 6 tables in my access database so that I can query the Oracle information. When I set up the links to tables, I get no errors. The problem happens when I try to open (view) or query four of...

Hey everyone, I am trying to run a procedure by using a string value containing it's name. From all of the help files, the Run method is the way to go. However, when testing with it, I cannot make it work. I have the following code on a form that I am testing the method with: Option...

Is there an alternative method for the Followhyperlink method, that may be used to open a web page in the browser? My problem is that when I use the Followhyperlink method to open the web page that needs to open, the entire Access Application freezes until IE can completely render the web...

Alright, I've got all the pieces to this puzzle, I just can't fit them together properly. I have two tables, tblTickets and tblTicketNotes. They are in a one-to-many relationship, there can be multiple Notes attached to a single ticket. I am trying to set up a query that will pull the first...

I haven't found too much help with the XMLHTTP30 object yet, but here goes another question about it. Posted below is the code for a function I am using that posts data to a web database via a php API. The first portion (the part that uses the POST method with the XMLHTTP30 object, works fine...

Strangeness. I have this IF statement: If rsTasks.State = 0 Then .Open "SELECT * FROM ltblBillingTasks WHERE RecordID = " & rsBilling!EntryID & " ORDER BY DateStamp", cnBilling Else rsTasks.Requery End If Code execution stops, and the compiler refuses to compile...

Can anybody confirm one way or the other, of whether or not requerying a recordset will destroy (break or otherwise invalidate) bookmarks that you have set for said recordset? I would think that it wouldn't, as requerying the recordset simply refreshes the data held without changing any of the...

Anybody have any code snippets, or objects/methods to look at that would allow me to scroll the Access Application window? What I have is an application that many people in my organization use. Some user's screen resolutions are set so low that the window takes up most of their screen's real...

Quick question that I know someone here can help me with. I am using a function in a query's criteria to filter the query data. It is a simple function that simply returns a global variable. The global variable is set by a form where the criteria is specified (a multi select list box with...

Hey all, looking for a library to reference that will allow me to create MD5 hashes. I only need to create them, don't need to interpret. I will also need to be able to specify the hash base and key (don't know if there is any other way to create one, but I need this way). I have found that...

Hey guys, I've searched the forum for topics relating to Splash Screens, and while there is a hefty amount of them, none of them seem to apply to my situation here (redirect me if I'm wrong, please!). I created a splash screen that simply states "The application is loading, please wait...". I...

What I am attempting to do is to update records on a remote database with records from a local database. The two tables are identical in design, with the same primary keys and the same information. I want to update the remote database with changes from the local database and append any new...

I've looked through all the posts here for an answer but havnt found one that I can use, so sorry if you guys have answered this before and I just cannot locate it. I am trying to parse XML data that is retrieved from an URL. I found code on MSDN that pertains to VB but I cannot modify it to...