Search results

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

thank you. I'll look into this.

Thanks for the post Minty. This makes complete sense but I'm not sure on how to carry this out. Should I be using a lookup field?

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

This is the calculation I'm using to work out the [Stock Level] field: =Nz(DSum("OnHand","qry_stock","ID=" & [ID])) Would I build the '>0' into this somehow? Thanks again David

Thank you for your help. I'll give this a go.

I did. I get a parameter box pop up asking the user to input a value. I am :banghead:

The stock level is a calc. field located on the products fofm and is worked out based on 3 other fields including 'InitialValue', 'quantityused' and 'quantitybought'.

Thank you for your reply. I can get neither to work. I think this is because 'Stock level' isn't a table field but is a calculated field. The datasheet's record source is a query and I can't see 'Stock level' as a selectable field. Thank you. I hope I'm explaining this sufficiently.

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

I almost have everything working. The only thing missing is the checkbox value. What I would like is this: - when the checkbox is checked then records where [Closed] is unchecked are returned - when the checkbox is unchecked for ALL records to be returned Any ideas with this? I have tried...

I received a syntax error using your last code. I had a look and now have this which runs but returns no results even when the text field has something in it. OR ([CMP]=Forms.frm_casefiltersedit.cbo_cmp)) AND [FCO_lawyer] Like Chr(34) & "*" & [Forms]![frm_casefiltersedit]![txt_lawyer] & "*" &...

Thanks. Any idea on how to build in the free text field (using LIKE I guess?). I have tried this but to no avail: ....AND [FCO_lawyer] Like "*" & [Forms]![frm_casefiltersedit]![txt_lawyer] & "*" OR [Forms]![frm_casefiltersedit]![txt_lawyer] Is Null );

OK, I've built in the various comboboxes and now have this: SELECT Cases.Case_Type, Cases.Funding, Cases.Litigation_RAG_risk_rating, Cases.CMP, Cases.FCO_lawyer FROM Cases WHERE (((Forms.frm_casefiltersedit.cbo_casetype Is Null) OR ([Case_Type]=Forms.frm_casefiltersedit.cbo_casetype)) AND...

Thank you for your reply. I am currently trying to rebuild the mess that was the SQL code from the original query. I have this so far, which works: SELECT Cases.Case_Type, Cases.Funding, Cases.Litigation_RAG_risk_rating, Cases.CMP, Cases.FCO_lawyer FROM Cases WHERE...

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

ID is the PK in tbl_winestock The videos helped a great deal. Thank you for posting those.

So I have it working to a degree. When I select a product in the first combobox only the related grade is shown. What if I now wanted to cut out the duplicates (as in the example above) in the first combobox? Private Sub cboproduct_AfterUpdate() ' Set the grade combo box to be limited by...

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