Search results

  1. M

    Possible issue with SQL connection String

    Good afternoon. We're running an Access front end using SQL Server 2005. We have 2 seperate offices which use this application. The 2 office are linked wirelessly. One office (our call centre) uses it constantly, and this office has the SQL server and everyone is hard wired into the network...
  2. M

    Very slow link to Outlook Address Book

    Good Morning All, I am investigation some methods in creating a contacts system for our ever growing and very messy contacts list in outlook. As I'm experienced in access, I felt this would be my best method. Using forms and linking the contacts with many other tables and systems already in...
  3. M

    Cannot filter on Date Fields in Access - MS Access Crashes

    Good afternoon all, I'm struggling to find a solution to an issue I'm having when trying to right click and "filter for" on a FEW date columns in a linked table. This also happens in queries when i add a filter for the same fields. However when I filter on the same columns in a form, there...
  4. M

    Problem with Mouse Wheel in a sub form

    Hi All, I posted this in the other post in this forum but it doesn't look like any has read it, and now it's becoming more of an issue to my customers. My appologies for the double post! I have a form with one subform. I'm using Lebaums mousehook.dll system to stop people from scrolling...
  5. M

    using recordsets with Dynamic queries

    Hello, What would i put "val" equal to if the query will always output 1 result? for example, if rst!DataColumn was "SerialNumber", and rst!Query was "qrySerialNo" sql = "SELECT " & rst!DataColumn & " FROM " & rst!Query Would be sql = "SELECT SerialNumber FROM qrySerialNo" and i would put...
  6. M

    Getting Attachments from Unread Emails in Outlook

    Afternoon, I'm setting up an email addy which clients can send data to. I want to write a bit of code that will take attachments off any unread emails, validate them, and send replies depending on the outcome (this needs to reply to the original email). Also, depending on the outcome i would...
  7. M

    Importing data from spreadsheets - phone data

    Hello peeps. Before i continue: I know very well about excel's annoying removal of leading 0's. And i know it can be solved by making the column type, Text, not a number. :) What i'm working on is an excel spreadsheet importing module which validates data from clients and sends error reports...
  8. M

    Regional Tier structure - Help needed

    Afternoon. I'm working on a relational database for all of our clients and wish for it to be generic for the big clients and the small clients. My main table has fields "CompanyCode", "RegionCode" Some companies have 18 regions, others have 5 or less, some have none. For some of our clients...
  9. M

    Outlook Contact Managament via Access

    Hello, I've read through http://www.access-programmers.co.uk/forums/showthread.php?t=139656]this thread which has given me a huge boost in the direction i need for a contact management system I am building. Now, the problem i'm having is that I'd love to be able to add my own columns to this...
  10. M

    Grammar Checking

    Hi guys, I did search a lot for this so please excuse me if it has been mentioned before. (on searching "grammar" i came across quite a lot of flaming!) I'm looking for a way to check grammar in memo fields. There's a few things i've looked at and either come across issues with my inexperience...
  11. M

    Annoying Problem with exporting text fields

    Hello, I have some code which creates an email and inputs data from a form. One of the text boxes has carriage returns in it like below: "Hello World World Hello" When it gets put in the email it displays as: "Hello World World Hello" I really need to keep the vbCrLf. I've tried the below...
  12. M

    Importing Excell cell numbers (e.g. $A$1) into a new column

    Hello, It's been a while since i posted here for help as my skills are getting really good! Anyway. I'm writing a system that imports spreadsheets from our clients into our database. I have made it so it can import as many spreadsheets as possible at any one time and it loops through them...
  13. M

    Regular Query Problem

    Here's my query. SELECT CheckFieldSheet.[Company Name] IIf([CheckFieldSheet].[Phone Number 1 *]=[tbl_clients].[Phone Number 1 *] Or [CheckFieldSheet].[Phone Number 1 *]=[tbl_clients].[Phone Number 2 *] Or [CheckFieldSheet].[Phone Number 1 *]=[tbl_clients].[Phone Number 3...
  14. M

    Weird Problem with report affecting access

    Hello, I have some complex reports which are giving me some real hassle. The process is this: In a form, they pull down a report name in a drop down box, then a print button appears. That button will append all needed records to a table called "tblVisual" using an append query, and edit every...
  15. M

    Visibility dependant on data in a different group

    Hello. I have a report which shows Company's percentages and their regional percentages. Everything below 70% must show, but everything 70 or above musn't show. The visibility is based on region name. So for example, if "Company A" was 85%, but one of the regions was only 65%, then Company A...
  16. M

    Dealing with Internet Explorer via A Form

    Hello... I created a button that opens a link to a URL and copies information from a record to the clipboard to paste on this webpage. The users are not using it correctly (they need to close the page each time they need to do the next record). what i want to do is to close ALL IExplore...
  17. M

    Grouping many different dates

    I have a query which has many sums and counts on things like "Company name", "region name" and "Development Name". I'm using this query for a report to do lots of percentages with, but now i need to filter this also by a date period. So the user choses "Alex Homes" as the company name and then...
  18. M

    Report Printing

    We all know that there are numerous different methods of printing to PDF. I want to know the easiest, and cheapest method to do so. All i want to do is print to PDF with a specific file name and bring up an email with it attached... the email part is easy, but with printing to PDF, some...
  19. M

    Dates Not updating subform RecordSource

    Hello, I have a dropdown menu which has a lisrt of dates (mmm yyyy), and when one is selected it updates 2 boxes with 01/mm/yyyy and 30 or 31/mmm/yyyy Private Sub cmbDate_AfterUpdate() Me.frmData.Form.RecordSource = "SELECT * FROM qry_NatxReg WHERE [Company Name]='" & cmbCompanyName & "'...
  20. M

    Getting new twips after "can grow"

    Hello, I'm wanting all txt boxes in my report to be the same height. 2 of my 24 side-by-side text boxes can grow, because there can be between 1 and 4 lines of data in them. One method i have to make them all the same size on format, is to calculate solid figures on one line and multiply it by...
Back
Top Bottom