Recent content by davida1992

Hi all!! I have a database i am creating and everything will be fully doable by the users on forms only, there will be no need to the users to see the tables, reports or access interface. Is there any way to export a full database so that when the icon is pressed it opens a specific form and...

Thanks for the help! I am very new to this, this is essentially the first thing i am trying to do properly in Access. The Pen No is the pen number the animal will be assigned to. (It is all for an animal sanctuary)

Hi all :) The attached image shows a form, and the bottom part is essentially repeated data (obviously according to 1nf this needs to be moved to a new table. The access database i am creating will use forms for the users, i am struggling a bit as to what i should include in the data i move...

I am building a system and once complete to the end user, they will simply see forms. The best way for me to explain what I am looking to do is by talking about a hospital. One part of the database will list all of the current patients and i want the users to be able to choose if they want to...

The picture i have attached shows how i want a form to show, WITHIN its own window basically. At the moment on my new database i am making, it will only show in tabs along the top, no matter what i try i cannot seem to get it into its own window if that makes sense. No matter what i do when i...

All i really have at the moment is the outline for what they want: So i need to basically do the entire things from scratch, but i havent done databases in a while and have forgotten how to start it off, so i am probably jumping ahead.

OK, well the only other thing that i need is i want to create different forms for viewing records, so one for for current hedgehogs, one for released hedgehogs and one for dead hedgehogs. Can i still do this with all that data in one table? I assume i would still have a seperate table for the...

Thanks for that, i gave that a go but still cannot make it work with my scenario! I know im being silly! I have tried so hard and i have been at it for like 4 hours, im getting frustrated and tired now since its 1am, not to mention i feel so stupid for not being able to do the most simple...

I am undergoing a project for university where i am going to be creating a complex Access Database for an Animal Sanctuary. I have previous worked on bottom up designs, however i have a few questions i hope someone can help with! I haven't done databases in some time so i hope someone can help...

Welcome to the Forum :)

Ive been here a little while now, and i must say ive found the forum very very helpful and welcoming, its nice to come to a place where people are so friendly and willing to help who have some excellent knowledge of Access. Just thoughts id say thanks so far and hi to everyone :)

I did manage to find the grouping and sorting facilities, thanks for that :) Easier than i thought it would be!

Still cannot get it to work :'( anyone have any more ideas... Thanks :3

I dont understand why thought because im not trying to do a totals query.. I just want the data from a table to be put into a report that is made from this query. The query first needs to group the data by the publisher, and then once it has organised by the publisher, it needs to order by the...

Thanks for that, the query now works, but i need it to group the results by the publisher, and then order by date. The attachment shows what the SQL now looks like, however now it will not group and order how i want it to i assume? Thanks!