Search results

Hi, I have been trying to export a query as a text file including a date field. When it exports the data, the datye field shows the correct dates as enterend on the form of my db, but includes 00:00:00, which I assume is a time. Is there a way to omit this time being appended to the date ? Thanks

Hi, I have a list of people in 18 countries and I want to run a query to list people from countries other than Slovenia and Croatia I have been able to get the querry to work with 'not Slovenia' but cannot get it to omit slovenia and croatia 'Not Slovenia or Croatia' does not work Can...

Hi, Is there an easy way that I can run a query to find the age of a person based on their DOB ? (ie = 31/3/58 would show as 51) Thanks Adrian

Hi, I am trying to generate a new field with a unique number. I have used the number from the ID field (this is an autonumer and key) and the initials of the first and last name field and I would like to add the year at the end. I can get it to work with the whole date but have got stuck now...

Hi. I have a form with 2 fields - one called 'Grade' and the other called 'Type'. Each field has pre-determined entries (20 of them) as in the example below. Grade: Type: 1 = full 2 = Partial 3 = Semi 4 = Westward etc etc.. Is...

Hi, I have been given a DB which has 2 parts, the first file mydatabase.mdb which I open and another just called data.db The databases I have produced myself as I have been learning (in Access 2003) only have one file and no data file Can anyone tell me the difference, and benifits of 2 parts...

Hi, I would like to add a yes/no box to a table, and when I try to I get the message that I cannot because it is a linked table. Is there a way that i can unlink it temporarily to add the property and then re-link it? Thanks Adrian

Hi, I have a update query (to clear any selected tags) which I would like to have automatically run when I exit the database. Is there a way to do this. At the moment I manually run the query from a form button before I close the db, but sometimes forget to do it. Regards Adrian

Hi, I have this script (below) which I got from this forum but am not sure how to configure it, especially the last line. I have a form for each personal record with an email field and a tag yes/no box. I have created a query called emailQuery, calling up the field called 'EmailAddress' if...

Is there a simple way to select a number of email addresses via a tab on a form, and then clicking a button to open an email window with the addresses in the bcc? I think this is a tall order Thanks Adrian

Hi, I am trying to output a query to html pages and am struggling with templates. This is what i have done so far: Ny query has 6 fields. I have created an 'output to' macro Object Type: Query Object name: fullmemberlist output format: html outpu file....\..\.\.\fullmemberlist.html...

Hi, I wounder if anyone can help me with the following process. I have 2 tables with exactlly the same fields: one table called 'membership' and the other table called 'archived'. Normally, when I want to archive an individual's details (when they resign, or do not re-new membership etc) I...

Hi, I have a sum to show the total number of people who are attending a banquet on a summary report which works great - tells me for example that 170 people have booked to attend the dinner. " & (Count([ID])+(Sum([SatBanquetGUESTS]))) However, the banquet has a maximum seating capacity of...

Hi, I have been using this code to send an individual email from a record by d/clicking on the email field, and it works great: Dim StrInput As String StrInput = "mailto:" & Me![EmailAddress] Application.FollowHyperlink StrInput, , True What I would like to do is to send the email to multiple...

I have a form that has a text box field so I can type in 'Bob's' email address. Is there a way that I can then double click on that text box to open Outlook Express (my default mail client) ready to send an email to 'Bob' ? (similar to mailto: Thanks Adrian

Hi, I have about 30 queries and want to add three additonal items from the fields box to each one (which I forgot to add when I created the queries). Is there a way that I can do this all at once or have I got to do one query at a time. Happy New Year Adrian

Is there a way I can add at the base of a report, the number of records in a table? Thanks Adrian

Hi, I would like to be able to run a query that lists the number of years members have been subscribing (up to the current year). i.e. to show the year he joined, and how many years he has been a member (shown as a number). Is there a way to do this easily? thanks Adrian

Hi, Is there a formula I can use to put in a field (expires on) which will automatically generate a date in 12 months time - that is, sum of another another field (renewed on) plus 12 months? Thanks Adrian

Hi, I have a membership db with 120 members in it. Each record form includes a dropdown field for 'status' (training completed, no training, certificated etc), and another dropdown for 'profession' (childcare, nursing, education etc) I am able to run 2 separate queries; I can run a query to...