Search results

Hi, Its been a long time since I last posted, so hello to all. I am looking to create mail folders in outlook for each job, I can then store all emails to do with a job in the one place. I currently do this manually, but I create other folders automatically and thought that I should be able to...

Hi, I have a button that opens multimap at the desired postcode. This works well its really handy however I would now like to open the page, print it after loading, then close the page. Is this possible I am sure it must be.... For those that don’t know www.multimap.com searches for a map of...

whats wrong with this Hi Started working on a database again after 6 months working on other stuff. The problem. I used this code to cerate the start of the path, which has supposed to look at the subform and insert the text. strFile = Me![qryPaths subform].Form![PathCorr] I get run time...

I am getting an error, :confused: I have not worked with access for a while and it is more likely that it is something simple it is error 2544 You entered an expression that has an invalid reference to the property form/report The property may not exist or may not apply to the object you...

I think this is caused by the on current code looking for info from a sub form the subform looks at the current form for job number to calculate year the year is then used to create the file path. I think it is finding the year to late. this could i suppose be solved by storing the year...

Well this is strange I have a combo box that lists all of the files in a folder on the server. This works if I use G:\Building Design\Projects\ But I need to use the UNC path So it is \\sac039\global$\Building Design\Projects\ This however doesn’t work, combo box comes up blank all...

Well what I want to do is filter the Field [Completed] to show the records where that field is null. I want to have 2 buttons to click the first to apply the filter the second to remove the filter. I can do some of it Private Sub Command215_Click() Form.FilterOn = True End Sub Private Sub...

Hi Well my problem is I have created a button to export data to word then save the information in a specific file for each separate job. This works fine if I use a short path name but the files that these documents are in have long paths ie: \\sac039\global$\Building Design\Projects\2002...

I have a Report takes invoice 3 totals from a query then adds the total of all invoice 3's. The problem is that if there have been no invoice 3 the total comes up as an error how do I stop this. I want it to say £0 My Control Source is =Sum([Invoice Amount 3])

I want to change the colour of the text if the check box is ticked I have use similar code for it being = to "Completed" But I can't get it to work for "Yes" in a check box. Here is the code I have used Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me![Inquiry] =...

I have a date that inserts automatically and for speed users thought using + and - to increase and decrease the date by one day would be handy. I tried Private Sub Received_Change() If Me.[Received].Text = "+" Then Me.[Received].Value = Me.[Received].Value + 1 ElseIf...