Recent content by J355Y1

Thanks JANR but could you please break it down for me a little more.. What do you mean by "d"? Is it suppose to be written like that or am i suppose to replace that with something? Also there are no calculated fields in my database only dates, so im still stuck on my question 4 of how i would...

Hi, Im not sure if this is the right place to post this but i dont know what else to do as i am a very newbie to Access so ill just ask anyways, I have a button in Excel that needs to use data from an Access table and then use that data to find information to then update that same Access...

@boblarson - Could you please explain to me why it had to be 5?

No i had not set the column count, but i changed it and now it works so thanks very much!!!

I am using Access 2007. I have attached the database I am working on and the form i am working on within the database is frmAddEntry which has two subforms subfrmAddEntries and subfrmLstEntries.. Does anyone know how to do either of my questions.. Thanks!!

Hi, I have a form which has two subforms in it. The form is called "frmAddEntry" which also has a combobox which displays students names and a textbox which displays student genders according to which student is selected. Question1: How do i get my subforms to be invisible and only appear...

Ok so i tired that code and when i change the record in the combo box the gender textbox changed but it just changed to blank. How would i get it to change to either G or B according to the gender of the selected record? Thanks!

Thanks guys i managed to get it to work by sorting it first.

How would i sort it before i combine it then keep it sorted?

Thank you for your help, I tried what you said but now instead of displaying B/G, B or G depending on what is selected it only shows "#Name?" I do not know what the problem is? My combo box says unbound, could that be why? I am quiet new to this. Thanks

Hi, I have a subform which has a column called Event which is made up of 4 other columns called EStroke, Egroup, EDistance and Esex. I have combined the columns using this code in the control source =[EStroke] & " " & [EGroup] & " " & [EDistance] & " " & [ESex] I do not use any of the original...

Hi, I have a form which has both a combo box and a textbox, the combo box displays the names of Students at a swimming carnival except i have joined the first name and last name columns together so the combo box displays both eg. "Bill Smith" Now my textbox is suppose to be the students gender...