Search results

That worked a treat, Thank you

Hi, Thank you for your reply. I have tried this, however, the issue with this is that when I click on the button, the new form opens and immediately closes but the original form is still there? :confused:

Hi, I have a simple form that has two buttons on it. Button one closes the form Button two opens another form What i would like, is, When i click on button two, it opens the form i want but closes the current form. Can anyone offer any advice? Thank you Rgds Bev

Ok, So, as i hit on Post, I had a thought and resolved the data Entry issue. For the benefit of anyone else who may have the same issue, I have the combobox bound to Column 1, hence showing numerical characters and not the text i wished. Thank you

Hi, I have created a form to be used for data entry, Where i have identified standard data, I have set the Combo Box on the form to be a "Value List" so as to standardise the data entry. This creates two problems for me. 1. When Using the form, instead of saving the text value to my table...

Cotty, My appologies, I posted that message at the same time as yourself and your post has solved my issue. Thank you rgds,

I'm a little confused. How do I use this? I can't seem to get it to do anything? Thank you

Thank you for your replies. My DB is simply one table and many queries. Access is used as a means of querying data that is exported for a much larger system. I am interested in one column. “Employee Qualification” I would like to be able to quary this one column to return all records that...

Hi, I am seeking a little help with a query. I have a master table that holds all of my data. The table details what qualifications someone is holding. I would like a query that would enable me to produce a list of people who DO NOT hold a qualification. Is there anyone out there who may be...

I managed to sort this today by trial and error. It was,indeed the formatting of my report that was at fault.

Guys thank you for,your help, I managed to Suss it out by trial and error today. It was actually as simple as formatting the report correctly and all is well. My next phase is how to import a spreadsheet and send,the data to the two separate tables... Bev

Hi, I have made the employee number my primary key and linked the identical fields in both tables, however, when running a report, i still see all from table 1 and only one entry from table 2 ? subsequent entries in table two are show on seperate sheets with all data from table 1?

Hi, I am trying to create a new DB from scratch and need a little advice. I have asked the same question in the query section, in the event that my answer lies there and not in the report. My aim is to chart the career history of many people in my DB and my intention is to achieve this with...

Hi, I am trying to create a new DB from scratch and need a little advice. My aim is to chart the career history of many people in my DB and my intention is to achieve this with two "Main" tables with many smaller tables linked to it. Table 1 will contain the generic data about the individual...

i am also confronted with a debug error when trying to slick on the command within your form?

guys, Thank you for your help thus far with this. I am unsure of how the two db that you have posted are actually performing? tbl_employee holds the names of those available to use. how does tbl_assignment get populated? attached is a screenshot of how I currently have the data sorted. arran

yes, this is correct person number one should not be assigned again until everyone else in the list have been allocated once also. this will ensure that no one person is allocated on the roster two days in a row.

roughly 80

fingers crossed, Thanks Dale

Dale, the names will change each month and the quantity of name will vary too. (Increase / Decrease) each day of the month will need to be covered and there is no exceptions for holidays, bank holidays etc. Arran