Search results

Hey all, I havent finished developing a database and have a switchboard setup as well as navigation macros. 1) How do i make it so the switchboard loads up when access loads? 2) How do I prevent the user seeing the forms/queries/reports down the side and removing them? Kind regards, Aaron Luckie

I have made a query, within the query it has "HasPaid" which is taken from a checkbox. Which critiera would I use to display only the results where the checkbox isnt checked?

Hey all, I have created a combo box in my "Delegates" form that is supposed to allow me to pick a name and then display the query for each. I have the query setup and linked with it, but the results are not showing in the combo box. I have set a criteria in the query, but I think this is what...

Hey all, sorry for yet another question. I have a database where delegates are attending workshops. For each workshop they attend it costs them £50 On the database at the moment I only have a memo field which has the workshops attending. But basically I want to pick from a combo box for each...

Got it Bob, thank you very much

I have a subform on my main form but I want to completely remove the border from the subform so it looks like its still on the same form. Is this at all possible?

Thank you Bob that works. I know this is me being a complete pain, but you had made it work with the Active checkbox. How would I make it work with the HasPaid checkbox instead? I want it so that is checked and then the other subform displays so the details can be added. Thank you

Sorry bob but the one you posted before didnt relate to my database. It was for another thread I believe. As you can see it is nearly working now, the form shows/hides but there is a slight error. Thank you again

Im sorry if im being really stupid, but i cant seem to get it working still. It says "microsoft access cannot find the object ME" Is the Me supposed to be there before the Active?

Thank you for the explaination Bob. However I can't seem to get it working without the error still. Is it possible you could impliment it for me and upload? I would highly appreciate it. Thank you very much

Hey all, I have tried to use some code from another site to try and get a show and hide form working. I have attached the database, if you open up the Delegates Form you will see the error. I am basically trying to get it so when you click on the "has paid" checkbox the subform will display...

Thank you again Bob. I have got it working now! Just another quick query, if you see in my relationships, I will have a form called SPEAKERSCONTACTS which will be used to input new speakers and their personal details. Is it possible to make it so on the speakers/presentations form when i...

I just realised that myself :) I have also made only the second column show up so can only pick the presentation name. Sorry to be a pain... but how would i display the presentation start time, end time in other fields when the presentation title is displayed? Is this possible?

Thank you Bob! I am just wondering, could you please make it so that only the available presentation names are in the drop down box? I am not too sure how to do that. At the moment there isnt anything in the drop down boxes to select. Thank you very much again

Sorry about that, I have uploaded an older version of the database. Thank you

Hey all, got a problem with a database which should be simple but it doesn't seem to be working. If you see in my relationships I have a weak entity table between Speakers and Presentations. I am basically trying to make a form so that it has Speakers on and a subform underneath it with the...

Thank you for that marianne, I have attached a database file (basic) of what I am trying to do. Your see in the Ingredient table there is IngredientName and Concentration. Then in the Recipe Form there is the recipe information and then the check box and then a concentration box. I basically...

Thank you for getting back to me. I have finally made all the connections with the relationships. How would I go about next? I need to be able to pull The ingredient name from the tblingredients to the add to recipes if you say what I am saying. So when you make up a recipe you would pick...

Uncle Gizmo, In the post before I showed you a screenshot of what I am trying to do. I don't think it relates to using your way of excel in access unless I am completely mistaken. I apologise for not being specific enough in the previous post. regards

Thank you for the great reply! I have attached a screenshot of the current form which was used on the database before. As you can see for example in the Aqueous phase there is the ingredients listed HW for example and next to that there is conc %. At the moment each of them is its own field...