Recent content by Darrell Wootton

Hi, I know how to prompt for information via the QBE for an existing field, but how do I create a new field in an existing query that will also prompt the user for a variable when the query runs? Thanks Daz....

Hi, I am trying to find how to remove the padding or space from a string. I have imported data and when I use vba to manipulate the string there appears to be loads of padding on the end of the data? ie: "Mr A Customer " instead of: "Mr A Customer" I cannot find...

Hi, Is there a way when using LIKE to specify a field from the same query? ie: Like "*Wells*" returns records including the terms Wells. I have tried using a fieldname: LIKE "[FieldName]" LIKE "*[FieldName]*" But I can't get it to work. Thanks Darrell....

Hi, I am looking for advice and pointers on hows best to achieve the following: We have a reports system, the reports are written and working. Here is where I need advice: The user needs to email the report information to the end users. We use MS Outlook. We have a global address book with...

Thanks, that works fine. Darrell...

Hi, I currently use the calendar control (mscal.calendar.7) with a database to choose dates. I use the calendar to automatically insert a date into a date field on the form. This works fine. However, is it possible to use the calendar to insert data into more than one field at a time and...

Hi, I have a problem with a time field in my db. I have a field that captures start and finish times. When I use the data through a query and into a word doc the time format shows as: 09:30:00AM instead of 09:30 AM If I run the query from the qbe, the output shows: 09:30 AM So the...

Thanks for the reply, I will try it. Daz...

Hi, Pulling records from db to show course joining instructions, then merged into word. I need help with query to show dates: ie: Monday 21st August 2004 I can sort out everything except 21st, 4th, 2nd etc StartDateDD = Format([StartDate],"DD") Already in Right Format...

Hi, Can anyone me with this problem. Query 1: People Who Cancelled a Course Query 2: People Who Attended a Course Fields: DelegateUID-CourseName-CourseDate-UserName-CancelledCourse From the queries shown I need to create a list of people who cancelled a course (EG: CourseB) but who then...

Hi, The reason names appear in two tables is: The records were sent to us by a third party company who want to know if we have had the same customers in our db as they do in theirs. So i am comparing the records for matches. I have imported their table of customers into our db and I am...

Hi, I have been trying for the last two days to get this piece of code working: However I am having no luck. I need to use the names in table "one" With the first name and go and see if exists in table "two". If there is a match(s) It then ticks a box for every match found. Once it has...

Hi, I have been looking for a way to get a date range I need. IIF([Period]Between DLookup("[DateFrom]","Period") And DLookup ("[DateTo]","Period"),[Advance],0) This currently returns data on the following period "01/01/2004" to "01/05/2004" This part works fine. In the same query I need to...

Hi, Why is it that sometimes when I am in a forms code window, and I toggle the breakpoints against the code that i want to follow, that i am unable to run the code? A window comes up named macros with my modules in, but I want to run the Sub that I am working on in my current form. This...