Entity Relationships Tutorial

First a bit of background, the last time I created a database was with a program I believe was called Lotus and that was 30 plus years ago. I am a self taught computer flunky, mostly dealing with websites but have my fingers in everything. But when it comes to Access I am a newbie!

I did a bit of reading and found the entity relationship tutorial and started working on that because I know the database I am building is all screwed up.

So using the tips in E/R Tutorial:
I am building a Deer Hunting Club database. We are what is called a Quality Deer Management club which means we have specific harvest targets and rules, we work on habitat improvement as well. To track our progress we collect a lot of data that I would like to use a database to help with analysis.

We need to track Bucks, Does, Fawns and unknowns, along with Hunters, Food Plots, Stands and Harvest Info.

For Bucks only (we only need to collect numbers for does, fawns, unknowns) we will collect age, antler points, antler spread, beam length, comments, active/inactive

For Hunters we need to track Last and First Names, phone, address, total dues, amount paid, date paid.

For food plots we need to track Location, size, crop and soil test

For stands we need to track Location, type, owner (hunter)

We also want track deer observations, this data will include Hunter, Date, Time, Location (Stand or Food Plot), Bucks, Does, Fawns, Unknowns, weather, temp, wind, baro press, moon phase and comments

We also want to track deer harvest with data that will be identical to Observations.

I am attaching a copy of where I am diagramming this out as shown in the tutorial, but I got stumped on a few things. I plan on using *somethingID as my primary keys and didn't want to get wrapped around doing multi-field keys etc.

I could NOT figure a relationship between Buck and Location (Stand or Food Plot), the only real world relationship occurs through the Observation or Harvest which will specify Location (Food Plot or Stand). The whole Location, Stand, Food Plot thing has me all confused, I will use Lat/Long for all three of them and they CAN be separate entities, BUT I could also make Stand and Food Plot as children of Location.

So I am trying to figure this out but gonna need a bit of help.

Thanks in advance for any help, I really hope this isn't over my head.

Attached Files

BnB Entity Relationship Diagram.zip (39.0 KB)

Entity Relationships Tutorial

Howdy Everyone

My name is Tim and I am from Nesbit, MS. Computers are one of my many hobbies to include boating, hunting anything with the outdoors. Hopefully I can learn a little bit about Access since it has been years since I used, I believe it was called Lotus...?

Howdy Everyone

Hide database

I am trying to hide my database and this script works well.

But then in the visible database I want to be able to click a button and make the other database visible, but I am not sure how to specify which database to make hidden or visible.

Code:

---

Declare PtrSafe Function ShowWindow Lib "User32" (ByVal hwnd As LongPtr, ByVal nCmdShow As LongPtr) As LongPtr

Sub test77()
HideAccess (False) 'change to true to show
End Sub

Function HideAccess(Hide As Boolean) '*** 0=Hide, 3=maximize
Dim AccessWnd As LongPtr, What As Integer
What = IIf(Hide, 0, 3)
AccessWnd = Application.hWndAccessApp
Call ShowWindow(AccessWnd, What)
End Function

---

Hide database

Question macro to manipulate unstructured data like Excel does

Hi all,
I have some tables need to be imported to Access, which is not well structured. For example:

report
4/05/2014
from SQL server
Name ID Add.....
aaa 111
bbb 222


So after imported data, the table needs to process a bit to turn it into a 'Database Table', which is pretty easy to do it in Excel via macro. But I'm not sure how to get it done in Access, please advise, thanks in advance:)

Question macro to manipulate unstructured data like Excel does

Multiple Data sets on chart

Hi All,

I have a simple line chart plotting price against date.

I would like to plot a secondary line on this chart from an array of data that I calculate. I've searched hi and low but can't seem to find a way of doing this.

The closest I've found is from this:-

http://ift.tt/1EW2QLQ
(sorry not enough posts for a link )

I can create my array of data but I can't seem to get it to work and think it may be for pivot charts....which access 2013 can't do anymore.

Can anyone give me some idea as to how to plot multiple data sets on the same graph in Access 2013.
Thanks.
El-d

Multiple Data sets on chart

code for OnClick zoom a image

Hi Everyone,

I am new to VBA for access. I am working on a form as a user interface. I have added an picture to the form. It looks small, and not clear because of the size, and each image has different size. I would like to know if there is a VBA code that will allow me to click on it, and then it will open in another window so it is bigger with the right sizes.
I attempted like this:

Code:

---

DoCmd.OpenForm "Prova", , , "Campo1=" & Campo1

---

but don't work
Prova is another form and Campo1 is the field with the picture.

I also need to save about 120,000 images.
I wonder if the best solution is to use the attachment for the field type or another.
What format should I Whereas in the mask I preview. And if Acces internally saves the images or not

Thanks in advance, any help or suggestion would be very appreciatted.

code for OnClick zoom a image

Hyperlink to tabbed form..

I've set hyperlinks to a couple of forms using the hyperlink address in properties. All works fine, and I've done it this way because the cursor changes to pointy hand when hovering over.

However, I need to navigate to a tabbed form in a main form.

Is there a way of doing this? I've been searching all sorts, and the most probable is to concatenate the destination?

description##Page1#page2... or something like that?

Is this correct?

What ever I've tried doesn't work, this includes ...

adding the main form destination to Hyperlink Address, and tabbed form in the SubAddress (Can't find main form)

Using the hyperlink builder. (Can't find anything)

Objects in this database (Only one form)

Google offers plenty of ways to do everything else but this.:mad:

As always.. appreciate your help.

Hyperlink to tabbed form..