Search results

I have an Access 2013 database containing a number of unique ‘Clients’ and each client has multiple events attached including the date of the event (actually it is the date the information was received). Currently there are 4000+ events for 100+ clients. I am having difficulty with a query in...

I have a database which among other things records how jobs are received – i.e.: Telephone, Email, Mail, Facsimile or Web. For each client I want to identify the percentages of each method of receipt against the total of jobs received and during different time periods. I have created a make...

A2007. Default date format is day month year. I have a text [Time Stamp] field with the data imported from an Excel spreadsheet in the form of "3/21/2012 8:14:52 PM" or "3/12/2012 8:52:11 AM" - the US format. (Attemps to change to a date format in Excel failed too - it seems Excel does not...

Hi From examples in this forum, I have used the following code several times under a command button: Email.HyperlinkAddress = "mailto:" + EmailWork to successfully open an email in Outlook ready to complete the other fields (Subject and Body etc). I used the same code in a new database...

Hi, I have an intermittent problem with a memo field that I cannot duplicate or identify a cause. I am posting it here just in case someone has experienced the same situation. The database is in Access 2007 and is split Back End on the server and Front End on four desktops. This problem has...

I have the same problem occuring in two separate databases, one developed in Acc2007 and an Acc2003 database opened using Acc2007. When closing either program to exit Access, I get a message "Microsoft Office Access has stopped working. Windows is checking for a solution to the problem". It...

Hi I have A2003 with SP3. My problem is occurring in two separate databases. Both have forms with a list box receiving data from queries. The forms list box displays various category totals and the category percentages of the overall total. That is until after installing SP3 (I think...

Hi In a query I am trying to return all dates (birth dates) within seven days either side of the current date. The properties of the field and the query are set to Medium Date and the criteria I am using in the query is: Between Date()-7 And Date()+7 and returns nothing. I have tried...

Hi, I am using Access and Word 2003. I have a query listing a number of people [Witness] and a number of questions [Question] for each of those people. Because I need the flexibility of a Word document I have created a mail merge document (based on MS KB Q294686) that uses the query to...

Hi, From this forum I have been able to include a double click on a listbox to view the selected record in a form. However I am having difficulty filtering records on a continuous form by double clicking a listbox field. The subform is populated by a query and while initially I need to have...

Delete Reference: Trying combinations I found one that works!!! The second line should read: Me.Filter = "AdminDateCompleted Is Null" Hi, I want to filter records from a form with a button to isolate all incompleted tasks. Incomplete tasks are identified with an empty field...

I require to publish a report from Access (A2000 but running in Office XP) in Word and save it in that format. On occasions a report generated will consist of two full pages with one Memo field (narrative of the event recorded in the d'base) capable of extending the report to the second page or...

I am working in A2000 and consider myself a novice Access user. I have one form in the d/base with a subform imbedded. The form derives the information from a query getting information from two tables (One main table the other a town/postcode table). When I delete a record from the form the...

I use A2K but also require A97 to maintain some older d/bases on other computers (friends and sporting clubs) not yet upgraded. I deleted some rarely used programs the other day to make room on C drive, Visio was the only MS program deleted. Yesterday, on attempting to add another control...

The following is code I am currently using in an A2K database to add new work units to a table when the combo box detects an entry is not in the list. This was provided to me from someone who knows a whole lot more about programming access than I. (Self taught and still lost with VB...