Search results

I have a form that is used as a holding table for records which, once checked, are appended to a final table and then deleted from the holding table. This is done using the following code on a button, which simply runs the append and delete queries. (the queries run on a filter which sorts out...

Hi I have a main form "Tender" linked to a subform "Project" - which shows single records at a time. The user has navigation keys to move through all Projects related to a single Tender in the main form. The parent-child relationship is between a field "Tender" - However I also have a second...

Hi again! I am trying to create a report that runs from a crosstab query, though it has just occurred to me that at the moment, there are less columns in my report than there potentially could be. The crosstab query the table is based on uses a lookup field to create the columns and at the...

Does anybody know how you can change the colour of a tabbed form,so that the background of the tabs changes? Many thanks Emma

Hi! I have a main form (job)with a subform (object-job)for objects related to jobs - objects are selected from a combo which looks to the main object table. On the subform, I have a button which opens the objects form which opens as a dialog box keeping the focus until it is closed, so that any...

I have a database with three fields: year, autonumber field and object type. My client wants me to create a unique record number to be used as the primary key using the year field and the autonumber field, so for example: year autonumber object primarykey 2001 1 pot...

I have a database with three fields: year, autonumber field and object type. My client wants me to create a unique record number to be used as the primary key using the year field and the autonumber field, so for example: year autonumber object primarykey 2001 1 pot...

If I use a combo box to go to a particular reocord in on a list of records, how do I change the colour of that records text so that it stands out from the rest of the records? My code for the combo is: Sub Combo44_AfterUpdate() Detail.Visible = True ' Find the record that matches the...

I have two fields on a form, both combo boxes. One is a value list (TYPE) which is one of three values (type1, type2, type3). The other combo looks up to a table SPECIFIC, and this records specific information and may have several specific records relating to Type1 etc. If the user selects a...

Hello again! I am trying to get the value entered in a field in a main form entered into a corresponding field in a subform. So, for example on my main form I have a field "Phase" and on my subform I also have a field "Phase2". When the user updates the "phase" field in the main form, this...

Hello! Does anyone know how I can get a form to open on startup, if the value in a field in that form is null. I have also posted this topic on the Forms forum, but I wondered whether I could use a piece of VB code to solve this problem. For example I have a form that should only ever open the...

Hello! Does anyone know how I can get a form to open on startup, if the value in a field in that form is null. For example I have a form that should only ever open the very first time a database is opened, which the user must enter a name into a field. This information is then used in other...

Hello! I have a small piece of code, which when the user selects a value from a drop down list (field A), if that value is "other", the information from another list (field B)is pasted in the comments box when the comments box gets the focus. They can then add any further information into the...

Hello! I have a small piece of code, which when the user selects a value from a drop down list (field A), if that value is "other", the information from another list (field B)is pasted in the comments box when the comments box gets the focus. They can then add any further information into the...

Hello I have a message box that comes up to warn a user that they have incorrectly filled out a record, and all I need to know is how on earth do I get a carriage return in a message box, so that "close this box and check your record" should be on the line after "this record is not fully...

I have a piece of code which runs when a user leaves the last control on a form. The code displays a message box which asks the user whether they want to add a new record (select yes). Selecting no will display a second message box, which asks whether they want to exit database (yes) or close...

I have a piece of code which runs when a user leaves the last control on a form. The code displays a message box which asks the user whether they want to add a new record (select yes). Selecting no will display a second message box, which asks whether they want to exit database (yes) or close...

I have two columns in a table - box number and object number - and many objects can be in a box. I need to create a label for each box number, listing the box numbers in the box - so it would look like: Box 1: object 1, object 2, object 3 object4 The size of the labels means that the object...

Please can anyone help me! I need to show certain fields when a value is selected from a combo box - so if a user selects "A" from a combo box, they see fields 1,2 and 3 or if they select "B" from the combo - they see fields 1,2,4 and 5. Ta!