Search results

I suppose I could do that too. However, I think the buttons would be easier for people to use, can you, or anyone post the code to make the buttons work maybe? thanks in advance :)

I'm not sure, at least i think a list box would do in this situation. I have a list of events, and i want an easy way to add or remove them. Maybe this picture could help: Is there a way to make those buttons work somehow?

While looking up examples of databases, i have come across a pattern that people are making a table, and an "extended table" with a query, and then make a form. Is there a benefit of doing that over directly using the table :confused:

I have no idea how to use list boxes. But what i have is a list of the fields from a table. And i want to add a record, and edit or delete the selected field from the list box. How do i do that?

and, i suppose the first problem is solved again. I just created two textboxes with each a different validation rule. And then have the option group change Visibility on them. However, now i need code to check if all fields are not null before saving. any ideas?

I think it works half way now. I added code for the option group to change the value of an invisible textbox. Then I set the validation rule to the textbox. The problem is that it still lets me enter 14:00, even though the limit is 14:30 and above. Another problem is it gives me 4 to 5 error...

I have a field which is supposed to have a minimum time, however, i have weekdays, and weekends. Both times are different, how do i change the validation rule according to my selection in an option group?

Wow! You found the solution! Thanks, that actually worked.

i found some more information that could be relevant. This is exactly what i'm trying to do here. But it only works from the form if you look at i'ts code. The append query would override that. Any ways to use some of this in a way?

interesting. But how do i set an index on all of them?

ah, no problem. I have a list of people in 'Table A' I have a list of events in 'Table B' those two are connected with a many to many relationship so i can list everyone's attendance to each event. (sort of like the college example in this video by Microsoft) And the exact thing this guy is...

In my database i have three tables in a many to many relation ship. From there i have a query that pulls the person from table A and then places then in table B where it assigns the person with each event from table C. However, if i add a new person in table A, and run the query again, it adds...

I took a look at that, but im clueless. How do i get it to do anything, it does not seem to do anything. Is there an example out there? And i hope im not piling up all the questions, but how do you filter a subform? Every single answer i can find is different from another. Any help is really...

ok, well. After som fiddling around, i managed to get it to work just as i want it to. However, is it normal that is can create duplicates if i run it again? so new question: How do i prevent an append query making duplicates?

Ah yes, that does not seem to work. But that is one i might solve at a later time. However the query i am having difficulties with is "qryAddPeopleEvent". To add to that, i also may have found the reason why it isn't working. Append queries cant pull NULL fields. How do i change the fields to...

the problem seems to be that nothing happens. It just wont pull the data from either tables. i tried adding a primary key to one of the tables, but still did not work.

I need some help with an append query. I found a website, which solves the exact problem i am trying to solve here. But, for some odd reason, it just does not seem to work. Could there be a problem with my database? I had posted this in the other category, but as it turns out this is actually...

not sure if this is much for help, but this is what i do. =DLookUp("[location of value]","main table of the value","location of criteria=" & the criteria to check against the other) I hope this makes sense, but this is how I think about it. Just replace the italicized text and you've got it.

thanks for wanting to help, but.. i somehow fixed it. Not sure what i did but it was not unbound, so that probably was the problem.

thanks! actually that link is all i needed, simple and easy.