Search results

You can construct the full address using str_Address = str_FirstName & "." & str_LastName & "@email.com" Adding it to the 'AfterUpdate' event of the second field should do the trick.

I believe you just need to change the end 'False' to 'True'.

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...

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

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...

First snow for this Winter, in the area I live fell last night. Nothing heavy (yet) just enough to look pretty. Temperature is exactly 0 degrees.

You would store the name of each state and the number of days pertaining to each in a table. Now, say you have Texas = 40 days, California = 45, etc., when you enter a date value into a field on the form and a state value into another field, you could use the DLookup() function to find the...

The DateAdd function should be what you need.