Search results

The following is the code being used for the module basAudit module. Is it an issue with the ID field?: Sub AuditChanges(IDField As String, UserAction As String) On Error GoTo AuditChanges_Err Dim cnn As ADODB.Connection Dim rst As ADODB.Recordset Dim ctl As Control Dim...

I have been using the great guide at https://www.fontstuff.com/access/acctut21.htm to create an Audit Log in TblAuditTrail in my example database. This allows me to track any fields that have been tagged with "Audit" in the Tag property. The code below is the snippet which is added to the...

I have an Access Database which has a bit of VBA code which aims to take a file on a user's desktop and send it to a shared I: drive on the network with the filepath being saved in the database. sPath, sFile and savePathDirectory are all set up to be Strings, however I cannot seem to be able to...

I have managed to dynamically reference a bunch of filepaths in my database saved to a field called FilePath. The links are full filepaths in the following format. I have added the square brackets to identify items that vary depending on the item uploaded: H:\BackupOfAttackments\[ID]\[File Name...

The reason I did it in both is that it was the only method that seemed to work... Doing just the main form frmOverview didn't work and I am not sure why it didn't flow through the subforms as well.

And we have a winner! It is always the simple things that I miss... Any personal tips for how to prevent me missing stuff like this? I definitely think I should comment on my code more.

Hey isladogs, I previously used the Forms!FrmOverview.Requery code, however that made my Form jump to the very first record of data, which was not what I wanted to happen. I did a bit of googling around and read that using Forms![FrmOverview].Form.Recordset.Requery would solve the issue of it...

I have created a Multi Select List set up where I want the user to do the following: The user clicks the Edit Icon to go into an "Editing Mode" (achieved by a Form opening up). The user can then highlight an item in the Fleet List or Position List e.g Bus and then click the + or x to move them...

I tried it and ended up finding that moving them to their own forms made things look good enough for what I wanted the user to see, whilst being a bit more intuitive for me to edit. This decision doesn't seem to have bitten me yet, but I appreciate the suggestion. Seems as though there are many...

And update to the above - the code I am using is: Private Sub FinishIconFleet_Click() On Error GoTo Err_FinishIconFleet_Click DoCmd.Close Form_frmDimmer.UnDim Forms![FrmOverview].Form.Requery Exit_FinishIconFleet_Click: Exit Sub Err_FinishIconFleet_Click: MsgBox Err.Description...

I am having a play around by moving the items that were inside of the subform for the multi select list and making them into their own form so that it will give the effect I was looking for. Now I am currently struggling on how to make Access perform the update once I have updated the data in...

Edit: Oops I noticed that I hadn't deleted the On Load and Data aspects of the Form that I was trying to load and play around with. Classic case of how copying and pasting from 1 database to another is a bad thing to do unless you ensure you copy across the relevant modules / code / set up etc.

Cool I have downloaded the AttentionSeek database and it looks as though it is going to be a really useful resource. When using your dimming code to fire when something is clicked, I am running into an issue when I try getting it to open a Form. Any idea what might be causing this issue and...

Some pictures attached to aid the explanation. When I click the Edit Icon, I will want the Form to end up looking like the image in "Desired Look Of Editing Phase.jpg" and then when I click on the Tick Icon, for it to go back to the "Back To Non-Editing Phase.jpg". What options are there for...

I have a couple of List Boxes that work together to allow the user to make multiple selections for the Applicable Fleet. During the non-editing phase, the left List Box is hidden. When I click the Edit Icon, the Event fires and makes it visible. At this stage, I would like the rest of the Form...

Thanks I will have a bash at it.

I get how the combo box would work for the "Part Number" aspect, however I am struggling to get my head around how I would then do the "Position" aspect? It might be that I didn't explain it well in the beginning. When initially setting up a new "Part Number" in the database, I will want the...

I really don't know where to start with this, but will try to explain the situation as best I can below, but by all means ask me as many questions as it requires to get us looking into a nice solution: Goal: To collect a set of "Position Selections" for each Part Number in my database. What...

If the Tab Page Name was something with a space e.g Customer Support would I use Customer_Support or [Customer Support] in the place where Reliability is?

Hi Arnel, Can you explain why the Me.FrmSubReliability.Form!PartID part works? Why does it not need to be Me.FrmSubReliabilityProgramme.Form!PartID? I have another SubForm called FrmSubFinanceProgramme and have tried copying the the fields over to use the following code, but it does not seem...