Search results

Hi, I'm using Windows 2K SP4 and have just installed Office 2003. Everytime I open Access I get a message asking if I want to block unsafe expressions (presumably macros). How can I turn this off? BTW I've downloaded all of the security updates, which are recommended by MS. Thanks

I have a report, which lists the staff in several offices throughout the UK (the user can select which offices to include). Users want each office to be on a seperate page, so I have put a page break in the footer of the office group. I have also put a label in the footer, which displays the...

I have a subform, which allows users to select several offices that they want to send a task to (the task details are on the main form). I then have a continuous form, which displays the outstanding tasks and the offices, which are associated with the tasks. Unfortunately, Access will not allow...

Hi Guys I'm hoping you can help me with this as it's driving me NUTS :eek: The database stores info about which offices within each region have been assessed by which assessor. I have four tables TblRegion - stores the regions TblOffice - stores the offices within each region (lookup field...

Hi I have 2 tables in the database I'm currently creating. TblRegion, which stores the region the employee works in, and TblStaffDetails, which stores their contact details. I have the region field in tblStaffDetails, which is a lookup combo box from TblRegion. I have a dynamic report, which...

Hi I am creating a staff database and have a form, with checkboxes, that allows users to select which fields they want to view (firstname, address, etc.) and then only the selected fields are displayed on a form. I am currently using the "Left" property to move the textboxes and labels...

Hi I'm creating a staff database and have a form with option buttons on, which allow users to decide which fields they wish to view. I have used a bit of code on the reports open event, which hides the column if the option button isn't selected, but I need to move the columns so that there...

Hi I am creating a fairly simple staff database in Access 97. The 'tblDetails' holds all of the staff information, such as firstname, surname, intials, address, email_address, etc. I have created a multi-select listbox that allows users to select, which fields they want to view i.e. surname...

Hi Guys I was hoping someone could give me an explanation of why: 1 - If you use a short date input mask in a textbox and you want to trap Access errors (2113, 2279) you have to use the code on the Form_Error event and not the textbox Before/After_Update event. 2 - If you use a query to find...

Hi Guys I've got 2 general Access questions. 1. Can someone please explain the difference between DCount and DLookup. I've used both in a d'base I'm completing and as far as I can tell, they seem to do very similar things. 2. Is there a limit to how many workstations that can use one Access...

Hi Guys I have 2 tables - TblCostCode, which lists all available cost codes and TblPhotocopy, which users can enter jobs. Each job has a cost code. I want to be able to list all of the cost codes that haven't been used between certain dates. I can display all of the cost codes that have never...

Hi Guys I have several reports, all of which need to be printed out. In order to make the reports 'more meaningful' I have a textbox on the report header that shows the type of report and the dates. I've used the following code in the control sourceof the txtbox: ="Report For " &...

Hi Guys I've created a form with 3 textboxes, TxtStart, TxtEnd and TxtTime. The user enters the start date, end date and the amount of days that the job takes. TxtStart and TxtEnd use a short date input mask. After the user presses the 'Search' button a query runs and a report opens, which...

Hi Guys I'm just about to finish the database I'm creating and as it's my first 'live' project, I'm feeling quite pleased with myself. It's only a small database that will only be used by 6 people. 2 administrators who will run reports, and 4 users, who will only be able to input new data...

Hi Guys I've created a search form that allows users to search for particular details by month, year and campus. All three are combo boxes. After the user has made their selection they click on search, this runs a query and opens a report with the details for the month and year at a particular...

Hi Guys I have a search form that allows users to search for records between certain dates and a combo box that will allow them to specify the records of a certain campus. At the moment the user enters the dates and the campus, they click on the search cmd button, which runs a query and a...

Hi Guys I'm trying (unsuccessfully) to create and End If statement within another End If statement. Here's what I've got so far. Private Sub CmdClose_Click() If IsNull(Me.TxtCompletion) Or IsNull(Me.TxtCopy) Then MsgBox "Please complete ALL of the details", vbExclamation Else...

One quick question Hi guys I have a textbox on the form that allows the user to enter a date in the format dd/mm/yyyy. I've used an input mask to show the user how the date should be entered and it appears like this: __/__/____ This works ok, but only until the user enters the date in the...

Hi Guys I have 2 tables, one, TblPaper, has Paper Size, Paper Quality, Paper Type and Price. The other, TblSale, has details such as date, staff name, unit price and total price and has a n-1 relationship with TblPaper. I've created a form based on TblPaper and have a combo box on the form...

I'm currently designing a database for a univeristy reprographics department and am having a sloght problem. I have 2 tables- TblStaff, which contains Autonumber, Surname, First_Name. TblUsage, which contains info about photocopier usage as well as Staff_Name (link to TblStaff) I have a combo...