Search results

Works great :) even on subforms

Hi all, I have a form with a subform. As soon i add a new record i like to requery the subform listing the current ID of the form. When i now requery the subform, the subform jumps back to the first record instead of display the current record of the form. how can i resolve this?

Hi all, I have created an custom error message on my form. When i fillin all the fields and hit enter i get the custom error message when filling in duplicates. however i also have 2 arrows for the record selection. When i fillin all the fields and instead of hitting enter go to the next...

Can anyone help on this one? i still have not solved this :( Is the only way to do this adding the podium to the time/day table? and then getting a huge list? Regards

I understand your point. But that query is based upon the table time with predifined time/day. What i want tot avoid is include podium in de table time and get a huge list. So the goal is that if podium 1 is booked from x-x podum 2 still shows the x-x time. Sorry i have been tot long out of...

I have 1 table with day/time. 1 table with day as primary key. 1 table with podium as primary key.

Many thanks for the awnser, only thing i dont see is the podium combination. it now disappears on all podium. the database is still under construction and i will take your information with me to improve it

??? Its the planning.accdb when i click on it, it downloads the database. Maybe your browser?

I Attached my database i really dont know where to start. In the form you can choose the combination of a band incl podium incl a time/day. What i want is that as soon i have a combination of a time/day/podium the time of that podium is not visable any more. so at the end if you have planned...

Can you give an example on how to do this and use it in a combobox? Thanks in advance

Hi all, I have created a combox based upon a query. 1 combobox with days of the week 1 combobox with times refering to the days. This works all fine and as soon i click on a day i get the list of associated times. BUT what i want is.. as soon i have picked a day with a time and populate it...

Hi everyone. I have created a access file that includes the following Name of the music band playing Place where the band is playing Timeslot how many hours Priority What i like to do is based upon the data above, create a Macro that will automaticaly fills in the data into a calender bassed...