| Thread | Last Post | Replies |
|
| Jpgs in a field | 20 Apr 2006 20:43 GMT | 2 |
I have a database (Access 2000) of books and am wanting to include a picture of the books cover in one field. How would I do this ie. field type etc. Also - I am using Frontpage 2003 do display results from this DB. Can anyone tell me how I would go about displaying the jpgs (I am ...
|
| using excel | 20 Apr 2006 20:31 GMT | 4 |
How do I type a (C) in excel without getting copyright sign? Even if I put a ' in front of the information I still get the copyright symbol.
|
| Macros and Conditionals | 20 Apr 2006 20:01 GMT | 1 |
I have a macro that does the following... msg box, import table (enter date), append imported table to existing table, delete the imported table, msg box. In the event someone starts the macro but didn't mean to, at the point where they enter the date for the append query, they ...
|
| Wine Database - One bottle to one bin question | 20 Apr 2006 17:38 GMT | 4 |
I've got a wine rack that stores 6 bottles on every row and there are ten rows. I want to be able to allocate a bottle to say Row3 position 5 - so I need to check that there isn't a bottle in R3/P5 already.
|
| Table shows the wrong field from the combo box | 20 Apr 2006 17:16 GMT | 8 |
This is my second post, and I'm hoping to get as good of help as I did the last time, since I still don't really know what I'm doing with Access. The database I created contains a form with 3 combo boxes: cboMain, cboSub, and cboDetail. The choice made in cboMain determines what ...
|
| creating a field whicn contains a link to external files (pdf tif | 20 Apr 2006 16:44 GMT | 2 |
Is it possible to set up a field in a database which contains a live clickable link to a file, a pdf/doc/tiff etc? I would like to be able to create the link so that if it were clicked it would produce the alert window as seen in an internet browser window where it
|
| Taking a photo | 20 Apr 2006 16:22 GMT | 1 |
How can I use my cheap video device to take photos and store them on the computer? I have managed to have the camera working in video mode on Windows Netmeeting, but that facility doesn't allow for snapshots.
|
| Need to ask for date range | 20 Apr 2006 14:27 GMT | 2 |
I am pretty sure I have been here and asked this before, but for the life of me I cannot find my post to refer back to. Can someone please tell, I have created a query which I need to add criteria to which will prompt the user to enter dates for a date range. This date range ...
|
| Numpty Query Question | 20 Apr 2006 14:07 GMT | 5 |
I have been asked to create a list of suppliers and their relevant id codes from a table containing this information along with order data etc. So, each supplier and their related codes appear numerous times in this table.
|
| Calendar and time sheet | 20 Apr 2006 13:40 GMT | 55 |
Does anyone know how to make this possible ad updatable in MS Access? Description - 12/1 - 12/2 - 12/3...... 12/31 Sample1 - 2 - - 5 .....etc Sample2 - 6 - 8 - 3 .....etc
|
| Dynamically Changing Reports | 20 Apr 2006 13:27 GMT | 2 |
I am allowing a user to chose multiple criteria from a form in order to create a custom report. Once they have chosen all the criteria I build a SQL statement and put that statement in the record source of the report, then generate a print preview of the report report for them to
|
| Display no-match between tables | 20 Apr 2006 10:12 GMT | 3 |
Access 2003 I have a table with the fields: LC, LC Name where LC is the code for a facility and LC Name is the Name of the facility I have a second table that in imported from an external database with the
|
| Relationships and populating fields | 20 Apr 2006 09:25 GMT | 1 |
I made a one to many relationship database for a horse show. I can enter data in data sheet view if I enter it on the one side first. I made two forms for 2 different tables. I can enter in both forms but -- My related fields are not populated. I thought that the inner join was ...
|
| combining different levels of a tree | 20 Apr 2006 05:55 GMT | 1 |
I'm putting together a database for a journal which publishes two issues per volume. I have a Volumes field in one table containing a record for each volume in the sequence of volumes, related to an Issues field in a second table with a record for every issue in the sequence of ...
|
| simple report question | 20 Apr 2006 04:18 GMT | 3 |
I have created a button that calls up a REPORT in print preview. I want to make sure this button only calls up the appropriate fields in REPORT based on what the user enters after a USER PROMPT (i.e. it should ask for "Last Name" before going to print preview). What's the
|