Morning everyone,
Despite a fair few searches I've not been able to find the answer to a problem I'm having.
I have a combobox with a list of countries (around 300 values). These countries all have a value between 1 and 10 depending on what status they have. On the same form is a subform with...
Evening all,
I have a combobox displaying guest types. The row source is from a table called 'tbl_guesttypes'. The values are:
[PK] [GuestType]
1, Royals
2, Heads of State
3, Premiers
4, Governors
5, Heads of Department
6, Ambassadors
7, Prime...
Hi all,
I will try and keep this as succinct and to the point as I can, more for my own sanity and to save me getting confused and ultimately rambling.
I am trying to create what is essentially a sort of diary system in Access (2016). I know this isn't ideal and I should probably explore some...
Hi all,
I'm not even sure dynamic forms would be the best way to go about this, please let me explain what is required.
I have information that needs to be stored per country. These countries belong to different categories. The country category list is the front end of the database (at least...
Hi all,
I'm in the process of creating a database that keeps track of tokens and has the ability to link these tokens to users.
I have two tables, tbl_users and tbl_tokens.
tbl_users.AssignedToken is a lookup to tbl_tokens.TokenNumber.
When a token is assigned to a user I would like...
Hi all,
I wonder if you anyone can help. I am using a modified version of the Northwind database and now just tweaking it slightly. I have my tabs along the top, one of which is 'Products'. When this tab is clicked a form (frm_productsmain) is called into the main window displaying my...
Hi there,
I have a form with 4 combo boxes, a free text field and a checkbox. All are unbound. A user can select what sort of records they want displayed by choosing options from the combo boxes. This I had working fine, until I came to add the checkbox.
I have since added a field called...
Hi all,
I have a table for my products (tbl_winestock). In here there is a field (Grade) that looks up values from tbl_grade.
tbl_winestock
ProdID (PK)
ProductName
Grade (FK)
tbl_grade
GradeID (PK)
Grade (A1, A, B, C etc)
In tbl_winestock it is possible to have 2 identical products but...
Hi guys,
I've built a form that lets users enter generic details for a purchase order (Customer name, description etc). Within this form is a continuous sub-form where product lines are entered.
On clicking the Save & Close button I'd like to check for mandatory fields. I have managed to get...
Hi,
I've been tasked with designing a database to look after our stock of alcohol. There will be stock being used (consumed) and stock being ordered and replenished.
The old data will be coming from an existing Sharepoint/Sql solution and is in one huge table. I'd like to split this up to...
Hi all,
I have a bound form, the contents of which are simple. 1 bound field where a year may (or may not) be entered.
I have Data Validation on this field (yyyy).
I have the form working to a degree. Here's what I have:
Private Sub cmd_closeform_Click()
If IsNull(Me.txtvintage) Then...
Hi all,
:banghead:
I have a form with a subform containing 'tbl_winestock' in datasheet view. On the form are some controls.
A text box (txt_searchproductname)
A command button (but_searchProductName)
When I enter text into the txt field and click the button, nothing happens. Focus is...
Hi all, I'm hoping someone could help me with an issue I have with a new database I've created.
For now the setup is simple, I have a form with subform. This subform displays a table, the contents of which are altered depending on what you choose in three combo boxes.
I receive the following...
Hi all, first post here so please bear with me :)
I have built a query which you can see below. It basically looks at various fields in a form (frm_casefilters) and pulls the relevant information from my table.
Everything works fine. I'd like to make one addition though.
I'd like to add the...