| Thread | Last Post | Replies |
|
| Queries that do not return any records - how do i prevent form loa | 01 Dec 2006 13:03 GMT | 1 |
I've produced a linked database i use for validation of records entered into a database that are incomplete (ie. contain blank fields). I've produced a form linked to the validation query which pulls up the incomplete records and allows me to delete them.
|
| VBA and stacked queries | 01 Dec 2006 12:39 GMT | 3 |
I hope somebody could clarify this for me and point me into the right direction. I think most of people are familiar with a concept of stacked queries, they can also be called "query on query" They allows to extract
|
| Union query | 01 Dec 2006 12:24 GMT | 3 |
I have a table that contains records with both a time field and a date field. i have a form that displays the records, however i only dwant a certain number of records displayed, namely those within a certain date/time block. I am planning on another form that will set up a query ...
|
| dropping a relationship (i.e. constraint?) | 01 Dec 2006 09:26 GMT | 5 |
I'm trying to drop a relationship using SQL DDL but I get a "CHECK constraint ... does not exist" message. ALTER TABLE mytable DROP CONSTRAINT [relation-name-goes-here] I can't seem to indentify the name of the constraint(relationship) I want to
|
| DISTINCT Query Help | 01 Dec 2006 01:28 GMT | 2 |
I have two tables; contact_details, and gallery - which links an advertiser to gallery photo's submitted by them. There are many contacts, and many gallery records. One contact can be linked up to six gallery records WHERE gallery.id =
|
| Calculating functions in form objects | 01 Dec 2006 01:14 GMT | 3 |
I'm an M/S Access newbie who has figured out how to do simple calculations in a form objects using the control sources for a text boxes, but am having problems using functions to calculate database values. Table name is: Medicare Form
|
| Using MAX from another table in a INSERT action. | 01 Dec 2006 00:34 GMT | 4 |
i was trying to do a query that is inserting values on a DB, and one of the field should be the result from a query using MAX on antoher DB. Something like this: INSERT INTO tblSNew ( idEquipamento, idCliente, idSWDescrição )
|