Search results

Hi - I have a FE/BE Access 2000 database that is currently used by my department to record details of events etc at the company where I work. I have realise that it would be useful for other depoartments in the building to be able to query the database - the best way would be to give them a...

i have an IIF statement that runs to check the contents of a form before it is updated. I was wondering if it is possible to check if no field on the form has a value? Basically, i want to add to my IIF statemnt so that a user doesn't get trapped by my validation rules firing if they have...

Hi I've got 2 forms set up, in such a way as a user can click on a button on the first form, and it opens the second form showing data related to the first form. This works ok. When a user tries to add in an extra record in the second form, there is a primary key violation error because the...

I've got some code as follows **************************************************** Sub Form_BeforeUpdate(Cancel As Integer) If IsNull(Me.Lead_Partner) And IsNull(Me.Details_Descriptions) Then MsgBox "Please enter the Lead Partner's name and some information in the Details and...

Some users are complaining (not without reason, I might add) that the error messages that Access throws up are too complicated to understand. From searching the forum, i've found a useful piece of code to use for custom error messages. Could anyone please tell me where to find a list of error...

Hi I've got a custom menu bar to launch forms and reports, as well as 2 append queries. At the moment, I use openquery macros (in conjunction with the Sertwarnings command) to launch the append queries. This works OK, unless the user presses cancel on the query, where I get an ugly macro halt...

I need to add a column to a table in my split database - what is the best way to go about this? I have an unsplit version of the database - do I need to edit this, then import the data from the existing db and roll the whole thing out again? I'm hoping not! G

My database is used to track the firm's activities - I use different forms for each different type of activity to simplify data entry. Many of my forms contain a subform that allows users to input the names of employees involved in a given activity - The subform looks up users from the Users...

A couple of the forms on my database have a lot of fields and/or a subform. To smarten up the look of these forms, I would like to have either a) tabs that allow me to split the form into 2/3 'pages' b) a button that takes you to more fields. this would let users look at a page on a form...

Hi I have never used VB before, so could someone tell me, in foolproof steps if possible, if I can create a single piece of code that can control record select buttons in a form. Using a previous example of code from the forum, I was able to control buttons on a form, but would like to be able...

Hi My database holds details of department activities in a table named 'Activities' (somewhat unsurprisingly) each different type of activity has its own seperate form, to aid data entry. The problem that i have is that 2 activites are related - Deals and Press releases. A Deal will almost...

I've got a report that needs to be exported to MS Excel. I have run into a problem where a memo field which views OK in the report is truncated to 127 characters in length by the time it reaches Excel. Does anyone know how to stop this? PS I'm using a macro that Uses OUTPUTTO Excel and...

Hi I have 4 reports that are based on parameter queries. Each report shows a list of business activities and related info over a date range that is set as the parameter. The 4 reports together form a single report that must be circulated to the company. I would like to save time by making a...

Hi I am working on a new access system at work (my first project of this kind), and would like to make a query that acts a bit like a trigger. I have a main table called activities which holds data about departmental activities. When our company makes a deal, a press release is sent out. I...

Hi I am currently involved in my first access project at work, and have come across a report problem that is beyond my (rather limited) skills. I need to produce a report that shows a list of activities, along with a list of the people involved in those activities. The activities are listed...