Search results

Thanks a lot, thats brilliant :)

Can someone tell me how on load of a database - my main form could open and maximise (so user doesnt have to click on the form to open) :)

thanks a lot, ill have a wee look now :)

Hey, having a slight problem with my access application, i have one form, but i used to have a couple other forms and now those are deleted. so this is fine but when i start the database i get an error, not one that crashes the program or anything it just says: "the form 'frmEmployees' is...

ah ok well thats that cleared up, ill just leave it as it is :)

I didnt really know where to post this. Is there a way to when you open my Access program for it to not open in access, just as a stand alone window so i get a more professional feel to my program? So: bypass access and just show my form stand alone? Any information is appreciated :) thank...

Although this all works properly, when the list boxes pop up, if u click cancel for all of them then it crashes any idea how i could stop tht? :)

Yer sorry :) Its ok now i've fixed it: Private Sub cmdAdd_Click() Dim MYDB As Database Dim SOURCE As Recordset Dim table As String table = Me!cmbModules Set MYDB = CurrentDb() Set SOURCE = MYDB.OpenRecordset(table) SOURCE.MoveFirst SOURCE.AddNew SOURCE![First Name] = InputBox("Please...

Hey, I've tried writing some code that will, when you click the add to database button, look for the value in a dropdown box, use that as the recordset, then let you enter the information in using input boxes. I'm not sure if it will let me do it but i came up with this code, i dont think it...

Hey people, I'm trying to work out a way to let the user of my program add to the database. But i Have 6 tables that i want them to be able to add to, representing 6 different university modules. I'm not sure of the correct way to go about this, dont really want to have 6 different forms for...

Thanks works great, very nice and efficient way of populating list boxes with different tables :)

Thanks, ill give it a go and let you know, thanks for the reply :)

Just wondering if it is possible to change a List Box Row Source Using the OnClick Event of a Combo Box. So for example, I have 4 options in a combo box: And when i click each one in i'd like the Row Source of say 'lstPopulateRecords' to change to a different Query so then it would therefore...

Thanks both of you, I've got it working nw perfectly now thank you!

Hey, Hopefully this is an easy question: I have a Combo Box (Combo2) and its linked to a Query which populates it with 4 items from a table called tblModules. What i cant figure out the syntax for is when i select an item in the combo box it will then change a List Boxes Visibility to = True...