Search results

That is great. it works a treat. The only thing i'm missing now is the CardID needs to be displayed asap. can that be done????

ok. By doing it this way though, will i end up with an a1,b1,c1,d1 etc etc etc????? That is how they record things

That doesn't exactly do wot i want. if i create 26 tables, one for each letter of the alphabet, so that i can get id's like a1, b1, b2, e1, etc etc, i want to be able to click on a letter on the switchboard i.e. A, it will open the Standard form, but it will use the info saved in tblA and...

This is the code i currently have on each letter Private Sub openA_Click() DoCmd.OpenForm "Enter data", acNormal, "qryA", , acFormEdit, acWindowNormal DoCmd.Maximize End Sub

sorry. am currently trying number 2. what did u mean when you said assign the letter selected to strletter?????????

This is what i currently have

I haven't yet, but i would have done. And 26 tables. Help!!!!!

I have a form which is not bound to a record source. I have various queries which all contain the same field names, and these are the same field names as in the form. i now want to be able to open the form based on any of these queries dependant on what button i press. i.e. if i press A, the...

I have been apporached by our Students Union to create a database which allows them to monitor the issue of union cards. What they want however is a form which allocates an alphanumeric ID based on the 1st letter of the surname, and a number. So you would end up with a1, b1, ca, d1 etc etc...

I have managed to create some code which sends e-mails to specific students. What i now want to do is create a mail merge document which contains details of each student, and then attach this to the e-mail. Has anyone doen anyhting similar before??? Has anyone got any idea's??? This is really...

Ok thanks. Have changed that, and now get : Run time rror 3061 Too few parameters: Expected 3 Any idea's??

Can anyone tell me wot is wrong with this code please??? It works in another db of mine, but won't work in one i'm developing now. Set rstTmp = db.OpenRecordset(sqlstr, OpenSnapshot) Thanks.

OK. my problem seems to be that while i am testing, the same student are appearing. As soon as i select a different student, it works. Any idea how i can stop this happening????

Ok have done that Hayley. Now i still get the message saying that e-mails have been sent, but it's not sending any??????

If i leave the first line in, i get the following error: Compile error: User-defined type not defined

I didn't miss it out. When i time the code in, i can't get DAO as an option???

Hayley, I can't get this DAO thing. Help????

I don't have DAO?????? Help??????

Thanks Hayley, That is fine by me

Thanks for that. The Forename_s_ is becase that field contains (). does this cause an error?????