Search results

I have an Access 2003 database split FE/BE. Back end is on a server - local front ends. One table is causing problems - or to be more precise one field. This is a memo field that is becoming full and hitting an overflow problem. The data in this field is notes about various discussions held over...

I have a main form with a sub-form The main form (frmStudentDetails) is bound to the "Students" table The subform (subfrmVisits) is bound to the "Visits" table e.g. each student can make many visits. I also have a button on frmStudentDetails, which opens a linked form (SMSdata) that is used to...

Hi, I have a multi-table database in Access 2003 - the problem I have concerns just 2 of the tables the rest is fine. Table 1 Client Table 2 Visits The client table records the client’s personal details - name, age, gender etc. The visits table records the date of the visit and a series of...

Hi, I have a multi-table database in Access 2003 - the problem I have concerns just 2 of the tables the rest is fine. Table 1 Client Table 2 Visits The client table records the client’s personal details - name, age, gender etc. The visits table records the date of the visit and a series of...

Hi Everyone, I have a problem finding the last record in a recordset, which I am realy having problems getting my head around. I have a form - Client with a subform to book further appointments. On the main form is a combo box to select the client - this populates the subform which shows all...

Hi Folks, I know emailing from Lotus Notes has had quite a few airings but this is a new twist. I have been sending emails with SNP attachments for a couple of years without any problems. However, our IT people has seen fit to change/upgrade our mailboxes to version 6.5 so that staff who hot...

Hi Folks. I have exhausted my search capabilities on this and can't find an answer - maybe I'm asking the wrong thing. Hope someone can help with this, its driving me mad. I'm using Using Windows XP and Access 2003 What I am trying to do is use a third party post-code finder to complete...

Hi. I have two databases, both originally created in Access 2000 on a Windows 2000 platform. database A has links to two tables in database B. Both databases are on a shared drive and are accessed daily by 10 concurrent users. Originally these links worked perfectly and it did not matter how...

Hi, I have a report works fine in Access 2000 - Does't work so well in 2003 The problem is I have a six line address made up from six seperate fields, ADD1, ADD2 etc. If I just place the fields in line under one another any blank field produces a blank line - not so good when there is the...

Hi. I have an Access 2000 database running on Windows 2000 Operating System. The database is on a shared drive on a network with approx 20 concurrent users. It runs a bit sluggishly so I am looking for ways to speed things up. The network guys say that the bit rate is OK so I need to tweak the...

I have a form that has a memo field. If text in the memo field is highlighted and I press the enter key the text is deleted. Does anyone know how to prevent this from happening? I know it is easy enough to click off the text (deselect it) so that pressing the enter key will move me to the...

Returning public variable as a Report name? I have 3 reports that all require start-date and end-date parameters entered when the report is run. So far I have a seperate (identical) dialogue box for each report that provides these details. All works well. To slim things down a bit I am trying...

Hi All, Is it possible to link tables that are in different databases that are in the same folder on a shared drive using the old fashioned "dot" syntax that used to be used in DOS. You remember .\..\ etc. and if so how. UNC referencing won't work here because.... What I have are several small...

How do I make a variable both public and static? At least I think that is what I want to know - let me explain. I have a form that I get to from a button on another form. The following code is on the button click event and works fine, Private Sub Special_Needs_CmdBtn_Click() On Error GoTo...

When does a form lose focus? I have a point in my routine where I have two forms open at the same time. Form_1 and Form_2 I want Form_1 to close when it loses focus, so I put the code: DoCmd.Close in the On Lost Focus event of Form_1 but it doesn't work. I can move to Form_2 and enter data...

I have a database that I inherited, which I now have to maintain. Works OK in the main but one table is causing me problems. The key field ... Student ID is a 9 character text field. There are several possible entry formats for this S******* = 1 letter and 7 numbers S******X = letter, six...

I have an A2K database on a shared drive - usually with 8 to 10 concurrent users. Recently we have experienced some network difficulties whereby we temporarily loose contact with the server. This is NOT a problem related to Access but to a Netware system upgrade. However, the first you know...

Hi, I have a multi-user database sat on a shared drive. It has upto 10 concurrent users. I've got two forms REGISTRATION and SPECIAL_NEEDS both forms use the same underlying query for their data The Registration form always opens in add mode expecting you to enter a new student. It also has...

Help this is doing my head in. I have not set anything up yet as I can't work out how many tables I need and thus what the relationship should be. Here's the problem: I have a number of students with support needs. OK make this tblSTUDENT I have a number of support workers. Let's make this...

I need to write to a group of students about 500 who have met certain criteria - I know their name and student number. The student number is the unique identifier I use in my Access 2000 database. However, I foolishly expected central records to provide Term-time addresses for my study group...