Search results

Hello all, I have a combobox on a form which filters a query. When nothing is entered into the combobox, the query lists all results excluding null values. This is what I want, but I also want the null values included. I am using the code below: Public Function fCboSearch(vCboSearch As...

Hi, I would like to have a combobox on a form, which allows one to select a year, and upon doing so this will filter the records displayed in the subform so that it only displays those records from the selected year. To do this, do I need to enter a VBA code into the 'after update' property of...

I have a main form and a subform. The subform displays fields also visible in the main form such as 'Name'. When I click a button on the main form it opens this subform. The problem is this: Everything works fine with existing records, but when I click a button on the main form, to open up the...

Hello all, I would appreciate some help with the following: I have two images per record on a form (img1 and img2). I want their visibility to be determined by a single clickable button (btn1). Once clicked on I would like this button to change its text caption to either 'On' or 'Off' and the...

=DLookUp("[Colour]","Colours","[Colour_ID] = " & [Colour_ID]) =DLookUp("[Colour]","Colours","[Colour_ID] = " & [Colour_ID]) This statement controls a textbox on a form. It looks up a colour ID number on the colours tale, and presents the name of that colour on the form. In many cases a colour...

The records which are viewable in my form seem to end at record 655, after which any new entry is recorded in the underlying table but not appearing in the form, which is very odd. There are no filters in place that I know of. Any ideas of how I can get to the bottom of this? Thanks, Mark

Hello all, So I have two tables each with a respective form. tbl1 frm1 tbl2 frm2 tbl1 stores the bulk of the information, and occasionally further information will be stored about a particular record in tbl2. Tbl2 does not list all records, but only those that have additional information...

I have a table with the following headings Date | Day | Weight | Start Weight| When I enter the first date, I would like subsequent dates to enter themselves below for 32 days in this Date column. Similarly in the second column 'Day' I would like it to autofill the Day from 0 - 32 (zero being...

Hello all. Can somebody please tell me the correct way of entering the above statment in the afterupdate coding of combobox35 Many thanks

I have various text boxes in a Microsoft Word database, which I would like to be linked to different fields in an Access database. Ultimately, I would like a situation in which clicking on a button in my Access form, brings up this Word document with the details for that specific Access...

I have an options group for colour with options: White, Black, Grey, Brown, Other. They are recorded as numbers 1-5 and on the underlying table. How does one go about recalling this information. Do I need to create a seperate table with two field such as 'number code' and 'colour' and then...

I am recording weight change in eggs over time during the incubation period. Each egg has a unique Egg_ID, and are listed in an underlying table, with details such as parent IDs, date laid, etc. I would like to incorporate a weight change chart within a form. It would show how the weight has...

Rather than write out each pathway for each image for each record, is there any way one can click a button, which opens up a browser so that you can locate the image on your hard drive, and then the pathway to this file is stored in your underlying table so that the newly found image is...

I have read that Access requires additional software or coding to do this. If you know how to do this without the need to install additional software, please let me know - and I am new to Access so would appreciate it if you broke it down into steps (particularly if it involved coding) I have...

Please consider the following situation. customer_ID 1 2 3 Customer_name Bob Henry Jo On the form I have a box for both the ID and the name. I know them by name rather than ID, so when I type 'Bob' I want the form to autofill '1' into the customer_ID box. Any help would be much...

Dear all, Firstly, I am very new to MS Access and indeed the forum (hello!), so I am very pleased to have stumbled upon this website and hope that some of you might be patient enough to help me out. The situation: I breed birds as a hobby, and I am trying to build a pedigree database to keep...