Search results

Hm, I hope what I am trying to do is right.. but..What I am doing is using a list of people. And then from the list box form, I select people to append their name under the event's table. I hope that makes more sense.

I have two forms, and I want a way to select names from one table, and move them to the second one. The easiest way i saw was through two lsitboxes from this example from here However, it only seems to flag it and I don't know what to do next.

And it seems no one on earth can solve this problem.

It is my low tech solution to the hidden column problem I am having. When ever I hide columns with the button, they wont hide till I reopen the form.

Is there a way to close the form, and reopen it again? Since I am sure when I were to open the same form again, and then use the close command, it would close the last one I made, so it wouldn't help me. Nor would a VBA code help since after the close, it would prevent the open code from...

one more bump.

haha, thanks, but i think i have the basic down quite well. But I am still not sure how to use SQL. Atleast I think this case calls for SQL.

Is there a way to use the Make Table query as a generator to create tables based on certain criterias that input myself? What I am trying to do is create a roster for an event, and that event has a varying amount of days. So I would like to create a form from where I can input the days for the...

bump this thread one time.

Well, that could be an option. However, I have around 15 columns i want to hide at a different amount. For the end user it would be an insane amount of clicking haha. But looking at it, it might seem i need to redesign the form. I mean, my method works, but i have to switch back and forth to...

I tried all of these: Me.Refresh Me.Requery Me.Repaint None seem to work.

I have a split form where I have an option group. In the frame i have 3 buttons. One button displays all columns, while the others remove some. The problem is I can get the columns to hide with this Code: Me.Controls("field").ColumnHidden = True But, I have to click design view, and then form...

Amazing! Haha, it works, thanks!

Well... I am still not sure, sorry. :( But this is what I got: Private Sub EditRecord_Click() Dim strSQL As String strSQL = "EDIT [EventName] FROM tblEvents WHERE " & _ "tblEvents.[EventName] = '" & Me![EventList] & "'" DoCmd.OpenForm "frmAddEvent", acNormal, , "EventName = " &...

@Smig: Interesting insight, but as far as my experience goes I don’t think I am that far yet. I will try to do it this way till I’m done with the database. Afterwards I might go and change it towards your method. But otherwise, how do i get the edit button to work? I tried adding a line to the...

That did the trick, thanks.

hey guys. I'm sorry for being a bit stubborn, but i did not really want to use 5 different queries for this simple form, and i did a bit more searching. I found some code that works perfect, except I get error messages on the delete, how do I get rid of them? here is the code: Private Sub...

interesting. Could you provide me with some code or an example of either solution possibly?

does that mean I should be using queries also? Or only for large databases?

ok. What i'm using is Office 2007. and I want the list box to list all of the events from another table. Then, if i click one of the events, and hit the delete button, the selected event gets deleted from the list. Same with the edit button, but rather opens another form which allows me to edit...