Search results

Hi Arnel, Thanks for your help. When I use the "Where Condition" above, I get the following: Entering the part number does work, but I believe that it can also be done automatically. Is this possible?

Yes sorry. So currently I double click on the PartNumber textbox on my NSRSubform form, and this opens the Storemanager form using a Macro. I would like to double click on the PartNumber field and this would open the Storemanager form but also filter by the value in the PartNumber field. This...

Hello All. My database has the following table called NSRSubform. It is a table that stores orders. We have been entering the details of the part that we want to order in the Description field but I have just added a PartNumber field, to separate the description from the part number. After...

Thanks for the input Bob. I've changed the name to tblCategories. For the Random Numbers, I've come up with the following makeshift way of doing it: Created a Query based on tblCategories. Added a field to generate a random number using the Primary Key, using the following Expr1...

Certainly... My next thing I want to develop is a random selector to randomly choose a question category.

Thanks Gasman. As I'm not too familiar with how to apply a query to a form, I used the following code: Private Sub cmdPlus1_Click() [Points] = [Points] + 1 DoCmd.SetOrderBy "Points DESC" End Sub Each button from +1 to +5 adds the points and then sorts the order by points descending. It...

Hi Bob, I've created an Access database instead. Please see below: I have a table called tblScoreboard with the fields "team name" and "points". The command buttons are set to + 1 to the field and refresh the form to update the score automatically. I just was hoping to find out how to...

Hi Bob, Maybe that's where I'm going wrong. I am just storing the team names in Cells B6:B15 and the Points in Cells C6:C15. Is it best to create a table to store this?

Hi All. I am hosting a quiz and was hoping to have a live scoreboard to make things a bit more interesting. So far I've added a spin button to add and subtract from the scoreboard. I was hoping to have a scoreboard that automatically updates and sorts the scores from highest to lowest. Is this...

Thanks Pat, I will ask the IT department to perform a reinstall.

Hi All. So I opened the database that I attached via a link above on my laptop at home, and once I had corrected the code it worked completely fine. I have changed the code on my copy in work, and it does not work. When I opened it on my personal laptop, a yellow message bar appeared for me to...

Hi MajP I can certainly do this, but before I do; I have created a new blank database. I have tblNames containing 3 records. I have frmMainMenu with 2 command buttons. The first uses a macro to open frmNames, this works OK. The second uses VBA to attempt to open frmNames, but doesn't work...

Hi Pat. I opened up my stable .mdb that I know is the latest version we are using. I open the VBA editor using ctrl + g. The option to compile under the debug option was greyed out. I then saved the .mdb as a .accdb. Opened the .accdb and compiled the database. This was all done in Office...

So forget the above. I opened a version of the database that worked completely fine. I closed it, and now I've no idea what copy it was that was working OK. So I am back to square one. If anybody has any tips that would be great. Thanks

I see what you mean. As far as I can see, all of my command buttons still have the [event procedure] in the onclick property.

Update: So I had previously imported the .mdb in to a new blank database in Access 2010. However I never put this in to use. I have imported this .accdb in to the new version of 365, and the command buttons are now working OK. The references and trusted location are still the same, so I'm not...

Sorry Maj, yes the Event Procedure was already there.

Please see below: All of the code is there when I click on the 3 dots to go to the VBA screen

There is nothing showing beneath the ribbon unfortunately.

Hi, Please see below what the trusted locations settings are set to: The option to add a new trusted location is greyed out. Thanks