Search results

I got it sorted. Snapshot Viewer is installed by default here: C:\Program Files (x86)\Snapshot Viewer\ Depending on your system, yours might be C:\Program Files\Snapshot Viewer\ So all I didi was use Environ("ProgramFiles") to get my default directory and then check if snapview.exe exists...

Perharps I can get a help on this. How can I determine if Snaphot Viewer is installed using VBA? I want my App to be able to check and prompt the user to download a copy of the add-i from Microsoft. Thanks.

Good afternoon, Please I need your assistance. My code works fine when I send only one file but it doesn't when I have muliple files. I have tried to use the following (just a portion of my code) without any luck. 'Declerations Dim iCount As Long Dim iArray() As String ...other lines of...

Hello everyone, I use SMTP to send emails from my application. This works very well when I use a dial up connection but fails when I am behind a firewall. I get the following error: Run-time error '-2147220973 (80040213)': The transport failed to connect to the server. What I want to do is...

loTd is a TableDef as in: ------------------------------------- Dim loTd As DAO.TableDef ------------------------------------- I forgot to include this too that is called in the previous code in my previous post: ------------------------------- Public Function PathDBExist(MyPath As String)...

Hello Everyone, I have this function working perfectly in AC2003 but not in AC2007 format -------------------------------------------------------- Public Function fGetLinkPath(strTable As String) As String Dim dbs As DAO.Database, stPath As String Set dbs = CurrentDb() On Error...

Thanks for offering to help. This is the function I used in calling it: Public Function FTPDownload(txtFileToDownload As String, txtDownloadFileName As String) FTPDownFile ELookup("ftpHostName", "tblSMTP"), _ ELookup("ftpUserName", "tblSMTP"), _...

Hello and happy new year to everyone. I have been using this code in my application to download files from my website and it works well except that it downloads the file to my Documents Folder. Is there a way I can change the default location to download file to another location say the...

I finally got it sorted out and it works for me well. Thanks for helping out. Private Sub txtEntry_Change() On Error GoTo Err_ErrorHandler Dim strStartSQL As String Dim strWhereSql As String Dim strMobileSql As String Dim strWhereSqln As String Dim strWorkPhoneSql As String Dim strEmailSql...

I got it working with just this line of code: rstInvoice.Bookmark = rstInvoice.LastModified The append query needs that to copy the line details from the tblFinanceDetails.

I have the following code to duplicate my invoice (mainform and subform) form. This works well, thanks to Allen Brown. _____________________________ Code Begin _______________________________ Public Function DuplicateInvoice() On Error GoTo Err_ErrorHandler 'Purpose: Duplicate the main...

I have been able to sort this out and the code works well now. I can create a recurring schedules based on the user input on my recurring form. I have another code that checks the recurring table to see if any scheduled invoice date is <= today. If any is true, it calls the Function...

Hello Everyone, After searching for a week I found the attached to be close to what I want. The attached only works for weeks and not months or years. I want to be able select an event, indicate the number of occurrence say once a week, month, quater or year starting from a particular day...

I have tried the following options none seems to be working for both serach string criteria at all. Maybe I am missing out something. strWhereSql = " WHERE QryEmployeeList.EmployeeName Like ""*"" & Chr(34) & " & Me.txtSearchExpression.Value & " & Chr(34) & ""*"";" strWhereSql = " WHERE...

Hello, I have a search button which works fine when I search for a name like Barry but when I'm looking for names with apostrophes like O'Jay I get the following message: Syntax error in string in query expression 'QryEmployeeList.EmployeeName Like "*" & 's" & "*";' Can anyone point me to...

I came across this strange error for the first time. I am trying to export all my access database objects (Forms, Queries, Reports, Modules) to another access database file. While some of the object will export successfully, about one or two forms and modules will not and give the following...

I was recently faced with the challange of generating all the payroll for a particular month for all employees before adding any other deductions and earnings individually. This way the process will be faster when I have a lot of employees on the system rather than processing each payroll one...

Re: Windows Property Not Showing I got this resolved by removing only my profile on the machine without re-installing Office 2007. With a new profile I am able to work normally.

I agree with you because I have been in one place in the past 15hours. I will try that and see what the outcome is.

I am having the same problem on all my files. I have tried the particular database on another machine (Windows XP - OS) and everything works fine