Search results

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 & "'...

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