Search results

Songs can be a part of 1 album only, not multiple (sure, it's not a real world scenario, but still - that's what I want to achieve so hence AlbumID within the Songs table). As for the second table instance, when I do that in the Relationships tab of Access, I get this result. Since I have never...

The thing is, one musician (PersonID) will be the main creator / carrier of the album while the others are performers of the songs themselves and what not, that's why I connected the tables that way.

Hi! I ran into a problem related to tables' relations within a query. When I have a "cycle" where relations keep going from table to table and end up within the same table they started from, that will be a problem. Example below: When I have a query (as above) that will provide me with...

Marking as done as the answers provided here were not really trying to answer whether "the implementation I did was a valid one" but instead linked to theoretical database videos that I am already familiar with or providing info totally unrelated to the question.

What I basically tried to achieve is to enter person info into Persons entity / table. Then, depending on whether the person is a doctor or patient, I'd have some info about him / her specific to their status (doctor has EmploymentDate, Sallary while patients have "SomeAttribute") - only data...

Wouldn't that require me to enter data in the Doctor / Patient table first and then the data for the junction table? In other words, DoctorID would be an AutoNumber (its own) and PatientID would be AutoNumber, so I eventually may end up with the same ID value in the junction table (where one...

Dear Access-Programmers community, I have come into a little confusion on how an ERD ISA hierarchy would be implemented within Access. While I do have a general idea and a possible solution to it, I am not quite sure whether the approach I take is the correct one. As an example, I'd take the...

Quick update: Earlier today, prior to the recent two replies, I actually seem to have found a solution that works properly (until it randomly crashes someday just like the previous one): DoCmd.GoToRecord , , acNext If Me.CurrentRecord > Me.Recordset.RecordCount Then DoCmd.GoToRecord ...

That was what I originally tried, but no matter what workaround I hoped for, none actually managed to modify the RecordCount for some reason. Well, this approach works perfectly when I use it except when I reach the end of the records, I do get a Run-Time Error.

Hello folks! So, I've been doing some Access stuff in VBA. I managed to add "previous record" and "next record" buttons to a form that would display different info depending on the the record. The problem is, my "Next Record" button doesn't work at all. When I load the form and click "Next"...

Hi folks! Is there a way to insert an OLE Object into a table by using forms only (aka to open the Browse wizard, find the file and simply insert it that way)? I've been unable to find results based on this topic.

After giving it a shot, Access actually allowed me to store and read the color values in both Short Text and Number. I will stick to Long Int, though. It feels safer as the source of the value may be a picker. As for the Visitor message, I hadn't noticed it until you mentioned it. I will watch...

Indeed. I had a feeling I'd find a solution faster if I had posted it on both sites. I am going to include the link once my limit of 10 posts has been taken out. Would I be able to store the color value in a table so that I can load it when a specific user logs in so that the forms' colors...

Indeed. Plus, the preferences would be reset when you restart your PC with Danny's approach if I am not mistaken. My main concern is that I am not 100% sure how to approach the problem. I'd think of having a function written in VBA that takes a string parameter (e.g "Blue", "Green", etc.) and...

That certainly sounds good. While I doubt I would be able to write such pieces of VBA code as I am not really an expert when it comes to it, but I'm sure I'd be able to implement it if I had a starting point. Thanks for the reply.

That does sound like the thing that would have to be done, unfortunately. Would still love to implement it, so I'll keep searching. Thanks for the reply.

Form User preferences [This same question has been posted on MSDN as well. Link will be provided soon.] Hi folks! Recently, I have come across an interesting article about Access Forms that was talking (and providing a valid working example) of user preferences. The idea was basically that...

Thank you for the reply. I certainly never thought of that idea, but man, it's really great and the result is proper. What I do have concerns for is the flashing the toggle button sometimes provides (more randomly and on hover). Is there a way to get rid of it, bv any chance?

[SOLVED] Toggle Button background Hi! Is it possible to change the background of a toggle button to transparent (so that only the image I use for it will be visible. I'd like to remove both the border (which should be possible via setting the style to transparent) and the background color...