Search results

  1. C

    Hiding/showing groups of controls based on combobox value

    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...
  2. C

    Filtered combobox

    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...
  3. C

    Dynamic toggle buttons to control values in a single table

    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...
  4. C

    Dynamic forms

    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...
  5. C

    Value based on if ID is present in another table

    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...
  6. C

    Macro(?) condition

    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...
  7. C

    Query including combos and a checkbox

    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...
  8. C

    Cascading combo boxes help

    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...
  9. C

    Mandatory fields on subform

    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...
  10. C

    Help with design of stock control database

    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...
  11. C

    Behaviour on close button

    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...
  12. C

    strsearch not working

    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...
  13. C

    Error when re-querying subform

    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...
  14. C

    Using AND, OR and BETWEEN

    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...
Top Bottom