Viewing Contents Of Two Tables
Aug 27, 2007
Greetings to All,
I have one table (tblLink) that resides on an SQL Server quite a distance from me. I have another table (tblLink_r) that resides in a local .mdb file. The tables are identical except for the data they contain and where they are located. Only one index (LinkIdx=autonumber) exists. I am making sure there are no duplicate indicies in the LinkIdx fields because I started the LinkIdx field in tblLink_r at 2100000000.
When I open tblLink (remote), I can scroll to the end of the 21,000 records relatively quickly - read: little latency. Queries performed on this table similarly show little latency.
When I open tblLink_r, I also have little latency. This table has 100 records.
I need a single object which contains the contents of tblLink and tblLink_r. I have tried a UNION ALL, but this query takes upwards of 4 minutes to complete which I can't understand since either of the constituent tables only take ~.5 seconds to call up.
I am hoping someone can provide a way to speed up the UNION ALL query or provide an alternate means to combine the contents of these tables.
View Replies
ADVERTISEMENT
Oct 25, 2004
I am trying to view the contents of a text field in a form. The field can only be a limited size in the form, but I want to store a lot of text in the field and have it visible without having to enter the field and use the arrow keys to view the contents. Is it possible to programme a function that shows the contents of a field when I roll the mouse over it or something like that? The "Control Tip Text" is the principal of what I am trying to do except this gives a fixed value. When used in web page development I think this function is refered to as "Alt tag"
View 3 Replies
View Related
Feb 24, 2015
I know this is an Access 101 question, but what is the best way to view text rather than numbers in my tables. In an example which I have attached, an Orders table shows the Customer field as a number. I would like to view the actual customer name when I am looking at the table.
View 3 Replies
View Related
Mar 29, 2013
I have a feed from ODBC to Access DB. I need to populate several new tables with the contents of the original table. I know I'm being stupid but it's been a long week.
View 1 Replies
View Related
Apr 29, 2008
I was wondering if there is some setting that can be set such that certain records within a table are not visible when the table is opened, or a form is accessing its records.
It seems from time to time, some records seem to 'disappear' from view?!?
Other than a filter...
Does anyone know how this is possible, and what can be set or specified in order for this to be happening?
Thank you for any enlightenment...
View 2 Replies
View Related
Dec 19, 2007
Hello,
I am an Oracle DBA with little to no Access experience so please be kind. :D
As of yesterday a frequent user of Access 2003 (11.8166.8172) SP3 reported that all columns in all rows have the value #Deleted in a number of tables linked back to an Oracle database.
I am not experiencing this problem but I have Access 2007. It is not an option for this user to upgrade.
I've discovered several issues over the web with data type issues/ characterset issues but nothing seems to fix the problem. I've tried the Oracle supplied 11g and 10g ODBC drivers. I've tried the Microsoft supplied ODBC for Oracle drivers.
None of it seems to work and I am out of ideas. Can anyone suggest anything?
The problem wasn't noticed until yesterday so it can't have been happening for long. The problem is occuring in Oracle 10.2.0.3 and 10.2.0.1 databases. There has been no change in the Oracle environment.
There was a windows update recently but we tried uninstalling that and it didn't help.
any ideas?
View 5 Replies
View Related
Dec 1, 2013
I have made a table and I enter data in that table through a form. The form also include two sybchronized comboboxes. When I select a category in one combo box, corresponding items are selected in second combo box. The problem is that when I select the category in the form (with ID+Category Name), it stores only the ID in the table. How can I see the Category Name in the table (which is the control source of the form) instead of ID?
View 4 Replies
View Related
Sep 17, 2014
My db is split into front-end and back-end. In the f-e's Relationships schematic, I can see the relationships as they were defined at the time when the db was split, complete with the one-to-many symbology.
I can add a new table to the b-e and set its relationship as one-to-many, enforcing referential integrity and cascading as I wish - and the schematic (in the b-e) reflects that.
In the f-e, I can then use the <Get External Data - Access Database> function to link to the new table, and I can add the new table to the relationships diagram in the f-e. I can also drag and drop to link primary and foreign keys (within the f-e), but cannot select one-to-many. I'm OK with that, as I understand that the relationship is within the b-e, and this is just a diagrammatic representation.
But I can see the one-to-many relationships between the tables which existed when the db was split, and I would like to be able to see the new table's relationships in a consistent fashion. Updating the linked tables via the Linked Table Manager does not do the trick.
Surely I don't have to split the database again in order to achieve a consistent diagram - do I ?
View 3 Replies
View Related
Oct 5, 2007
I have two tables that have the exact same structure. They both started with the same data, but each were changed separately. (Two copies of the same DB, editted separately). I need to review the data in each record and determine what has changed or if records have been added. Is there an easy way for me to do this? (Note: Each record does have a primary key)
View 1 Replies
View Related
Sep 12, 2013
I am in the process of revamping an old database. I have a main table that currently has two fields "Name" and "Job" but will have more. I have another table with the same fields. I want to use as a lookup to populate the main table with a user form from the second table. I can populate the "Name" field using a combo box, but my problem is how to autopopulate the "Job" field. E.g. If the user selects Mr Smith from the "Name" drop down list, the corresponding "Job" populates the second field.
View 4 Replies
View Related
Sep 14, 2012
I have Access 2010 tables linked to Sharepoint 2010 lists and my table becomes disconnected when I run a delete query on the table in Access.
I can append the table and Sharepoint stays connected.
Can I do an append that deletes the previous contents of the table?
View 1 Replies
View Related
Jul 14, 2006
Hi,
I'm making a form where the contents of a field is determined on the contents of another field in another form. I thought an IIF function would work, but when I tried it the contents says #NAME.
I put it in the control source.
IIF([Forms]![Frm_NewBusiness]![Page4]![Child51]="NTU",NewBusiness_Date_Issued="NTU",NewBusiness_Date_Issued)
Any ideas?
Cheers,
Ben
View 1 Replies
View Related
Apr 18, 2006
Hi, can anyone please help me.
I've just set up a form with 2 pages which I can add data into, but for some reason, I can't view all records.
I've tried using the switchboard to add buttons to both add records and view (but they both only add), and i've also set up my own button with the instruction to view all records, but it just won't work.
On the first page the data source is tbl_CompanyInfo, and on the second page, the data source is a subform with the data source tbl_Contacts. The subform will link contacts to the company info via the CompanyID field. I hope that makes sense.
Can anyone please tell me how I can view all of the data via the form.
Thanks very much
View 5 Replies
View Related
Sep 29, 2006
I'm wondering how can I view only those query data with value in certain fields.
For example in a record of students with check marks, view only those students with check marks and leaving those having no check mark out.
I know it has something to do with the criteria but not sure what. I've already search the MS Access Help as well as this forum and have not found anything.
Thanks in advance.
View 1 Replies
View Related
Jul 21, 2006
I am working creating a data entry form. I am using the data entry option in the form properties to do this. However, when I do this, my subforms do not display any information.
Ideally, I would like them to display information when the field linked to the subform is entered on the main form. Is there an option for this ?
Any help is appreciated. Thanks.
View 3 Replies
View Related
Sep 6, 2006
Hello Access gurus
I hope I am in the right place to start this off
I had D/b all set up but i need to have on my form a view of directory(s)
I have button that creates the folder (many thanks to the person whom gave me this )
but what i want to be able to do is preview this witihn my form
so on my form I want a box that will show what i have stored in this folder (which could be word or pdf or xls)
my button will create C: empfiling filenumber & filename ( about 20 chars)
so my form need to be able to preview all files within this folder ( I hope that I have at least half way explained what I am after
Access 2000 - and reasonable expereince (not brillaint at advance VB )
any thoughts regards
View 4 Replies
View Related
Apr 14, 2006
I've used Access 2003 to create a database which contains a table linked directly to the "Orders" table on my mysql server. This table holds all of the customer orders placed on our website. I next created a form in access to give me a nice justified view of the orders.
My Problem? The field on the mysql server that holds the line item details for each order is a "Memo" field, and all of the text is formatted in html it appears. When viewed on the form, I see the all of the raw code, and not the nicely formatted text. If i highlight a section of the code from the form, and paste it in a Html editor (Frontpage for example), I see the line items nicely formatted as intended.
Is there a way to get this memo field to display the formatted html text instead?
My access skills are pretty limited, so detailed steps would be appreciated.
View 3 Replies
View Related
Mar 4, 2007
Hi All,
users can opening a file (either .doc, exe or .pdf) with additional data to the record they're looking at by clicking on a icon on a form. The icon has code behind it that opens the document (Application.FollowHyperlink NameDocTo Open). That opens the doc OK, no problem, but what is a problem is that the window for this document is exactly the same size as the window of the access form from which the second doc is opened.
The size of the access window is defined. I'd like to get the word or excel or pdf to be maximized. The weird thing is that I use the same code in another database and there the 'secondary doc' opens in a new window and of large enough size. How can the same code generate 2 outcomes? And how can I fix the issue described?
Thanks guys.
View 1 Replies
View Related
Jan 26, 2005
I have a form with a subform on with the visible value set to false. After a value has been selected from a combo box i then want this subform to show. Tried calling the form using me!formname.visible = true in the afterupdate but it says it cant find the form.
Any Ideas how
View 3 Replies
View Related
Jun 30, 2005
I've been reading everywhere on this site trying to find out how
to do this, but just can't seem to grasp it. I see people saying it can
be done, but can't find more specific details on how to go about it. I
just want to view a pdf file from within the access environment. I need
to be able to view contracts from my app, and joy oh joy they are all
in PDF form.
Any help is greatly appreciated to get me started on this. I've
tried using the Active X Adobe Acrobate Control but to no avail.
View 1 Replies
View Related
Nov 19, 2005
Good Morning all,
On a Form I have a series of Listboxes, each drills down to a final piece of information. The Listboxes store a number_id which displays along with other information In this case the number_id is associated to a TEXT description. When I send the Listbox info to the Report it displays the info but the text doesn't wrap and it gets cut off. There is no "can grow" option on a list box.
So I need to create a Text Box in the Report but when I refrence the listbox in the control source only the number_id shows up. I need to see the associated text (field).
Any help would be great!
Thanks,
Phil "bones"
View 2 Replies
View Related
Jan 18, 2006
Before I spend an age trying to get this to work I thought I'd consult some experts.
I have a main data table for recording all possible insurance claims against a company. What I want to do is create say 2 incidents but link them in some way. i.e. One of our drivers had a car accident (1 claim against our motor policy), but then the driver of the other car sues us(1 claim against our public liability).
I can create 2 seperate records and maybe have a field to highlight parent/child reference numbers, but is there anyway I could allow the user to click a button and see the related records simultaneously?
Cheers
View 2 Replies
View Related
Jan 28, 2006
Is it possible to create on my form a drop down combo box for just viewing purposes of table values? i want to manually enter my value but sometimes i like to look at my Standard ranges as a double check. I do NOT want the combo box values to come into the field.
is there a way to do this?
thanks
View 4 Replies
View Related
Nov 17, 2006
I have a lookup colum in my datasheet. Is there any way that i can change the properties so that I can view both the first name and the last name in the same box once it is chosen. Currently in design view I have a column for first name and a column for the last name. When I choose a name from the lookup column, all it shows is the last name... i would like for it to show both the lastname, firstname.
please advise... thanks
View 3 Replies
View Related
Dec 2, 2006
HeyI made a form which displays formulas such as [unitprice]*[quantity]. These forumulas are working perfectly when I display the form in 'form view'. However, when I open the form in 'datasheet view' it displays '#error' in the same field. I think the problem has something to do with me attaching a subform to the form. As when ever I click on the '+' to display the subform in datasheet mode, the '#error' becomes into a correct value.Why is this so?I would appreciate the help.Thanks
View 1 Replies
View Related
Sep 17, 2004
I have a report that will not preview as full screen unless I hit the button in the right corner. Is there a way to default it to large every time?
Along the same line, I have a form that opens with the menu just fine but when I return to it after running the report, it comes back full screen instead of the size it should.
I am sure these are easier ones for some of you but I can't seem to solve it.
Lucy
View 3 Replies
View Related
