Search results

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)] & "*"));

i only what the user to enter the criteria once and not have to enter it twice into the 2 different promtp boxes

hi im using the quesy criteria "Like "*" & [Please Enter the subject (Or part of it)] & "*"" I was just wondering if there is any way to set this up so that the one prompt box searches 2 different feilds

hi i am using a query with parameters set. when the user enters a search and clicks ok they get routed to the correct form. however if they click cancel on the parameters pop up box the form wont open and it leave them without a form to reopen anything within the database. any idea how when...

thanks that worked great

hi all im currently using Private Sub Form_Open(Cancel As Integer) Const cstrUserName As String = "Admin" Const cstrPassWord As String = "open" Dim strUserName As String If strUserName = InputBox("Username:") Then If strUserName = cstrUserName Then Dim...