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...

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?

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...

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...

Hey all, I am designing a table however I don't know what is the best way of doing this. Basically I need a form so that you can enter an ingredient, its conc% and its level. At the moment I have soo many fields in the table as I have done it like this. Of course say AqueousPhase1 will...

Hey all, I am testing out an auto fill for a project. I basically want to choose from the information in the combo box and then display the price in the other text box there. I have attached the database file, would be great if you could have a look what is wrong with it. Regards Aaron

Hi all, I have a problem with a current database I have setup. Basically, I have made three forms, one the list project form, one the add new project form and another subform which shows the recipes. I want it so the user can add a new recipe in the subform for a particular project. So they...

Hi all, just another quick question today. I have used a database from another example and edited it around. However the two forms on the database have a standard size window when they open up and I can't seem to make them larger. I have tried making the forms bigger in design view but they...

Hi all, Basically I have two tables, one being "new project" and the other being "recipes" which need to be added to a project. For example you will have project 1 and recipe 1,2,3,4,5 for this project then project 2 and recipe 1,2,3,4,5 for this project. What would be the best way of going...

Hi all, I am currently in the process of developing a database. Really simple, basically I have made a table called "Project" and a form for this table where users can insert details on a new project. Basically now I want to display all these projects on a "view projects" form. What is...