Recent content by Weresmytriple

hi all i was just wondering if this could be done by code or he only way o do it was by the form properties?

yes i have solved it

actually just thought i can have a query do the exact same thign and open another form for it

basically to go through and bring up and text box saying which person and which courses have expired

i honestly have no idea how it works im not tat good at coding but it works. it just wont let me click it the 2nd time

hi all i have created a button that works fine however it will only work one click per form load and i cant seem to figure out why. here is my code any help will be much appreciated Private Sub BntExpired_Click() Dim QryAllCourses As recordset Do Until ExpiryDate > Date Or ExpiryDate...

hi is there an if statement for when you are running two different versions of access. for example if i am running access 2003 then run this code else run this code thanks michael

i dont think its that as i have deleted the entire function and i am still getting the same compile error

hi all when i am using this code Option Compare Database Public Function RunAtStart() ' KillIt DetermineByPass End Function Public Function KillIt() As Integer If SysCmd(SYSCMD_RUNTIME) = 0 Then MsgBox ("This Application cannot be opened directly with Microsoft Access,"...

hi all i am trying to run the code found on http://www.access-programmers.co.uk/forums/showthread.php?t=205223&page=2 the code is Option Compare Database Public Function RunAtStart() ' KillIt DetermineByPass End Function Public Function KillIt() As Integer If...

hi all im currently using the code <customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui"> <ribbon startFromScratch="True"> <!-- Ribbon XML --> </ribbon> <backstage> <button idMso="FileSave" visible="false"/> <button idMso="SaveObjectAs" visible="false"/> <button...

do you know how to remove the quick access toolbar?

hi im trying to remove the ribbon in access 2010 i found this code on the internet <customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui"> <ribbon startFromScratch="false"> <!-- Ribbon XML --> </ribbon> <backstage> <button idMso="FileSave" visible="false"/> <button...

hi i have created a database and just use the feature to split the database. i then set a password on the back end database. however now when i use a macro to open a form in the front end it won't open the form and just says incorrect password. any idea how to fix this issue?

SELECT [Clinical Guidance].Name, [Clinical Guidance].Folder, [Clinical Guidance].Location FROM [Clinical Guidance] WHERE ((([Clinical Guidance].Name) Like "*" & [Please Enter the subject (Or part of it)] & "*"));