Search results

Not sure if shuld go here in gen or in modules as its an ActiveX addin But the issue i have is i want the volume to be set higher then default i have treid moving it up in design view and then saving and opening and it just defuaulst down. Secondly the option to restart a bit of music when it...

so am/have been making a database for my game cllection and rather then have to check the current price online, could i get it so when on the quick search option when you search for a game it would also display the prices from a site like price charting or similar database is attached for example

have a simple question i think, this is in my current query Between Date() And Date()-6 and it works fine and selects stuff between the dates so for example stuff from 1/11/23, BUT I want it to NOT select these so that the same word ( as its for a hangman game ) is not picked for that week...

Hi all, i have searched here and google for this and found this https://www.access-programmers.co.uk/forums/threads/combo-box-selection-filters-results-in-subform.323733/ but not sure/how i can get it to work for my example attached, as it did filter one the role ( now its not dam thing ) but...

Have a slight issue, seems have multiplie copies of the same DB appearing, see attached. Is this down to a dirty close down of the DB and can i just remove the excess and keep the one with out any numbers

I would like to put some sounds in access nd found this https://bytes.com/topic/access/insights/639316-how-play-sounds-access but not sure if thats the best way could some one look and maybe point in another direction cheers all

have this code at moment CurrentDb.Execute "Update tbl_GoodGuy set [YourHealth] = " & Me.Text133 & " WHERE [GoodGuy] = 'Player'" but i want to flip it so when user presses command it takes the health count and adds an arbitrary number of my choosing to it ( the number will be the same each...

I swear I made a post about this back in 2020 when I started but seems not. probably started it but work got in the way as it does Anyways here is what have been working on (so far anyway) Its a modern take on a point n click adventure using access, which is handy as no need to build a...

Hi all got a question regarding dlookup, pictures ( hosted within the database ) and how to get it so when the user clicks on a button that it will scroll through the table data and display it on the form. got some idea of how it would work but not sure how to write it down in code, back of...

We have just recentley at work moved to windows 10 ( yuck i think ) any way thats not the main issue, the issue seems to be that a pop up form no longer wants to paly ball. it worked fine on access 2010 which it was made in and just wonder if anyone has had any issues with Access 2016 with this

Hi All i have also posted this on a dedicated excel page but havent had much luck with help or sugestions so hope you dont mind me posting it here to, here is the link to orginal post Orignal Post On Excel Help Forum so i have a file which is attached and once someone press's filter(...

Morning you lovely people, have been looking at this StrComp Function and i think i understand it but i cant seem to get it to work, please see my code and explanation below Private Sub cmbSKU_AfterUpdate() Dim LResult As Integer Dim LResult2 As Integer LResult =...

Hi All i have a split database which we have just moved to a new shared location but the split hasnt seem to have worked i use the split database function in access and what is attached is how it is linked but it should be like the one marked correct any ideas on how to get rid of the...

Hi All have been give the task of marinating a database but the column names have spaces and I don't want to change them as It may effect other parts of the DB but I have a dlookup that I would like/need to add but it just comes back with the ol #error here is my code =DLookUp("[Supplier...

I have a simplish database whch i have made to keep track of my game collection ( and yes there are other optiuons but none did what i wanted ) so i have a simple search which in the below attached pictures you can see is my error and reason for this post, as i searched for the game 688 and...

Hi All have a slight issue and have searchd and it seems like it's a known bug, but cant find any fixes so have a table which has a memo field and is set ot rich text, which is fine as it shows all information as it should but then i have an extract data table as we need to run a report...

Simple one which is eitehr a yes or no answer I am currently tyring to make something for someone, but wantedto try and a bit more pizzazz and wanted to shape the barcode so it would resemlbe a mountain like some of these do shaped barcodes but if i try and just plonk an image it just sits...

Hi All 2 questions in one day i am sorry, but in need of a little help this is my code Private Sub cmdQuery3_Click() Dim mypath As String Dim strReportName As String Dim sEmailTo As String DoCmd.OpenReport "Query3", acViewPreview mypath = "G:\GENERAL\STOCK\supplier...

I'm trying to work out the percentage of failures for a days intake, so the days intake will change hence why i would like it taken from a form but I do have the meat of the problem as can see here, just not sure how to plug in the form bit, which in the example below is the number 37. I guess...

im guessing this will be a big fat no, as i have searched online and most seem to be paid solutions, but here i am asking anyway have an oldish DB in use at work, needs some of the vba chnaging but the guy who made it has. A, Long Gone dont work here no more and B, he password protetced it...