Microsoft Access

Negative Record Selection
I have three tables, Invoice, Timesheet and Linker. Invoice can contain several Timesheets and any client can have a number of Invoices.

The Linker table stores the InvoiceID and the TimsheetID so I can keep track on which Timesheet Records are attached to any individual invoice record.

Here is my dilemma.

Any individual Timsheet record can be attached to one and only one Invoice. I am trying to generate a query which finds out which Timesheets are NOT on any invoice.

Return a string from a function
once the function is complete how is the string passed back to the text box. My own thought was that you use a return command but I am baffled.

Setting font colour within combobox
I have a combobox on my form, the combobox has 3 values (1, 2 and 3).

Is it possible to set the colour of the text within the combobox?
1 = Red
2 = Orange
3 = Green

Object or class does not support the set of events
I have two tables: a master table and a linked table that contains multiple entries for each unique ID in the master table. Both tables are also linked by a query that pulls from both.I've created a subform that displays the multiple entries from the linked table for each unique ID: IE the sub table shows all the referrals and the data for each of those referrals for the specific ID in the master form/table (I hope that makes sense).

I need to be able to add new referral information (new records?) to the referral table using the subform, and to have the new data appear on the linked table under the appropiate unique ID (so it the subform needs to automatically generate a new record using the existing ID).

I've tried so many different things (and broken the database on a few of those attempts) and I'm just not making headway. I don't really know VBA or SQL language

Query issues due to a bad relationship!
I have two tables.The first table (EDC Archive) houses all of the images available from a source.
The second table (MDA Database) houses all of the images we have in house.

I need to create a query that will show which images in the EDC Archive are images we have in the MDA Database.
Once I've got that, then I need to be able to display some additional fields that are already in the EDC Database.Since there weren't any unique fields in either table, i created an auto number field for both and made them the primary keys.

I then made a junction table and joined them together but its showing that they are only one-to-one relationships.

Combo Box for Query CRITERIA?
I am constructing a query for a data list What I want to know is is there a way I can insert a combo box sort of drop down menu list in the "CRITERIA" field of a query?

It would make it easier if I could select from a list instead of typing it in everytime I want to run the query
It would seem very bizarre if there isn't a way to do this, it seems very intuitive

Command Button to Set Field Value
I have two forms (main form & boxes) when form "boxes" is open I want to be able to press a command button and enter a set value in the "main form" for the Field "box type" on the current open record.

Combo Box help
I have a combo box that gets its values from the second column in a two column table, with the first column being numbers and the second being words. I just made the width of the display of the first column 0 so it wouldn't show up in the combo box. Whenever I select a word from the combo box, the number from the table shows up in the spreadsheet that the form is attached to. How to I make the spreadsheet display the word (ie how do I make it display the values in the second column instead of the first).

View Queries by Group
I have moved from Access 2003 to 2010. In Access 2003 I was able to create query groups that contained shortcuts to queries in the main database. This worked great for us because we did not want to create user interfaces that required support - but we could have multiple queries in a database and have users look only in their query group.
The database I am using was created in 2003 and had those groups. Is there a way to view, edit and create a similar view in 2010?

rounding percents
My table has a percent field with a max value of 100%. The field is direct entry, not computed based on other data. Every time I enter a percent value above 50%, the value automatically rounds to 100%. Enter 50% and below and the value automatically displays 0%.

I want to display the percent I enter. I've tried manipulating the field properties, but no luck so far.

Can't resize/reposition fields independently
I highlight a table and click Create -> Form. Access creates the form with all fields as desired. When I select Design View and try to resize a field or move a field all the fields are affected. Access won't let me change the field sizes independently.

Combo Box default to a specific value
I have created a form with several drop down boxes - I have added "NONE" to the table my form is tied to. I would like each of my drop down boxes to automatically default to "NONE". Is this possible?

Adding filenames to pictures
I have some pictures attached to a Access 2007 app, using an attachment field. I now want to add filenames to each picture. Is that possible.

Combo Boxes and Yes/No fields auto-completing
I have created a number of fields in my tables that are "Yes/No" with combo box value lists (Yes;No).
I have also created forms linked to each table for data entry. However, as soon as I enter data into ANY field on the form (i.e. a "Case ID" field that is a number field), all of the Yes/No fields automatically populate with "No".
I can not figure out why this is happening.

Updating Tables In Multiple Back-end Databases
I have setup a master database with lots of child databases setup in different locations. When a user makes a change to a particular table in the master database, I would like this change to be replicated to the same table in each of the child databases.

My first thought was just to setup link tables for each of the different child databases that Ill need to access. Then when someone updates the master database, I could just run a query (or set of queries) which updates these child databases.

Another person suggested that I actually link to the tables through code using the vb command .opendatabase. That would mean I would have to have the path of each of the child databases located in a table.

Unable to import file dot in filename
I failed importing filename of TD_PLDecompLeg.AFS_HEL_ALL.2-27-2009.csv in both macro and manually
but no problem with TD_PLDecompLeg.AFS_HEL_ALL.2-27-2009.csv

Moving Outlook Emails
I would like to be able to automate the process of moving a specific email from one sub-folder to another sub-folder in Outlook, via an Access database that I am using.

I am using an Exchange account, and the emails are within folders that are located on a secondary inbox in that Exchange account.

Orders & Products
To add to my list of road blocks that I am facing with my database design, I have an issue with my order tables and my products tables.

First off I have my tblOrders linked to my tblOrderDetails by the Primary Key OrderID. But when it comes to the Products that populate the tblOrderDetails I don't know what to do because there are times that I have special order products that may only be one time use or the next time I purchase it the specs are different so I need again create a new product entry. To get around this I first designed the tblOrderDetails to include the basic product information such as Name, Supplier, Product Category, Unit Cost, Unit Price, etc. However as I did some research on Normilization it appears that I am breaking ever rule in the book by doing this.

So I guess the real questions remains to I continue to break the normilization rules and suffer the consequences that come with that or do I force myself to create a new product forevery unique situation that comes with that?

Number data type with two decimal points
I want to have a number field with two decimal points where when the number is entered it recognises both 1.1 and 1.10, 1.2 and 1.20 etc. I have tried the normal types availabe but when I enter 1.10 it defaults to 1.1.

How to split 3 tables in Microsoft access 2003?
I have 3 tables in Microsoft access and I would like to split them into 5, however my usual way of splitting the tables using the analyse tool doesn't work as some of the data fields I require are in different tables (using the analyse tool you can only split the data from one table)

I would also like to add that the three tables where added by using 3 different text files and if it is easier to merge the three text files into one and then use the analyse tool how could i go about this ?