Search results

Howzit Is the name of the report correct?

Howzit Also, does the lookup return a valid value and does it have the fiel extension in the name?? If not you will need to add the extension on as part of the file name: ' Filename strFName = DLookup("[Dlr_Fax]", "99 - Dealer Email") ' Add the file extension strFName = strFName & ".pdf"

Howzit This part is wrong. You want to remove the currentproject.path bit if you are going to specify a default loaction. What you are doing is adding the S Drive mapping to the existing location the database resides in. Not what you want Change: 'Initial Path strDPath =...

Howzit It's not quantity that is important but quality. I like the fact that you can make a post one day and say yep that's me done for a couple of years. Catch ya later.

Howzit Try this Private Sub CalcPlusandMinus() CalcWeight = CalculatedWeight LW_Less5 = (LoadWeight / 100 * 95) LW_Plus5 = (LoadWeight / 100 * 105) If CalculatedWeight >= LW_Less5 And CalculatedWeight <= LW_Plus5 Then MsgBox "True" marker = "green" CalculatedWeight.BackColor = 65280 'Green...

Howzit Get the users to create a new txt file in the back end location to determine if it is a permissions issue or not. If they can cereate one then one can assume that it is not a permissions issue. Did they get the correct copy of the front end when the took a copy?

Howzit Sorry I'm not entirely sure. I know that from with in excel it is something like Application.displayalerts = false Try testing to see if the file exists first, and if so kill it. Something like If Dir(strPath) <> "" Then Kill (strPath) 'Delete (strPath) Else 'your other code...

Howzit See this post for the answer

Howzit As an example you can do this. The code is on the sheet_activation. Just navigate to one of the other sheets then back. I had to save as a .xls file to upload it for some reason. Please save as a 2007 format

Howzit Each user will need to have their own copy of the front end on their desktop. Then they can go mad playing with it. You may want to do a search for Front End Updater so that any changes you make to the master will be picked up by the users.

Howzit You can use dlookups to get that info - there are only 3 of them so not that onerous. I assume your query only returns the one record? If not, what uniquely identifies the record in the query to allow the dlookup to get the correct data - we will need to add in criteria clauses in the...

Howzit What version of Excel are you using? In Excel 2010 there is an option to not show data in hidden rows and columns (Rt Click in Chart >> Select Data >> Hidden and Empty Cells. An option is to hide the rows that show NA - if it is relevant to your version of course. YOu can use vba to...

Howzit I use Access 2010 - I have just tried Rookies suggestion and it does show linked table manager in the list of options when you rght click a table. This is of course on the basis that you have at least one linked table. If you have a db with no linked tables, then this option does show...

Howzit Hold your horses mate. Try this - you will need to modify it to meet your needs Private Sub Command21_Click() Dim strRep As String Dim strDPath As String Dim strFName As String ' What report to send strRep = "rptBookings" ' Initial Path strDPath = CurrentProject.Path & "\" '...

Howzit Use the datead function in your query Date_Finish:DateAdd("yyyy",[table1]![duration_year],[table1]![start_date])

Howzit Give this a go. You will need to change where the filePath and Filename are coming from as I have modified this so it works on mine. I have also not taken into account anything to do with protecting \ unprotecting sheets. Please reinstate them. Sub CopyRange() Dim wb As String Dim...

Howzit Sorry - that is a little out of my league as I have never tried this. You my want to read this for more information

Howzit Put it as an action on sub exit. Something like the below: Private Sub cmdSendEmail_Click() On error GoTo err_cmdSendEmail_Click MsgBox "Hello" exit_cmdSendEmail_Click: DoCmd.Close Exit Sub err_cmdSendEmail_Click: MsgBox Err.Description Resume...

Howzit Something like this will work - you will need to have referenced in the Outlook library. Private Sub cmdEmail_Click() Dim sTo As String Dim sCC As String Dim sBCC As String Dim sSub As String Dim sBody As String Dim strCC As String Dim OutApp As Object Dim OutMail As Object Dim...

Howzit See this - I have done this recently (have since moved on to custom ribbon to see how it works). You custom menu does come into Access 2010 - they will be in the Addin tab) and can be used.