Search results

Hi all, I'm using a piece of code to open a dialog window to find a file and then add it to field on a form where the file will be attached to an email and sent out automatically. The code - If Not IsNothing(MySet![email]) Then Mailcount = Mailcount + 1 Set appOutLook =...

Hi All, I have a report with an address block consisting of 5 controls (street,area,town,county,postcode). It has to be positioned correctly for a windowed envelope which in itself is relatively easy. My problem is I have a piece of code to shift the controls town, county and postcode up if...

Hi All, I tried to use this on an AfterUpdate on a textbox Control - If A>B Then Me!Control.BackColor=255 Else Me!Control.Backcolor=#FFFFFF End If I want it the background to red if A>B and to remain white otherwise but all I get is a black background when it should be white. I...

Has anyone else experienced their database close normally but fail to open with a "MS is unable to open" message? I can export all of the reports, tables and queries into another blank db but forms and modules hang. If I open the db in design mode, all's well until I try to open any code then it...

Has anybody had this problem with Requery? I have used this so many times in databases and had no problem, but in Access 2010, apart from other buggy issues, the requery won't work properly. This is what's its doing - 1. Open Main form with subform containg records in continuous form. 2...

Ok, I have code that is supposed to check for changed in a text box called 'Member' and apply a continuously updating filter to to a sub form... the code is - OnChange - Forms!AAA!AAASub.Form.Filter = "[Surname] Like " & Chr(34) & Me!Member & "*" & Chr(34) Forms!AAA!AAASub.Form.FilterOn =...

Hi All, Scroll bar in a sub form showing up to 30 records... When the receord list holds 30+ records the vertical scroll (wheel mouse control) works fine but when the list holds less than 30 records the wheel mouse will scroll but loses the top record form view and won't scroll it back. The...

Hi, Is it possible to browse and attach pictures to an email generated from Access XP VB? I already produce the emails but would like the the attachment option. Dave

Hi All, I want to build a query to select records based on time. My table contains the records - LogDate LogTime (Short Time format) I want the query to pull all the records for 24hrs back from now... I've tried Between LogDate AND LogDate-1 AND Between LogTime And LogTime-24 But it...

Hi all, I am running a 2003 database in 2007 and have come unstuck with an unexpected error message - Runtime Error 2282 The format in which you are attempting to output the current object is not available. This involves sending a report in the Snapshot Format - DoCmd.OpenReport "Incident...

Hi All, I am trying to use a memo field to record a list of names. I don't want to use another table. The form I am using can send emails to people selected by the user. The form then finds the valid email address and sends the email recording the addressee to the memo field list. The problem...

Is it possible to remove/hide the combo on the forms' Main Menu toolbar which says - 'Type a question for help'? Dave

Using Date1 and Date2 as user inputs I use DateDiff() to give me the months difference... Me!TM=DateDiff("m",Date1,Date2) But the results are not quite what I expect... If I enter Date1 as 01/08/2004 (dd/mm/yyyy) and enter Date2 as 31/07/2005 (dd/mm/yyyy) I get a count of 11 months, not 12...

Hi All, I have a report with a sub report. I want to number the records in the subreport from 1 to n so that the subreport will show a numbered list and the main form to show the total items in the subreport. The numbering is to aid the layout of the report only and has no bearing on the report...

I want to open Outlook with the recipients name in the To: box by clicking on the email address held in a subform list field... Any ideas? Dave E

I have a pesudo forum running on a server which sends emails automatically to a group to indicate that there is a new posting - much like any forum... I would like to include a link in the email (automatically) that will open the Access Forum and point directly to the relevant post... I...

I am trying to convert an Excel Macro to apply to a spreadsheet after it's been created and populated from Access. However, my experience with Excel code is limited and I find lines like - .Application.HorizontalAlignment = -4108 'xlCenter come up as 'Object does not support this property or...

I've used a routine that I found here to export data from an Access table into a formatted Excel Spreadsheet. But a few problems have cropped up... The routine is supposed to create a table from the sql query and then export the data to a buffer spreadsheet, strFile, and then copy it across to...

I have searched this topic but can't find exactly what I'm looking for so I hope someone help. I have a directory full of doc files which are constantly being updated. I would want to be able to browse the directory from Access and click on the relevant file to open it directly. So there's no...

I have 2 queries with the same source tables, fields and relationships. The only difference between the two queries is that the criteria for one of the fields is - =9, in one and, <>9, in the other. The problem is that in the query with the criteria is =9 the results show the GroupBy totals...