Search results

I have an Access database where I would like to create a Captcha on a Form. I'm doing it more as a test of my VBA knowledge, but I have hit a snag where I have been unable to get my code to completely randomise the string generated. The string (displayed below the Captcha label) is what I will...

I have a Table called TblReliabilityProgramme which has 6 Fields that I am really interested in (I know the entire Table has 9 Fields/Columns, but these 6 are the main ones I am interested in): Title Intent Cost Reference Frequency ConceptionDate For a little feature I am trying to create on...

I have the attached database which we can use as an example of what I am trying to achieve. I have a main form called FrmOverview which has a TabControl item inside of it which has 2 Tabs - General Information and Reliability. When a user creates a new record, the user has to input details in...

I have a Tab Control on a Form with 3 Tabs which I want the user to fill in to populate the database. As part of this, I would like to give the user an indicator as to what Tabs already have data added into them and which ones do not and therefore need looking at. I have a few questions based...

I have a piece of code that is giving me the attached error message when I try running the VBScript Script File. This code worked perfectly when it was in my Access Database, but I am trying to learn about .vbs files so tried to replicate it in Notepad and VBS. I think I have traced it to the <>...

Hi all, I have a situation that doesn't seem to match most examples that I have found via a google search and it might be that I am searching for the wrong thing. We are using a piece of 3rd party software which is pretty restrictive in how it can link to other pieces of software like Tableau /...

I have been dealing with this issue for quite a while by just accepting it happening, however I am now wanting to ensure things are lining up perfectly and am wanting to use the Top and Left Properties for objects to align them. However when I try aligning two items next to each other, they...

I have been designing a Form in MS Access for a while and whilst I was moving items about and changing their colours, I noticed that one of my Labels was showing a white line down the left hand side of the box. I tried checking all the border properties and couldn't spot where this white line...

The Record Navigation Buttons in MS Access are pretty recognisable once you have been using the programme for a while. I would like to change their appearance a little bit and add my own spin / add additional features that I think would be useful. I am aware that the Operating System Theme...

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

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

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

I have a Form which has 2 Tabs which contain separate aspects of information that are related to the same PartID. What I am trying to do is to come up with a method so that if there is a Description entered into the Reliability Tab (and the Decription Part ID value on the Reliability Tab has a...

NOTE: I am struggling to find exactly what they are called, so I am happy to rename the title of the thread once identified. I currently have a Table being used as a Subform on a Form so that I can enter a load of Child Field data and am in the process of neatening the Table Subform up to look...

I am trying to create a Table with a field which is in US Dollars. I am building the database on a computer which is set up with GBP Pounds as the default currency in Regional Settings. The database will always be used by computers using GBP Pounds as the default currency (all UK based)...

Via my work network, I have access to an old ACCDE Database that someone (who has since left the company) made a very long time ago that has a list box selector with some VBA Code in the background (I think that is how it is working) that looks perfect for me to use in one of my applications. I...

I have an Attachment Control on a Form and would like to modify the way in which it works so that a user cannot accidentally click "Remove" when they are meaning to click "Add...". Is there a way I can do one or any of the following to introduce a bit more security to keeping the Attachments...