Search results

I have a form, unbound, with a combo and a listbox. These are both bound to Select Queries. When a user updates the combo with their choice, and a record in the listbox is highlighted, an additional query will pull back all records that fall into this criteria. (The query refers to both the...

Hi all. OK, I have a search form that pops up as a Dialogue box, you enter the criteria (GMC Number), and click on the 'Search Button'. I have coding in place to account for if no record is found at this stage. IF a record is found matching the criteria, another form (Results) opens with...

I have a table of patient details with some that will appear more than once. I need a query that will only bring back those that appear more than once, and show the results in the relating report. A normal SELECT statement I have used to filter the results brings back ALL of the patients from...

What I am wracking my brains over is this: I have a query that will pull off Patient ID's and Their Referral Type. Simple enough. Now, there may sometimes be more than one referral type against any one patient ID. AND there may be records that contain the Patient ID with the same Referral...

I will try to keep this as brief as possible. This involves two tables, say, table 1 and table 2. Both tables are identical in design and fields, but when a date is entered in a specific field in table 1, append and delete queries are run to copy the record over to table 2 and delete it from...

This topic is about a query I am running. The query has three tables in it, one of which is a SQL view (Linked) Within this view are the following fields: Patient ID Date Of Birth GP Name PCG Name Start Date Now, the problem that I am having is, to be brief, Duplicate Entries on the query...

Hi there. You all have no doubt seen forum messages about rescaling, well here is another one ! I have developed forms at 1024*724 resolution, but some users have a resolution of 800*600. I need the code to resize the forms so that the 800*600 users can view the WHOLE form, just like I can at...

Hi. I have a couple of checkboxes on my form, once they are clicked (The Tick appears in them), I want them to be locked so that they cannot be unticked. Can anybody Help Me ? Many thanks, -NEIL L POPE

When a command button is clicked, it open a smaller form in 'dialogue' mode. What I nned to do is have the value of a field on the main form appear in a text box on the smaller form as soon as it is opened, which is bound to a different table. (There is a relationship between the two tables via...

I am using Access 2000 and on a specific form, I have 2 combo boxes which obtain values from different tables. What I am trying to achieve is the following: When the value is selected on the 1st combo box (In this instance under the field SPECIALITY), the second combo box (Sub Speciality) will...

I am developing a Db in Access 2000. Some users have a 1024x768 resolution, and others have 800x600. How can I set the forms to correspond to the appropriate resolution. It is designed on 1024x768, but when users with a 800x600 resolution look at it, they will miss some of the form. I have...

What I need to do is , IF a user ticks on a tickbox (Y) , then their user ID shows in another field. I already have other user Id's showing (=CurrentUser()) but this is dependant on the box being ticked. Anyone Help ? Thanks....NLP

Hi there. This is what I am trying to achieve: I have a form for adding details of users which I need to automatically give a 'USER ID' from the surname + first name + random number of 0-9. Under 'default value' for the field that will generate the User ID I have : "Me.(Surname)" & "Me.(First...

Is it possible to have a custom form in Outlook that can be linked to a form in an Access DB ? What I am trying to achieve is to have the values on the Outlook form imported to the Access form. At the moment it is a 'copy 'n' paste' job, but would like to get this automated if I can. Many...

I have a report that shows calls incoming on a specified date. At the moment, the seperate calls show on the report, by the means of daye entered. (What I mean is that if there are 5 calls on 14/12/00, then this date will show in a column 5 times.) What I need to do is just have the sum, in this...

Two of the fields that I have on a form are 'Call Type' and 'Please Specify'. 'Call Type' is a combo box with multiple values in. One of these values is 'Other'. What I am trying to achieve is to have the 'Please Specify' field to become required , ie, input needed, IF the call type value chosen...

Is it at all possible to have a command button that will search multiple tables instead of the source table on the form ?

I am trying to use the SendObject command to email the contents of the current form. Once the command button is clicked, the new message opens up fine, but EVERY record in the table is contained in the body of the email !!! I only want the current record to be displayed. Anyone out there who...

OK, this is about time. I have a field on a form that shows the current time [=Now()], and another that will show the current time plus 30 minutes. I need help in how to set the default on this field to be 30 minutes from the time in the current field. This is really easy, I know, but I have...

I have created a workgroup with about 12 users in it. I need to klnow of a way in which the details of the user who creates a new record will be shown on the form itself. I need it to be automatic, taking the user name and inputting it into a field. Anyone know how to do this ?