Search results for query: *

willir Yes, they use an OBDC plug-in. I do not, however, feel that I am competent enough to fool around with it. I have been using update queries to do what needs to be done, but I had hoped to find a more elegant solution. I need to do some more reading about MSDE. If I can use it to spawn a...

The code the app uses to move data btween Access and Autocad is locked down. Using a saved query means giving the draftsman access to Access, which is not what we want. Even if we did that, how does a saved query dynamically update itself upon record creation? Don't you have to run the query via...

willir, Quite right. The app is written in ObjectArx and creates an interface between AutoCad and Access. The idea I'm working on is purely inside Access, however. When a record is created, I need to have this automatic numbering system fire up and create a valve tag. Since Access does not...

If our users are using AutoCad without direct access to the database, how can they use a form? I need to have the number created when the record is created, not after. Many thanks, Owen Whitehouse Broin & Associates

Yeah, I looked at that. WAY too complex for what I need to do, and I specifically require no queries. I just need an automatic concatenation of two fields into one, one a unique integer and the other a value that is filled in automatically by the software. Thanks for the fast response, though...

I am a draftsman running a program that adds an Access DB onto AutoCad. When I insert a valve block in Autocad, a record is created in the tblValve with the Unique ID the autocad scratch DB assigned it. That value is numeric and has no meaning. When that record is created, the software also...

I thought perhaps I'd clarify what I'm up to. I've got two nearly identical tables for each component category in a construction project. (I know, I know, no need to start yelling, I have my reasons) One table is a working table that engineers use to spec components. The twin to that table is an...

I've got a combo box that runs a query based on the record the user selects. DoCmd.OpenQuery Me.comboComponentType.Column(4) The query name is in the fourth column of the table. I'd like a subreport to show the results if the query selected. All the queries will have a similar output. How do I...