Hi, im doing a CD library database and i have two tables, "CD" and "CD Copies" linked by "Catalogue ID No" field. Bellow is a picture of what i mean (click the link below it if it doesnt work!):
https://picasaweb.google.com/1167658...75094040621826
I would like to return the number of "CD Coppies" a selected "CD" has,...
Search Result
Collapse
5 results in 0.0014 seconds.
Keywords
Members
Tags
-
Ollie Shotton started a topic how to count the number of records are linked to a record in another table?in Accesshow to count the number of records are linked to a record in another table?
-
Save an embedded worksheet from a bound object
I have a bound object on a form that is "embedded" to an OLE field on the table.
If I have it linked, when I double click a field on the spreadsheet it opens excel, I can type text in a field, then save and close. When I refresh the form it will show up there, and it saves to the original file.
If I have it embedded, I can double click and edit the field right inside access, but when I save it it doesn't save... -
Update the table structure in a Front-end/back-end situation
Hello,
I've got a Split database, where there a lot of back-end databases. There is one Backend-database for each customer. And there is also only one back-end linked at a time.
Now I want to update all of these back-end databases for the release of a new front-end version.
when I try this:
...Code:DoCmd.TransferDatabase acLink, "Microsoft Access", Text1.Value, acTable, "Analyses",
-
deleting node from linked list
i was wondering if anyone could help me under stands the basics of deleting a node from a linked list\
my programs has something like this:
typedef struct car{
int mass;
int x;
int y;
struct car *nextptr;
struct car *lastptr;
} car;
and there are about 500 nodes in my linked list and i need help to find a way to deleted nodes from this linked list,... -
Relinking ODBC Tables using VBA
As a lot of my projects involve using an odbc linked backend data source I have found this piece of code to be very useful. I usually trigger it to run on system startup like in AutoExec macro. It avoids any difficulties down the road with broken links and if the DSN name or database server changes then the only edit that needs to be made is to the connection string.
...Code:Function relinkTables() Dim tdf As DAO.TableDef