Search results

Please can someone tell me what I need to do to fix this strange behaviour? For the pat 2 days my computer (including all active windows) willl refresh itself every other minutes. I might be typing something and it happens and have to set my focus on the document or application again. I don't...

Hello Everyone, The idea of what I want is simple. I want to be able to deploy my front end to a user without the back end. All the user will need to do the first time he needs to use the app is click on a button to create the data file. A little bit of HOW TO do this brought me this far...

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...

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...

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 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...

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...

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...

Hello Everyone, I noticed an unusual thing today. While on design view, my properties window doesn't show any more. Even when I right click an object and select properties, nothing happens and this has prevented me from setting any property. Can anyone point me to what I need to do to get this...

I am trying to build a small payroll and so far everything has been OK until now. The challange I have is calculating the PAYE (Pay As You Earn) personal tax from the employee total earning. I my country the tax rate for PAYE is applied on a graduated scale as shown below: - First $30,000 at...

Dear all, I have a BIG challange and I confident someone here can assist me. I have a list box with whose row source is a query (QryEmployees) bout to the table (tblEmployees). On my form I have a search box that filter the information as you type a serach item. What I want is to be able to...

Hi, I have a record of my staff members. I display this on a form using a list box. What I want to do is to be able to click on various buttons each with an SQL statement like the one below that will filter the data by Today, This Week, Last Week, This Month and This Year. The code below works...

Hi There, I have run into a problem I haven't been able to work around. I have a complete database where I open all my form mostly using this type of command: DoCmd.OpenForm "frmOrders". Now I am trying to redesign my database using a sourceobject where I can open all my forms directly into...