Recent content by Boltie

Thanks stumac! That worked perfectly. :D I can't believe how much time I've spent looking at other posts and that was all I needed to change.

Like I said, everything is exported to Excel so there is no real need apart from if Excel fails for whatever reason. It's a backup in-case I'm not here to resolve any problems and also an indication as to the progress. The user will still be able to take a copy and paste where necessary. The...

I've searched all over for a solution to my problem and had no luck at all, so apologies if this has been solved elsewhere. I started off with a blank form and added a command button, three labels and a text box. None of these are bound to anything. The sole purpose of this form is to show...

I didn't understand what you meant here at first and even when I did and tried it it didn't work. It is right though. Where I've been going wrong is not closing the form and instead switching between design and form view. I closed the form with "=[Staff_ID].[ItemData](0)" in the default value...

Does it matter that I'm creating a form that isn't based on viewing individual records from a table? It seems strange that even if I enter '1' into the default value property of the combo box and then save and switch to form view, the combo box is still blank. It allows me to open the dropdown...

I think you might be confused with what I want. If not, I'm incredibily sorry for being slow. I just want the defualt value of this combo box to be set upon opening the form. The dropdown list is fine.

Sorry, I'm not sure I follow. I'm pretty new to databases. The ComboBox I have on the form is titled 'Staff_ID'. Row Source: = SELECT Staff.Staff_ID FROM Staff; Row Source Type: Table/Query Bound Column 1 This is all fine. It's the Default Value expression I'm unsure of. My first attemp was...

The Staff_ID won't change for any of the reocrds. I was just using it as an example that if I add staff and the order changes, I want the Staff_ID of the first record. I should have made the examples contain different names. Sorry for the confusion, I've amended my post.

Hi All, I'm currently struggling with what I thought would be a very simple query. :banghead: I have a form that contains a combobox. I want the default value for this combobox to be the Staff_ID of the first forename to appear in a table when sorted alphabetically. The table I'm querying is...

Hi Mihail, When I do that, I can't save the table as there are conflicts with the records already present. This is becuase I have duplicates for Staff_ID and Report_ID but no duplicate with both Staff_ID & Report_ID together. Setting these fields to UNIQUE in the Indexes window states that it...

A Staff_ID should only have one record for each Report_Date. In the above example, Staff_ID "1" has created two reports for "01/10/2013". I want many records with the same Staff_ID but also with unique Report_ID dates. I'm struggling to use the DCount function. As I said, I'm new to Access but...

Hi Mihail, Unfortunately, I don't think your solution will work. I want to be able to have duplicates. For example, I don't want the table to allow the second highlighted record below. EPLOG ID----Staff_ID----Report_Date----Errors_Cleared----Errors_Time...

Hi namliam, I think the check when a user is entering the info on a form is the best option. I just started setting a form up after I posted so will give it a try on Monday when back at work. Thanks for your reply.

Hello, Hopefully what I am about to ask is easily implemeneted. I'm fairly new to Access, I haven't touched databases since I left college. I currently have two tables, Staff and Daily Record. One relationship between Staff_ID, one-to-many the one being on Staff table and many on the Daily...