Search results

Is the data on the report going to be unchanged? If so and all you want is a different title, you could have, say, five text boxes on a form, along with a button. The user enters up to five different titles and clicks on the button. The code says something like Open report XYZ in design mode...

Then - in the spirit of avoiding any even slight argument, which this thread is almost managing - I am glad to hear my thoughts are occasionally worth continuing. (Now, if someone will just tell my wife.....) :D

Apologies if I wasn't clear. :confused: I see minimising the use of money as being equivalent to avoiding greed. Also, 'minimise' - when applied to money - also implies 'no luxuries'. I realise you could still be greedy for food, clothing, or whatever, but the discussion was about money, so...

I'd be willing to bet that they would, too. However, I don't remember them being given the option. The people who are in a position to do something (anything?) about the number of guns aren't the ones who supplied the $4m. If you tripped over a paving stone and I helped you up, my assistance...

They don't completely shun money, they minimise it's use. It's seen as a necessity, but only up to a point. Beyond that, it falls into the category of 'luxury', so they don't bother with it. http://www.msnbc.msn.com/id/15241580/site/newsweek/ This link applies to Ohio, but I think the rules...

I believe they specialize in unlawful arrests.

I've had exactly the same problem. In my case, it was a corrupt Db. Luckily, I was able to fix it by creating a new, blank Db and importing everything from the old one. Failing that, this may help http://allenbrowne.com/ser-47.html

You don't need a separate table for each customer. You need one to store details of all customers (address, tel no, discout rate if applicable, etc.) and one to store details of all work done. You would then link the two via the unique customer id number. One row in the work table would relate...

Format(date,"MMDDYY")

This link may help you. http://www.access-programmers.co.uk/forums/showthread.php?t=115646&highlight=hide+database+window

Just before your line telling the code to delete, add DoCmd.SetWarnings False but remember to set it back to DoCmd.SetWarnings True afterwards, or you'll never get warned.

Agree entirely. Is there an easy way to get it to look like it used to? I can adapt, but I know my beloved will be straight onto me as soon as she notices. :D

Fair point, some of these pictures are very out of date. Who owned the house before you, then? :D

No offence intended, honest. It was a joke, as I went through something very similar a couple of weeks ago. I still forget that people can't always get the writers intent, unless one of the smilies is used.

Create a module, call it whatever you like, then put this code into a new function within it. You can then call the function and pass in the name of the form and the field in question, each time you need to. That way, if you need to do something similar for various fields on various forms you...

There are probably plenty of ways of doing this, but you could try something like: If [Forms]![field name] = "" or IsNull([Forms]![field name]) Then Msgbox field name & " must be completed" [Forms]![field name].SetFocus End If The above would notify the user that the field...