Recent content by bobsyeruncle

How can i display Name and address in the same box on my report? They are stored in two seperate fields in the table. The box has a border so i cant just sit a 'name' textbox on top of the address one. I am assuming i am being pretty thick!

Pretty Pretty Please ..... i'm pulling my hair out:)

Create an empty report and use sendobject. Private Sub butEmail_Click() Dim stDocName As String stDocName = "EmptyReport" ' DoCmd.SendObject acReport, stDocName DoCmd.SendObject acSendNoObject, stDocName, acFormatXLS, Me.Email Exit_Command26_Click: Exit Sub...

I have tried this both ways ... using just the main form and using the subform too. I am stuck! The end result i want is ... When user selects school name from combobox ... the fields on the main form are populated with the contact details. I then want the command button to open a...

In this DB i have the main form and subform (not visible) When you click button it opens subform. I want this subform to add a new record with the visit details. HOW?:confused: I am a Noob and learning all the time so play nice:p

You are an absolute star! Thank you so much

Here is a copy of the original DB with all data removed for data protection. this was also before i had created the extra table and form for recording progress. Hope this helps

Rota is the visit frequency ... most schools recieve an annual visit however some are two yearly and some three yearly. So the rota form creates a report for all schools that receive an annual visit or whatever the user wants to query. Last Visit and Next Visit due are annual representations...

Thanks for your help. Here is another quick screenshot with all the detail you requested. I'll have a look at the link you provided.

Data Entry is set to no. I have never overwritten the records before, so i tried that just now but when i open the subform all i get is the new record details and if i open the table itself there is only the new record. This is a relatively new DB, to be honest i am a complete noob with...

Here is a screenshot of the relationship with my two tables open and the main form in the background. I have removed/hidden some data etc. hope this helps

Here is the code behind the button as asked for Private Sub cbuPROGRESS_Click() On Error GoTo Err_cbuPROGRESS_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmPROGRESS" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_cbuPROGRESS_Click: Exit Sub...

Yes Can't answer that at the minute .... i'm sitting at home enjoying a steak pie and won't be back to work till mornin!

Hi all, I have a form which contains name/address of businesses with a subform button for more information. The subform contains date of last visit, a yes/no tick box and a short comments box. What i need is to keep a record of all visits automatically after the subform is updated. The...

Thanks .... i ended up using a sendto command using a blank report. It seems to work