Search results

Assuming you are using a from for the 'comments' field, cant you just lock the reamining fields on the form, so they cant be changed?

Try looking at post 2 in this. I had a similar problem. http://www.access-programmers.co.uk/forums/showthread.php?t=118100

I dont think it matters where the money comes from on Direct Debits. My wife has a couple of things in her name which I pay for out of my account. As long as the companies get their money they dont care, although if you dont have money in your account and they try to take it, it will be your mum...

and it gets everywhere!

Is there data in other tables that relate to the autonumber that you want to change about?

Thanks Roy, I think I cracked it before you got to replying and my method appears to have worked, however, in case it does not, the links you have provided will no doubt help. The way I got it back in to sync was to create a record in the table, it generated a duplicated number, click close...

OK, My main table has an autonumber field in it to make records unique. At the moment, the number 5-34 are all in use on active records. But when I create a new record either in the front end form, or the back end directly in the table, it attempts to start the record off with an already...

I think it turned out fine. She seemed genuinely suprised when she opened her gifts. And she has worn them without being prompted to, so hopefully that is good. The most important thing, is that at least I got the correct sizes!!! I really would have been in dog house if I had screwed that up.

This is what I use for asking wether or not to print out specific documents that forms part of a pack that ends up being aroun 80 pages, hence the option to stop printing certain documents if needed. Dim Msg, Style, Title, Help, Ctxt, Response, MyString Msg = "Do you want to print the cover?"...

Thank you guys. It is always so damn simple it is frustrating sometimes, works like a charm. I prefer to use Excel for somethings as there is the option to fit to page on documents when doing forms etc so if someone had a field that is slightly larger than it normally would be, whereas word...

OK, I have spent all morning trying to work this out to no avail. This is some code I use, Dim obj As Object Set obj = GetObject("f:\clientdatabase\templates\ChartTemplates.xls") obj.Application.Visible = True obj.Windows(1).Visible = True obj.Application.ScreenUpdating = True...

Thanks guys, that give me some food for thought there. I wasnt aware that word itself had a code editor. Roy, Thanks for that, it is helpful, I also like the idea of it checking to see if word is open first. Thanks.

OK, thanks for that, how could I get word to print, preferably to a specific printer, and then close so the user does nothing.

OK, Tried doing a search, but all I found was what I can already do. I use the following code to make access open word up, fill in a blank. What I would like to do is for access to open word, fill in the blank, print the word document out, and close word without confirming the need to save...

I cant find anything online, only 'club wear' and she wont like that, I would have loved to have found a 2 piece set in pink.

LOL Brian, I couldnt find any! Perhaps some reserach in to valentines is needed soon...........

Glad to be of help! Your welcome.

DocMan, your last advice I like the sound of, and I know that it will be some time yet before I get her to that stage! lol :rolleyes: I bought her the gifts last night, some nice lingerie, which I spent about 30 minutes in one shop picking out, and had the help of a very helpful assistant. Its...

Tried importing the contents of the database in toa nice new one?

Have you tried importing all the tables/queries/forms/macros/modules etc in to a new database file and running that?