Search results

So I am looking at my relationship window and It seems like I haven't followed the correct approach. what fields and PK should I have in tblToolsForAssemblies? Thanks

Yes it does, I have just checked and I have used a junction table as you advised although I named it tblToolsForAssemblies with the PK on AssemblyToolGroupNumber however I didn't use it for the combobox. As the PK is different for every tool within the assembly how would I avoid duplicates in...

Yes that sounds like a good option but I already have PK set as AssemblyNumberSpec and one autonumber field in the table, Is there any way around this?

Hi All I have a combobox with 3 columns (Bound Column 1) from tblAssemblies, the issue I am facing is in tblAssemblies the first two fields are allowed to contain the same data but are differentiated by field 3. The user selects an entry from the drop down, but if they select an entry of which...

This works great but is there anyway to return the datasheet caption in the message box rather than the just the control name? Thanks

Good Morning, I have added the code and it prevents the error but It also allows the rest of my code to run still, Where within the code is the correct place to put it as what I need to happen is on click of the 'Save' button to validate the controls and if any empty controls are found stop the...

Thanks that really helps I have implemented the module but now when I press my 'Save' button the missing fields checks are performed as expected but I then get error "2051 the run command action was cancelled" (DoCmd.RunCommand acCmdSaveRecord) what is the best way to incorporate the checks with...

Thanks a lot for this, where should I put the code? In the On Click of the button?

Good morning, I am trying to create a code that checks on click if a textbox is empty and if it is it assigns a back colour and makes a textbox(* symbol) visible and then checks if the next textbox and performs the same routine until all have been checked. the end goal being if any are empty...

Tried this but getting couldn't find the field referred to in your expression If DLookup("AssemblyNumberSpec", "tblAssemblies", "AssemblyNumberSpec = '" & forms!frmToolGroupManager!Assembly_NumberSpec & "'") Then Also should I be putting the code in the before update event?

Sorry forgot to specify the data field is short text

Hi All I have a bound text box (Assembly_NumberSpec) and field (AssemblyNumberSpec) in tblAssemblies. What I need to happen is after the user has enter data into (Assembly_NumberSpec) to check for any duplicates and in (AssemblyNumberSpec) in tblAssemblies If duplicates are found I need to...

Hi All, I have a search text box in my forms and frequently have end users enter irrelevant information into the text whilst trying to search which results in no matches found. Can someone help with some code to remove certain words(That I can specify from within the code) from the text box...

Thanks a lot this is perfect

Hi, I have created a form which emulates a split form following the example database found here https://www.access-programmers.co.uk/forums/threads/how-to-emulate-split-form.293854/post-1536716 This works fine however when I am trying to implement a search function with the following code I...

Evening All, I have an issue when I run some VBA code that only happens in a certain order. When i run Application.RunCommand acCmdDeleteRecord this deletes the record as expected however the problem I have is after this if I try and run Me.ID.Enabled = True Me.Location.Enabled = True...

Hi All, I have a tblTools with over 2000 records and 10 fields, 2 of these fields are Machine and Tool Type. Can some explain the bestway to handle changes to the two fields so that it It will update all the records automatically? I.e Of the 2000 records around 800 of the Machine field is 20...

Yes I use these fields (Sort Order Machine & Sort Order Tool Type) to sort in the report. What I need is a way to mange the above fields without having to manually manipulate the table. (I would like to admin user to manage this through a form) and to update any records in the table affected by...

Hi All, I have a tbltools that has 12 fields in total of which 2 fields (Machine & Tool Type) that I need to apply a custom sort order to in the user report, so I have have added two sort fields to the table (Sort Order Machine & Sort Order Tool Type) this approach works fine but I need to...