Search results

Hello, is there a way to make your subforms auto number entries so that it starts over with every new parent form record? I'm making notes on songs and I want each songs notes to begin at 1. I know you can only have one autonumber field and that is of course the note ID. So how would I do...

I found the answer from a link at the bottom of the page. It is to make the on click event: FollowHyperlink Me.YourTextBoxName Can't paste the link, don't have enough posts. Thanks.

I have a table that is full of song titles and hyperlink field to play the mp3s. This works fine in the table datasheet view. I click and the song plays. However, in the form, when I click, nothing happens. The field is set to is hyperlink and display as hyperlink. Does anybody have any...

Hi, what you are talking about is cascading combo boxes, I think. I know how to do that, that's not what I'm trying to do. In the case of CCBs, you have to choose an item from the last table that it is filtered down to. I want to be able to choose an item from any of the 3 tables. For...

Hello, I'm making a form for notes on a project. The project has Grandparent, Parent and Child (3 levels) of entities. However, I want to be able to make notes on all three levels. So, for instance. Say it went like this: Grandparent = life forms Parent (mammals) = dogs, cats, etc. Child =...

Hi, I'm building a big database which is split up into several smaller databases. The forms are in their own db and the tables are linked to the forms in that db. My question is, sometimes I work on it home and sometimes at work. How do I get the links to work in both places? Thanks!

That won't work because the whole point of making the table is have the auto numbers for the combobox. If I delete the table every time, then when I make edits to the underlying tables and Access makes a new table, the autonumbers will be different every time. I want the combobox entries to...

That makes sense! Thanks! But I am trying this to make the make table query refresh: On the "On click" event, I have in code: Me.comboboxname.Requery It is neither updating the make table table, nor the combobox list. What exactly am I supposed to do?

Hi, I have a form with a combo box that is populated by (1) a union query, and (2) a make table query from that union query. The reason I have both is because I want to have an autonumber and I can't do that directly in the first query. So any time I update any of the tables that are in the...

Hi, I just created a database that has a bunch of contacts in it. I have a table called Contacts and a table called Type. I also have a many to many table called ContactsType. I know how to tag them one by one, but there are many of them and most of them are of more than one type. Is there a...

Hi, I'm trying to create a many to many table (which I know how to do). But this is a little complicated. I have several photos that are part of my database, so I have them in their own table which contains: ID CallName PhotoType Source Computer Link (to where photos are stored on my hard...