Search results

I can write an UPDATE statement fine, what I don't quite understand though, is updateable statements involving forms. To populate a form you have the form record source set to some SELECT statement and then you place your controls and set the control sources to the fields in the SELECT...

Thanks for the response. I followed your instructions, but looking through the properties and such doesn't help me understand it much better. Is it possible to bind two forms together without running a wizard? Trying to set the link child/parent fields won't work because my forms are unbound...

How exactly does a Form have a record? Typically what I do is create a new form and then plop down a combobox thats filled by a select query to the primary key and use that to populate everything else. I don't understand how a select statement could be an updateable query.

I hate to ask such a broad question but googling just turns up links for how to use the wizard, and I don't want that. Its my understanding that a subform functions a bit like a report, I can set the recordsource to a query and it'll display all the records returned, in the controls that I've...

Is there any particular reason that sub-query is eating my socks? Thanks for the tip.

I want to update a column in table A with the value in table B where the value in A matches another column in B This is what I have, which seems like it would be a valid query but Access is telling me its not an updateable query. UPDATE PaymentBackup SET PaymentBackup.ClientID = (SELECT...

All of the subforms on all of my forms. Can't post a db any time soon unfortunately.

No. Neither is the database. I can make changes in controls on regular forms, this only seems to affect subforms.

Allow additions is set to yes. The query has never changed since I started working here. And this problem affects every subform in the application, which has several different ones. Edit: I can't make any changes to the controls that do populate either.

I'm not quite sure how to explain this. The application I need to maintain has a regular form, and then a subform on it that is supposed to fill up based on a query, with each record being represented as a row and the columns have various drop down boxes or textboxes etc. Normally there will...

I'm trying to figure out what tool I can use to connect to an SQL Server 2000 database in the same manner I use the SQL Server Express Management Studio software for SQL Server Express. I'll be connecting to the database over the internet via ODBC. I'm looking at a hypothetical situation where...

I'm confused with exactly what you want summed, and what exactly your table structure is. Please do something like tableName column1name column2name ... and specifically which columns you want to to be added up

Without seeing your table structure I doubt anyone is going to be able to help you.

Google returns a lot of results..this seems most likely, but having not seen your database I have no idea, sorry. http://support.microsoft.com/?id=175168 The last issue and work around pertains to any SQL data source. The error can be caused by SQL statements that violate referential integrity...

UPDATE Table1 SET Table1.Quantity = (SELECT Table2.Quantity FROM Table1,Table2 WHERE Table1.Quantity > Table2.Quantity) Should do it.

this is vexing me. I have 4 tables, 2 entities, 1 relationship and 1 lookup Entities are tblOrg and tblForm Relationship is tblVentureParticipation Lookup is tblInfo (Has many different lookups) When an organization (these are listed in tblOrg) turns in a form, a new record is inserted into...

I don't understand the error myself, but would the query work if you wrote it this way? UPDATE dbo_device SET dev_memory = (SELECT fware FROM f) WHERE EXISTS (dbo_device.name = f.name)

' I am making up names for fields and such, change these accordingly. Put a listbox called contactsListBox on your form for the contacts Set the RecordSource = ' I assume you have lastName and firstName for each contact separate, if its just one field then just do contactID,contactName...

Look up how to alias tables. You're going to end up with something like this SELECT floppy.Option, cd.Option, dvd.Option, cdr.Option FROM tblEntry AS floppy, tblEntry AS cd, tblEntry AS dvd, tblEntry AS cdr;

Yes it is possible. I would do it with VBA, if you're comfortable with that I can explain how. If not then head over to the forms section because I don't know how to do it any other way (if possible)