Recent content by bluenose76

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?