Search results for query: *

I am not sure what is happening here. When I try to add a record to a query, I get an error: "Invalid Object Name 'LA'." I have created some very simple tables and a query for troubleshooting purposes and continue to get this message. Here is how I re-create the message: tblParent ID Number...

When I setup the connection in the Access Project, I specify the SQL server and login, then I can pull down a list of databases available on that SQL Server. This list does not include the Linked Server or it's tables. In Enterprise Manager, the tree displays the SQL Server, and under the...

No, Form B is not a subform of Form A. Form A has a Subform with the same datasource as Form B, used to display only a couple of fields from the child records (read only). Form B opens - in addition to - Form A and the subform, to display the complete record and allow adds/edits/deletes of the...

How do I do this I have set up a Linked Server on my SQL Server. I can see all of my tables for the Linked Server in Enterprise Manager. How do I create an Access project to use these tables from the linked server? "Don't be afraid to do things wrong, before you do them right&quot...

MinusM, Just to confirm, 1. I Open the form to a new Record 2. I Fill in some Fields 3. I Close the Form, which triggers the beforeupdate event for the Form 4. I cancel out of the update for the form 5. I find the record was saved in the table. ...Don't seem right, dud'nt it. One other thing...

MinusM Yes, I agree. I was under some pressure to complete this project, so I just wrote extra code to handle the add record instead of allowing the form to do it auto. (something along the lines of what you recomended). Just wondering, do you know how the record is able to update with out...

Can it work so that, for the Form and Subforms - the adds and edits are syncronized and appear seamless. Then I assume that deletes would cascade automatically. Is somenthing like this possible/reasonable? "Don't be afraid to do things wrong, before you do them right" Bradley Greaves

I was looking through posts regarding Views, Stored Procedured, Unique Table Propery, etc., very common that one would like to update more than one table using a form like is possible using a query in .mdb. Mostly I saw solutions using stored procedures as the recordsource or Forms using...

I have a form that gets is data from a query. The form has a field (one of a composite Primary Key) that is filled from a combo box. After making a selection from the combo box, the form is dirty. Here is where it gets wierd - When I enter another field/TextBox on the form, the record updates...

Jeffry, One last advice type question. Do I leave this thread as is, or is it within proper Forum etiquette to begin a new thread on the ADO Issue. Like "Why does Record Update but Forms does not" Your Thoughts. Thanks for your help, the Paul Litwin aticle cleared up many design...

My wife says I'm stubborn, go figure. If: TABLE Master doc_ID ColDocTitle ColDocSubject ColDocAction TABLE Version Doc_ID Version ColDocBeginDate ColDocEndDate And I am looing at a form of "documents' ID Title Subject Action Version BeginDate EndDate As I Forward and Back, I only see...

Yes, I see your point about the design and normalizaton, and I am a bit confused abuout the proper design in this case. I did mean to go with something like you describe here but I chaned my mind. Right now I have something like this: TABLE Master doc_id version Col (specific to master only)...

Me!Again Just an update after playing around with this last night. I think I cleaned up the data design a bit an I have the error to where it is more predictable. Looks like the record updates on its own without the form updating. It does this when I leave the combo box, or when I Save or...

Me!Again I tried to remove the round from the DSum. seems to stop the erratic behavior but I did stumble accross the error that I got previously. Run-time error '3759' Scaling of decimal value resulted in data truncation (btw, got a signature now) "Don't be afraid to do things wrong...

660 records. The DSub looks like this, except I left out the expression which limits to a select group of record. =DSum("round(openqty*price,2)","PKMast01",) PKMast01 is the linked table, but this is exactly how I used the DSum to get the total of all the records from the...

If you link to it you will need to set up an ODBD data source on your computer, goto the control panel. If you are having problems importing, maybe you can make a copy of the foxpro table to an earlier, more compatable version of foxpro. Maybe this will help with the import to Access. In...

Do you need to import the data or link to it? Bradley Greaves

I have some text boxes on a form that display the dsum of data in an ODBC Linked Table. The Linked Table is a Visual Foxpro 6 dbf table. I promise you that the data does not changed and is not accessable by other users. When I Open the form I can see my totals, BUT..... if I requery the text...

No, Its not 1:1, its one version to many names Exactly: the document starts at version 0 with many names (could be 1, could be 10). The document is only good for a specific period of time (30 days), but we can repetedly extend the document (30 days at a time). Each extension is likely to have...

Yes, I agree I should clean up the design. I believe it will always look something like this: tblMaster has 5 child records from tblVersion each 5 from tblVersion has 5 child records from tblNames the 5 from tblNames must can only be created if they exist in directory tblAllNames (use combo...