Search results

Anyone? Thanks.

Thanks a lot! That looks much tidier. I attached the latest version of the database diagram below. I will add various fields to the tables, but does the structure look correct now?

Yes - it is a quote. Yep, it makes sense and should work, but it is not as "clean" a solution as I was hoping for... My problem is that I was hoping that an assessment will point to (one or more) piece(s) of equipment, and they in turn will point to quotes for them. Using your solution will...

Makes sense - I'll change that. Was/am going to do that (+add many more fields to some of the tables - was just trying to get the relationships and structure correct at this stage). Missed that one - thanks. Agree - see my comment above. This is where I am/was really struggling... - Every...

I am a MS Access novice, and am looking to develop an application based on Access 2007/10: - It is meant for a government agency that is tasked with assessing clients needs for certain equipment. - The agency sends an assessor to meet the client and produce a report highlighting the...

Thanks for that. I hate the 2007 menus with a passion! Can't see myself ever inflicting a similar experience on a user of my application... I also have a license for 2003 which in my opinion looks better, so I may try that.

Sorry, I am new to this Access stuff... Do you mean tabs?

I am looking to create an application. I want it to have a menu (i.e. a few buttons) on the left of the screen with the rest of the screen providing the space for the various forms, depending on the menu choises made. My problem is that I want the menu to always remain visible - something...

That's good to know. I was getting quite worried with the growing number of tables... The Bookings table is meant to hold records for slots (i.e. sessions) booked for a child. So a parent/Payee can book a session (say Friday afternoon) for a child, either as a one-off or for a period (say a...

I am designing a database for an after school club(s), that should be able to handle (amongst others): - Keeping a record of the children + Personal details + Health details (allergies, special needs, etc) + Which school attending + Which after school centre attending...

Right - makes sense. Thanks again.

Prices shouldn't change more than once a year I would have thought. I guess this suggests that I should use probably you first solution?

Many thanks! All should now be sorted.

I am pretty new to all this Access stuff, so please bear with me... I am trying to get my head around a problem that's been bugging me when designing a database: - Say you have a DB for maintaining a record of product range, prices, orders, customers, inventory, etc - The price of...

Fantastic! Again, many many thanks for your help!

I am not sure I understand your reply... I was referring to this part of the statement WHERE (([tblChildren].[Centre_ID])=[Forms]![frmRegister]![comboCentreName]) that compares ID (number) to name (txt) and obviously does not match anything... I attached a cut down version of the db to this...

Thanks for that - I already realised that I would need to use cascading combo, but wasn't sure how to use it. I am now pretty close... The row source of the combo looks like this: SELECT [tblCentres].[CentreID], [tblCentres].[CentreName] FROM [tblCentres] ORDER BY [CentreName]; And the row...

My DB has (amongst others) two tables: 1. Centres - CentreID as primary key, and centre name a text field; and 2. Children: ChildID as primary key, and a Centre field referring to the CentreID above. It also has many other fields. I am trying to create a form that will display a list box of all...

Many thanks again, all no sorted! Sorry, I do use Office 2007.

Many thanks - all now sorted! Also, thanks for pointing out the spaces in the names - no intention of putting them there, just a mistake... BTW, I foolishly I started the work with an existing DB hoping that it would save me time (it didn't, just more hastle to remove all the unwanted stuff)...