Search results

I've got a subform which displays some basic details about a client appointment (date & time etc.) Due to space limitations on the sub form I want to display some more detailed information about the client who made the appointment on the parent form. What I want to happen is that when any part...

I had this problem too. I tracked it down to a known bug in Access 2k that was solved by running a service release patch. After the patch was applied the problem went. So just ensure that your Service release is current and it should be problem solved...

I've got a table with a Yes\No Field. When I base a query on this field I get either a -1 /0 or a checkbox displayed in the query. I want to display this data on a report but the usual trick of formatting the checkbox field on the report to display the text won't work as the records source for...

Hi, I've got a form which shows data from an underlying query. One of the fields [EndDate] can either have a date in or not. I want to be able to select and display records with or without an [EndDate] from a combo box on the form - the afterupdate event on the combo would presumably need to...

Just been asked to work out a way of matching two UK addresses by using distances based upon UK postcodes - "show me all Customers within X miles of this postcode" type thing. I know there is some Commercial Software around (that's where they got the idea from) but is the raw data available? I...

Nearly there... Harry, Not horribly wrong, frighteningly right! Great ! :) Using your code changes, I've got it to cycle through all of the Files in the folder. However it seems to falls down on the value checking - it says all of the files are ok, and in the attached demo 3 are fine and 3...

Hi, I'm trying to loop through all of the Excel Workbooks in a folder and for each, check the value of a cell. If this value equals X then I want to move the file to folder A, if it does not then I want to move it to folder B. I've got parts of the code to work, I can do both parts but lack the...

Fixed it ! :-) Michelangelo, Thanks for your reply, I came back to post my own fixed version and found your fix! Essentially we'd done the same thing, which was to fix the rowsource of the combo. My new upload shows a static and a Choose template version of the Merge to Template. Hope...

Demo file attached I want to output a single record to a Word Template. I got a single template version of this working with a hard coded path to the template. But I wanted to choose a different template, i.e. use the same info, but write a different letter. I set up a combo with the template...

Found it! After a little creative searching on this forum I came up with: WordObj.Selection.GoTo what:=wdGoToBookmark, Name:="Address2" If IsNull(rsCust![Address2]) Then WordObj.Selection.TypeText "" WordObj.Selection.TypeBackspace ' Delete this bookmark! Else WordObj.Selection.TypeText...

Remove Empty Bookmarks in Mail Merge? Hi Carol, or any other person who knows more than me - and that's quite a few! :-), Just followed through Carol's answer in this thread and got my Merge to work fine (and first time!). What I'd really like to know is how to remove blank lines from the...

I want to set up a Mail merge (actually just a single record) from an Access form. When the routine runs I want the "Choose Template" dialogue to open so that the user can choose which standard letter to use. I know that the Templates should be set up with "BookMarks" that can be filled in...

Hi, I've got the basic structure as below: tblProperty (1:M with tblAccommodationEvent) tblUser (1:M with tblAccommodationEvent) tblAccommodationEvent tblAccommodationEvent has foreign keys of PropertyID & UserID and StartDate & EndDate fields. Each property can be used by each User many...

Further Clarification please :-) Chenn, I'm assuming that this Routine will run from inside Access and not from inside Excel? I know the range of data, say it's Sheet1!a1:a20 So, assuming I can get to each workbook in a folder in a loop where does your code come in? Dim iRow As Integer...

I've got to import a great many Worksheets into a database. Each has 2 worksheets Worksheet1 has the company information but this is laid out in 2 Columns: Column1 Column2 CompanyName: Smiggins Mouldings Address1: Brick Lane Worksheet2 has the Product Information...

I've got a situation where I've got a whole load of Spreadsheets I want to import. I can loop through all of the files in a folder OK. Some of them have got a DataRange defined within them and some not (two versions of Workbook used) I want to move all of the files with the data range in to...

Can't get my email reports to work Chenn, You say you've got Email reports working, I've tried using several bits of code found here and on other forums but can't get it to work. I'm using Access 2k. I get a message saying "Error 13 Type Mismatch" Any chance of seeing if I'm doing something...

I want to examine a specific cell in each workbook in a folder prior to import to look for a unique ID in a table. If it exists, then I want to send a message to the user that the data already exists, not import that workbook and go on to the next workbook . This is the code I used to iterate...

Hi, I've got to append some data from an Excel workbook, OrganisationName.xls into two tables in a database. In the workbook I've labelled two ranges, RangeOrganisationInfo (to go into tblOrganisationInfo) and RangeEmployeeDetails (to go into tblEmployeeDetails). The data must be appended in...

OK, I have a number of Clients (Male and Feamle) who can answer Yes or No to a number of questions each time they visit. For example: Do you like apples Y/N Do you like pears Y/N Do you like plums Y/N I want to add up the total females who like apples, the total males that like apples, the...