Search results

They are just unbound text boxes with the calculation in.

I have a form with a subform. The subform is continuous with each record holding a frame with 3 options for each record. In the subform header i have some calulations counting how many are selected at the different options in the frame. It works fine, but when i first go onto the form, or make...

Hum... interesting. I have fixed it now, and as far as i can tell its because i opened my database BEFORE i opened Microsoft Outlook. Hope that works for anyone else with that problem! If anyone knows why this happens id be interested to know! Thanks

Hi, I have a form with code behind it so when you click on a text box it runs some code to send an e-mail. I used to have the exact same code behind a button and it worked fine. I thought it worked fine on the text box, but i only set it up yesterday and today I get an error message saying...

Brilliant. Thank you so much for your input The Doc Man. Thats just what I need to start getting my head around it. Not looking forward to this!! Going to have to write actual sentences again!! Thank you!

Hi, I have designed my database from starting with very little access skills (mainly thanks to you guys - thank you!!), but it is getting to the point where it really needs to be documented properly so I can hand it off to someone else any they wouldnt be completely lost! (I have been doing...

Dont worry - I got around the problem with deleting the button, adding the code to the on click event of the text box and making the text box look like a button. Sorted!

Hi, I have set up some buttons on a continuous form. I wanted the button to show text on it, and for that text to be a field from the form its linked to. To do this i put a text box on top of the button. It works, and ive set up the code behind the buttons to use that variable as well. The...

Great, thank you. Lots of useful bits in there. (Esp the difference between execute & runsql) Just tried it out and it works great. Thank you!

I have a table where 1 of the columns (ColumnA) is selected as a, b, c or d. I want to have a button on a form which deletes all of the records where ColumnA is set to b. Im not completely sure how to do this, but I was thinking of putting the code behind the button as something like DELETE *...

Wayne, thank you so much! That looks like tis going to be really helpfull. Thank you!

Thanks Wayne, Ok, I dont want it to be specified to one form, so i guess that means i want a Public one, yes? So the 1st line would be: Public Sub xxx() But what would I have to put in the xxx and ()'s? Im looking at an example i found and for the functions it seems to put the name that...

Hi, I am trying to get a macro to run a bit of code. I want to put that code in a module, but ive never created one from scratch before. Ive done quite a lot of code, so i know exactly what i want to put IN the module, but im a buit confused with the top & tail of it all. (eg. Private sub .../...

Thanks for all your suggestions. I copied all the information into a new database, and it seems to work now. If I have the problem again then I will try and find if there is anything corrupted. Thanks again for all your help.

Great, thanks for that David.

Thanks for your confirmation/suggestions. MStef, I thought the same thing, but the FE I was compacting is a personal file - Only I have access to it. Could there be any other reason? Thanks!

Dont worry, I just found a post a few down from mine which should answer my questions! Thank you! http://www.access-programmers.co.uk/forums/showthread.php?t=160314

Hum. I think my message is plain text. Im guessing there isnt any way to change the font in that case? Is it possible to make changes and send it in HTML format?

Hi. I have a front end of a database which was around 21,000 KB. I did a compact and repair, and the size went up to 25,000. However, there is a new file called db1 which is 8,000 (The size i would expect my main file to be after the compact). It almost seems like its getting 1/2 way through the...

Thank you for your reply, I will give your suggestion a go.