Unable To Edit Sql Linked Table

Unable To Update Linked Table
I have an excel table that is linked to an access database. I use a query to update a named range in the spreadsheet. This works fine for all except one user. He can open the spreadsheet in Excel and edit it there, but it acts like it is read only in Access. The location reference is URL (though even attaching it from his machine did not change it). Wondering if it could be a version error or something else to do with Access? Anybody see this before?

Thanks.

View Replies !

---

Unable To Edit Record
Hey Guys and Gals,

I have a form that has a drop-down box. When the form opens, all the records are shown. Once a name is selected from the drop-down, only the records associated with that name are shown (a filter is created using code). The problem is that once the selection is made, I am unable to edit the records. I try to click in the fields but am unable to.

Any ideas? Thanks

View Replies !

---

Can't Edit When Using Linked .xml File?
I have just finished my first access database, well almost, one problem- I can't edit or type anything on my database when I am using a link to an xml workbook. If I just import the xml file to use on my database I can edit and save it but not when I used a linked xml worksheet. If I change the xml file entries in Excel, the changes appear on the linked database but it won't work the other way around - I can't even type anything in any of the fields. What have I done wrong and how can I remedy this problem? Any help would be much appreciated.

View Replies !

---

Combo Box Based On Linked Table Needs To Pull Info For Sub-Form From Non Linked Table
I am trying to build a Form that will show an estimate (then eventually will be moved to a project if customer and employee aggree to price and project) in a Form F_Estimates is a M_Customers(Customer_ID) (Based on a Table) and thier info in a Subform. Also is the "projected costs" from parts out of the Parts(Part_ID) (Based on another Table) in a second Subform as a list that I need to calculate $$$ in
(Dang that still sounds evil and definately NOT understandable even after edit... so)

Here's some basic info

Tables

EstimatesandParts - Table
EstimatesandParts_ID : Autonumber
Estimate_ID : Number
Part_ID : Number

Parts - Table
Part_ID : Autonumber
PartNumber : Text (not a number due to some part#s have letters in them)
PartName : Text
Unit Price : Currency
Description : Text

Estimates - Table
Estimate_ID : Autonumber
InvoiceNumber : Text (again can have letters in it)
EstimateDate : Date/Time
EstimateTime : Date/Time
Employee_ID : Number
Customer_ID : Number
ProblemDescription : Memo

Customers - Table
Customer_ID : Autonumber
FirstName : Text
LastName : Text
CompanyName : Text
Address : Text
City : Text
Province_State : Text
Postal_ZIPCode : Text (CDN Postal codes are letter num letter...)

you can see the link table in the EstimatesandParts Table

Now I want to use that link to populate a subform in the F_Estimates form

Forms

SF_Customers - SubForm

(all boxes atm are text boxes on this form till I figure out the Parts section then will use same base for this so I can pick any customer in the database to be the customer for this estimate. Also will have ctrl button for making new customer with customer form and a refresh on Focus Gain bit of code)

FirstName
LastName
CompanyName
Address
City
Province_State
Postal_ZIPCode

SF_Parts - SubForm
Default View -Continuous Forms

(want it to be a list of parts that I can grab prices and descriptions from then in a bit of code to calculate a cost of parts)

Part_ID : Combo Box
Control Source - Part_ID
Row Source Type - Table/Query
Row Source - SELECT Parts.Part_ID, Parts.PartNumber, Parts.PartName, Parts.UnitPrice, Parts.Description FROM Parts ORDER BY Parts.Description;

(Pulls info from the table Parts for input into a list of parts to be used on that project)

PartName : Text Box
UnitPrice : Text Box

(here's where I run into problems due to the fact that the form is not based on the parts table but rather the link table EstimatesandParts so I can't propogate the info to the 2 other text boxes, ps I dont care if they cant be text boxes and have to be linked or some other type I'm not "set" just need to find out how to make it work )

(have tried a couple things to complete this task)

Me.txtPartName = Me.Part_ID.Column(2)
Me.txtUnitPrice = Me.Part_ID.Column(3)

(works AWSOME ... for ONE ROW then propogates the second selection to the first and second and third selection to first second and third and so on ...)

(tried to make control source for the txtPartName to)

=Forms!Parts!Partname

(Doesnt exist .. akkk, cant use ActiveForm either as it doesn't focus on the SubForm but the MainForm ... cry)

F_Estimates - Form

Estimate_ID
InvioceNumber
EstimateDate
EstimateTime
ProblemDescription

(all basic Text Boxes)

Employee_ID
Customer_ID

(Combo Boxes Select Customer and Employee from list of present ones of each)

SF_Customers
SF_Parts

(Both SubForms on the main form)

Now this is an Exerp from my entire Database I like to work on one small problem at a time and I have made this its own little database till I figure out the problem then I will bring the info I learn back into the rest of the database and go from there ...

Hope you can help I have a feeling I will need to make a recordset and go from there but I'm just not able to wrap my head around that for some reason

Thanks in advance for ANY and ALL help that I get from here

View Replies !

---

Unable To Add Record To A Table
I have a database that has been working properly for months...however, suddenly I am unable to add records to a number of my tables.

Each of 10 tables are related to a main table with a 1 to 1 relationship - the relationships have not changed.

Can anyone think of any table setting which I may have inadvertantly changed that would prevent additional records from being added?

I am still able to add to the main table and I have added several new tables also with a 1 to 1 relationship with the main table that are all working fine.

Thanks!

View Replies !

---

Unable To Import Excel Spreadsheet To Table
Hey

I have a procedure that imports excel spreadseet to access table ever today.
today it failed. Forrmat was the same as yesterday.

I did 'copy/paste special/format' from yesterday's file; still today's file wouldn't import.

Tried to copy manually to the table, got the error message about 'field not being in the same format'

Went to table's design view, and changed everything to 'memo', the was able to do copy/paste.
There wer no values with more then 20 characters
I was able to change 'memo' back to text and date/time without loosing any date.

Has anyone ecountered this ? Going changing table, and then chaging it back doesn't sound like the best practice
what can be done ?
can abything be done to excel file ?

View Replies !

---

Why Can't I Edit My Table?
I had Access '97 and was able to edit my table and make changes, etc.

I upgraded to Access 2000 and now I cannot edit my table and make changes, etc. The table is not locked.

Why?:confused:

View Replies !

---

Edit A Table Using DAO, PLEASE OPEN
Hi, I have a form called Edit Column, which contains two text boxes: ID and Description. The user types something in these two boxes and presses a button, and this button should take the value of ID and edit description for that particular ID in the table "Map". Here is the code I have written for it:

Dim d As Database
Set d = CurrentDb
Dim r As Recordset
Set r = d.OpenRecordset("Map")

r.MoveFirst
If r! = Me.Text1 Then [I]('Text1 is the text box where the user enters an ID)
Do While Not r.EOF
r.Edit
r![Description] = Me.Text3
r.Update
r.MoveNext
Loop
MsgBox "Successful", vbInformation
Else
MsgBox "This column does not exist in the Store", vbCritical
End If


Thanx in Advance

View Replies !

---

Edit Data In Table
hi, im amaturish at access, but im wondering what would be the easiest way to create a edit page, via any means. eg. in a form?

cheers

View Replies !

---

Can't Edit Data In A Table In ADP
I've created an ADP project containingnumerous tables. One (and only one!) table in the set will not open in edit mode while in Access. Here are the particulars:

1) The table was created from scratch in SQL Enterprise Manager,
2) The table is editable in SQL Enterprise Manager,
3) The table permissions appear to be set correctly (and are the same as all the other tables which all allow editting in Access)
4) I open the Access project and double-click the table. The "add record" navigation button is disabled, and any attempt to edit a field elicits a "This recordset is not updatalbe" error.
5) However, I can open the table in Design mode in Access, make changes, and save them.

Any ideas? This is very frustrating!

Mark

View Replies !

---

Lookup / Edit Table
Hi all,

I am trying to learn Access form building by creating a training database. I created a form that has all of my class information and the students who are attending the class as show in the attached jpg.

If a student has already attended a previous class I don't want to enter his information again. I want to do a lookup for the student and if the student does not exist then create a new student. Is there a way of doing this without coding?

Thanks Steve

View Replies !

---

Edit Field In Table
I am trying to edit a specific record in my table. I want to know how to go about referencing it. I'm dealing with a table of books each having its own Book # assigned to it.

Example:
The table has Book#(primary key), title, author, quantity.

How would i go about increasing/decreasing the the quantity by a value(i.e. 1, 2, 3, etc.) in a form that i'm in and then saving it to that specific books quantity?
I'm attempting to keep track of our inventory.

View Replies !

---

Can I Somehow Edit A Table Through A Form Which Uses Subqueries?
Short version of question:

My research has shown that Access will not allow edits through a form that 1) has subqueries in its SELECT clause, or 2) uses aggregation such as First(). Is there any tricky way around this?

Long version of question:

I have a database form that shows an overview of orders for products (it's based on a query that pulls all current orders from the big table). I would like to handle both of these on each row:


Show where we built it last time, and
Allow the user to select where it will be built this time.

The problem is that I cannot figure a way to change the form/query such that it doesn't aggregate to find out where we built it last time, or doesn't rely on subqueries that do just that.

But I feel like there should be some way to do it--since each row displayed does rely on one and only one record in the complete table of orders. Which obviously is the record I want to update.

Is there something I can do that will accomplish this? I really do not want to have to make the user open up another form to see last time or choose this time.

Thanks in advance!!

View Replies !

---

Edit Destination Table In Visual Basic
I want an append query to add records to one of several tables, depending upon the value of a variable entered into a form. This variable is also used to select the appropriate records. The query is invoked from the visual basic code behind the form.

Can anyone tell me how to edit the destination table from within the visual basic?

In hope...
Nell

View Replies !

---

Edit Data In Table Directly Through Textbox?
Hi
I have a form, which displays data from a query recordsource.
One of the textboxes is a "Comments" textbox, which I would like the user to write in directly, which in turn is a direct link to the data in the table so it is updated immediately.

At the moment, the textbox does not seem to be editable. Is there a standard way to do something like this ?

View Replies !

---

Linked Table -- Database Name Linked To Table
Hi,

I have an Access 2000 database with some linked tables. When upsizing the database I selected 'Save password and user ID with attached tables'.
Therefore in the Linked Table manager after each table in brackets I have the name of the database to which the tables are linked.

I am now wondering if I want to link the tables to a different database how do I change the database name, which is in brackets after the table name.

If I select a table and select 'prompt for a new location each time' I am getting prompted to select a different DSN. At the moment I don't have a DSN and I don't want to have to set one up.

I imagine that the database name and the user id and password I entered in the upsizing wizard are stored in some configuration box but I don't know where I can access this.

Can anyone point me in the right direction??

Thanks

View Replies !

---

Using Multiple Combo Boxes To Retrieve (not Edit) Records From A Table
I'm creating a form that has combo boxes pertaining to each of the following fields from table "Documents": DocumentID (primary key), DocumentTitle, DocumentAuthor, and DocumentYear. No combo box is used with any priority over the others. The working form will allow a user to retrieve the full document record (data for all fields) by using any combo box they want, as well as any combination of combo boxes. This means that if a selection is made in one field's combo box, the drop-down lists in the other boxes need to update based on that preliminary selection. The filtered results for each field, based on any and all combo box selections, are always shown in a single datasheet on the form.

The kicker is that when a user starts filtering records by making selections from the drop down list in a combo box, but then decides to TYPE in another field's combo box, I want the combo box they typed in to do two things: 1) filter the records for that field based on what they typed, if any records meet that criteria (e.g. they typed "B" so only records beginning with B are shown), and 2) if no records match the typed criteria, the search starts all over (at the top of the cascade), filtering all library records based only on what they typed in the most recent combo box.

Does that make sense? Any tips welcomed.

I don't know how to cascade combo boxes in this way.

View Replies !

---

Extracting Data From Linked Db2 Table Using Access Make Table Query
Hi,
I am extracting data from linked db2 table using access make table query. First I create a select query and can view the linked db2 data, but when I change to a make table query I get an error message, "invalid argument", when I run the make table query. There is no selection critera specified. Has anyone had this happen? and Do you know a solution?

Thanks for your support
GinnyP

View Replies !

---