Search results

I have some code that sends an email when the database is registered. The problem is that depending on a users security settings on their PC they can stop the email from being sent (2007) How can I add to the code to make it check that the user hadnt cancelled the email? My code is: Private...

Im getting a compile error Else wihout If, its highlighting the Else that I have coloured red, Im sure its realm simple! If Me.chkboxRegistar = True Then If Me.txt_ContactsCount = "0" Then DoCmd.OpenForm "frm_Contacts", acNormal, "", "", , acNormal MsgBox "You dont have...

My form forces the user to send an email to me when using the database for the first time. I now have a registration number on the form that is hardcoded into each copy by me. It is held in (frmRegister.RegistrationNumber). I already have code to get the email to send but now ned to add the...

Thanks, but where do I need to insert it to get it into the boby of the email? I currently have: .HTMLBody = "<htmltags>This email confirms that a new user (email address to appear here) has registered a copy of Gundog Manager</htmltags>"

I want to automate an email to include the senders email addres with some text in the body of the email. Can somebody tell me how to it, thanks. Private Sub send_mail_Click() Dim olApp As Object Dim objMail As Object On Error Resume Next 'Keep going if there is an error Set olApp =...

My database is close to completion but I want to add a form that forces the user to register his email with me the first time that they use it. I was thinking about a textbox for the email address and a send button. When the send button is pressed it sets the checkbox to True. There needs to...

We were over complicating it! Between Date() And Date() -366 Thanks for helping all the same.

Just thought about this a bit more and maybe an easier way would just be to look for the 12 most recent dates (still dony know how to do that!)

Ok tried it but its throwing an error as follows: You did not enter the keyword And in the Between...And operator. The correct syntax is as follows: expression [Not] Between value 1 And value 2 Any idea?

I have a graph on my form that shows a dogs weight, the weights are taken monthly. As the dog gets older the graph is getting more cluttered so I want to limit the graph to show the last twlve months, I stress the last twelve months as opposed o to the alst year i.e January to January. Do I do...

Could you explain a little more on that please?

Thanks for the reply, from thisn I'm assuming that I cant just click on the listbox and edit the record 'live' so to speak, I have to go through another form. Shame as I think thats a bit long winded for what I want the user to be able to do.

I want to be able to edit an nbound listbox. The box consists of two cloumn, PersonsName and NoOfDogs. The PesonsName is would be edited from the Contacts form if it needed editing, which is fine as would the number of dogs that they owned. The listbox is on a form that shows how many people...

I have a listbox on a report and in order to keep ithings tidy I want it to fit the contents. I found this piece of code: Dim getListboxCountBeaters As Integer Dim setHeight As Integer getListboxCountBeaters = Me.listBeaters.ListCount ' Adjust Number Accordingly setHeight = 217...

I wonder if somebody could have a look at my attached DB please. the problem I have is; if you open the form frmEntries and select the top date in the listbox you will see that I have added the same person to the same listbox on the same record more than once. The name get added from the form...

I have an append query that takes an item (once selected) from a listbox and it appends the contact name to a new table. Is there a way I can make an append query thay takes the ContactID and the ContactName and append it please. The listbox box has column 2 Bound (ContactName) soeven though I...

OK heres the file, unfortunatley I cant downgrade the version to mdb as it says Im using a lot of the new features! If anyone can open it, open frmEntries and create a new entry. Close the form then open frmTasks click on the one of the entries in the listbox and then choose Beater, Gun or...

Yup, tried that and it allowed me to add Matt Smith as a beater to ShootID 001 but not to ShootID 002 as anything at all.

Ok ive had a good go at this but Im not getting the results that I want. By doing it this way I can only add a name to the table once. I want to be able to add it many times but only once to any record! My Field Names are: IDTaskings - AutoNUmber (Primary Key) ShootID - Number (This is the...

Ill try to explain, might have to post the DB. But here goes: the table is populated by selecting the indiviudal from a ListBox and clicking the add button (append qry) The person can be designated as a beater, a picker up or a gun, when they are added to the table they are also allocted to...