bplantes
Last Activity: Mar 25 '08, 05:33 PM
Joined: Feb 21 '08
Location:
-
I figured it out. I just used the "Me!subform " reference and it worked. I think I was trying to make the code more complicated than it needed to be. Thanks for the help. -
I have tried using the External Syntax as described in your thread. After updating a combobox on one of the SubForms (Form1 for example) within my dashboard I need it to update the subform within Form1... to do this I have the following code:
...Code:Dim strQuery As String strQuery = "SELECT * FROM TableName WHERE Criteria = " & combobox_Value Forms!Dashboard.Form1.subfrmWithinForm1.RecordSource
Leave a comment:
-
Refresh a subform within a subform within a Form
I have a "Dashboard" in a tool I am building which has a list of different buttons. Clicking on each button will display different subforms which show up in a window to the right of the menu.
One of these "Screens" has a subform which needs to be refreshed after updating one of the other "Screens." The problem is, the screens do not refresh when switching between screens with the menu buttons.
... -
Speed up my query
I have a query that needs to refresh after updating. The problem is that the query takes about 10 seconds to refresh. Anyone know if there is a way to speed this query up?
...Code:SELECT DISTINCT tblInvoices.CustomerID, tblInvoices.CustomerName FROM tblInvoices LEFT JOIN tblInvoiceCustomerBridge ON (tblInvoices.CustomerName= tblInvoiceCustomerBridge.SystemCustomerName) AND (tblInvoices.CustomerID= tblInvoiceCustomerBridge.SystemCustomerNumber)
-
SUCCESS!!!!
I received a response from another messageboard that fixed this.
I had to create a tnsnames.ora in the directory: c:\instantclien t\oracle_home\n etwork\admin\tn snames.ora.
I created the tnsnames.ora file with the TNS script that I posted earlier and once this was set up, I was able to connect. Stuart, thank you so much for getting me so far along. I feel like I have learned a lot in a short...Leave a comment:
-
ODBC to Oracle Question
Hi All,
I am new at Oracle, so bear with me.
I have installed InstantClient_1 0_2 and installed the Oracle10.2 drivers on my computer. I am trying to establish the ODBC Connection. Here are the steps I am taking.
1. Go to Administrative Tools > Data Sources (ODBC) > System DNS Tab
2. Click Add... and select the "Oracle in Instantclient_1 0_2" driver
Then I try to... -
I have played around with this a bit. This is the error that I receive every time (see attached screenshot... I have changed the name for security reasons, but have tried it with the actual name). If anyone can help resolve this issue, I would appreciate it very much. I feel like I am so close!...Leave a comment:
-
I'm not sure if you saw my edits above... I reinstalled and fixed the problem I was having and can now get into the ODBC Configuration.
Now I am running into a problem with the TNS Service Name Dropdown. What do I need to use here? If you look at my edit to my last post, I have included what the DBA gave me for the TNS. I am not sure how to use this though. Thanks.Leave a comment:
-
I really appreciate you walking me through that process!
Are the ODBC Drivers backwards compatible? Meaning, with the 10.2 driver work if I am working with Oracle9? Otherwise, is there an instant client for Oracle9?
Also, when I try to go through and set up the new ODBC Connection now, I get an error:
“The setup routines for the Oracle in instantclient10 _2 ODBC Driver could not be loaded due to...Leave a comment:
-
I have downloaded Intant Client, but am having trouble understanding their installation notes, specifically step 3:
Installation Instructions
Installation Steps:
1. Download the appropriate Instant Client packages for your platform. All installations REQUIRE the Basic or Basic Lite package.
2. Unzip the packages into a single directory such as "instantclient" .
3....Leave a comment:
-
I appreciate the continued help. I am now having problems and cannot get much further without help.
I was granted access to have read access from an Oracle DB with a generic user name and password that will be used in the tool I am building in Access.
I DO NOT have Oracle set up on my laptop. I am wondering how to set up the ODBC connection using the Link Table option in Access without Oracle set up on the computer...Leave a comment:
-
Zwoker,
Thanks for the tip. I will try to use the link table solution and then try to use this solution if I run into problems.
I am developing a tool for a client (friend) that links to outside databases. They have given me a temporary Access database that is identical to a databases on their share drive (I am not on their network). Is there a way to set up a linked table in Access that looks for a file to link to...Leave a comment:
-
Using ODBC in Access
I have loved the quick responses that I have received using thescripts.com for a couple of my prior questions. I thought I would ask the question here as I haven't been able to get a good result from my Google searches thus far.
I am trying to use Access to read a table from another Access database and read 2 tables from an Oracle database. With these tables I will be performing some "SELECT" queries... I have no need... -
Thanks for that... I have worked with MS SQL before and have used "Left Outer Join" which would only take the left, non-joined, records. Access doesn't seem to have that functionality. I just implemented this into the code and it worked great. Thanks for the help.Leave a comment:
-
This worked great! Thanks for the help. Trying to get back into the developer's mindset :)Leave a comment:
-
Speeding Up My Query
I have designed a form to bridge one customer record with a master customer record in a table. For example:
CustomerName, CustomerNumber:
ABC Company, 101;
ABC Corp. , 102;
ABC Inc., 103;
ABC Co., 104;
ABC Comp., 105;
MasterCustomerN ame, MasterCustomerN um:
ABC Master, 1001
Bridge:
101, 1001;
102, 1001;
103, 1001;
104, 1001;... -
Filling A Listbox with a Query in VBA
Hi All,
I am new to Access programming and it has been a long time since I have done any programming at all, so I am a bit rusty. I am building a form in Access 2002 that displays a list of Customers.
When the form first opens, all Customers are displayed in a Listbox with the Address1, Address2, City, State, Zip, and Customer Number in Textboxes that populate when you select the customer. The listbox has the property...
No activity results to display
Leave a comment: