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?

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

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

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?

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

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

hi i have a button opening forms however when they open they appear in window mode and not full screen. is there an option or a line of code of code i am over looking to make it open in full screen mode? thanks michael ps. i am using access 2010

hi all, i am currently using Private Sub Form_Open(Cancel As Integer) Const cstrPassWord As String = "open" Dim strPassWord As String strPassWord = InputBox("Password:") If Not strPassWord = cstrPassWord Then Cancel = True End If End Sub to password protect a...

hi all, i was just wondering if it was possible to password protect a report. so for example when a user clicks on the button from a switchboard a password prompt would open up and if a user entered an incorrect password the report wouldnt open up. if it is possible how would i go about doing...

hi all, i have created a query with the parameter for the Domain field. however on the form the user enters this information via a drop down menu. i was just wondering could the parameter box be set to a drop down box as well to save the user entering in the full Domain field name? thanks for...

hi i have created a form with 3 subforms on. i was just wondering is it possible to display/ hide these subforms based on a Yes/No field in the form. as the subforms would only be valid if the field is ticked as yes. thanks for any help michael

is it possible to have 3 subforms in a form? if so how would i go about this i have created the form and the 3 subforms however it only allows me to link one into the form. im using access 2003 thanks for any help Michael

hi i have created a form and its working correctly. however i have just been informed some of the fields needed deleting and different ones put in their place. so im just wondering if there is anyway to updated the field list so i can just add the new fields without having to recreate the whole...

hi, i have set up a query to count the different ethnicitys of people who have submitted a complaint. it works fine when I leave it just doing that. However when i add a field to allow me to add the parameters for a search between to dates. the query will only count the ethnicity of people...

hi im currently trying to count the amount of records that fall in each month in the date complete field. i am currently using a count query and it it bringing up the dates not the month thanks for any help michael