Search results

Thanks for your reply however when i tried that i get a compile error, wrong number of arguments or invalid property assignment.

I am trying get some fields filled in based on if a record's tick bock in a table is true. This is my code If DCount("[Based_Customer]", "tblACDetails", "[AC_Ser_No] = Forms![FrmAirFrame]![AC_SN]", True) Then But i think this is the wrong formula, being half asleep can anyone help!!

No just beeps

I have a form that shows the records found in a query if the completed tick box is false. this is fine, but i have also put the tick box on the form, and wish the user to tick it when they are done how ever they, get a beeping error and wont let you change it to true. Can anyone suggest the...

Ok with some help i got it to work like this... Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As Integer) If Base.Properties!Text = "LTN" Then Address.Caption = " Address A" Else Address.Caption = " address B" End If End Sub

Excellent i got it to work, as i saved the html code as the text file and read the file in the same way, and just changing the format of the email itself as in your example made it work. Many Thanks for your help

Reverting back to the if statement this is my code Private Sub Report_Open(Cancel As Integer) If Me!Base = "LTN" Then Me!Address = "LTN Address" Else Me!Address = "STN Address" End If End Sub And i get 'Compile Error: Else without If' Seems strange to me as that looks normal

Well the example you gave me enables the user to type the email in the form. However if you have 100 emails to send, you wont want to write each email, therefore like i originally did, the email address is got from the list of recipients you want it to go to (maillist) and then the body of the...

I tried that but i get the error that it has no value... Private Sub Report_Open(Cancel As Integer) Select Case Me!Base Case "STN" Me!Address.Caption = "STN Address here" Case "LTN" Me!Address.Caption = "LTN Address here" Case "FAB" Me!Address.Caption = "FAB Address here"...

I am trying to change the text to unbound text box dependant on a condition of a field on the report. So on open if the base is STN the text will be STN's address and if it is LTN then it is LTN address. I have written some code that adds the address to the box dependant on base, but i get...

Hi i am trying to enter a number as 000748 but being a number field i removes the first zeros anyway i can force them to stay, bearing in mind that if the field went to over a thousand, i would want want to enter it as 001748. please help, thanks.

sorry i should have put this in the reports section!

am i able to read in the body from a html file?

I have written some code that adds the address to the box dependant on base, but i get the error message Compile error: end if without block if. Private Sub Report_Open(Cancel As Integer) If Me.Base = "STN" Then Me.Address = "address here" End If End Sub Can anyone explain this...

Hi, I have written this code to send an email to a selected list, it works using the redemption code which will stop the Outlook access violation error. This is found at http://www.dimastr.com/redemption/ for those of you who what to try it. The coding takes the list creates an email puts the...

Hi, i am trying to perform a beforeupdate event on a record, but seem to be getting an error. The undo function works fine but it cannot save, i would be grateful if someone can help as the error is unclear. Code: Private Sub Form_BeforeUpdate(Cancel As Integer) If MsgBox("Are you...

Well from what Pat i thought that maybe i should try binding the form. Once i changed the master/child links it worked. So Thank you Pat

Hi Pat Thanks for the reply but no its just a new form started in design view then added the cmbo box then the subform.

I am trying to create a form that has an unbound text box which row source is a field in a table. I have created a subform that gets the records from another table. Both tables are linked in a one to many relationship. When a user selects a record in the cmbo box i want the table to show only...

I wondered if some can advise me as to how to make help files and linking them in to the dabase. i.e. if someone clicked on a certain section for help then it would go to the help for that section. Is there an easy program to help write the files??