Search results for query: *

Hi In the Design windows I usually right click go to properties and click the hidden button. Is there a way to do this via code for ALL database objects Regards Phil

HI I have 12 screens with have a button which takes them all back to the main switchboard where there is an exit button. On each screen in the top right is the X close button, how can I if the user presses this button exit the database. At the moment when you press is it closes the screen but...

Hi I have a query that is used in different screens What I want is to change the criteria using the following code Private Sub cboUser_AfterUpdate() Dim qdf As DAO.QueryDef Dim rst As DAO.Recordset Set qdf = CurrentDb.QueryDefs("MainDetailsQuery") Set dbs_Current = CurrentDb G_Surname =...

Hi I have an input box for the date and the user then enters the number of days off Is there a function I can use to add the number of days onto the selected date and exclude weekend and bank holidays Thanks Phil

Hi I have a global variable G_LOCATION that is either set to "Like BES" or "NOT Like BES" I then have a wrapper function Public Function LOCATION() As String LOCATION = G_Location End Function This is called from with in a query e.g. Field: Location Table: dbo_Master1...

Hi Im using a wrapper function in a query to hopefully choose between two different events. I set a global variable using Private Sub cboUser_AfterUpdate() G_Surname = Me.cboUser.Column(0) G_Forename = Me.cboUser.Column(1) G_AStaffNo = Me.cboUser.Column(2) G_Password = Me.cboUser.Column(3)...

Hi I am trying to set values to words for example the word day would have a value of 5 and the word Night would have a value of 12 and so on. Then I would need to add the words to get the total value. Example: Column1 Column2 Total Day Night 17

Hi I have a table of data that contains exact duplicates. What I want to do is create a query that includes EVERYTHING but but one occurance of the duplicate. Hp you can help Thanks Phil

Hi I have a combo box that is built from the following sql Private Sub grpUser_AfterUpdate() On Error Resume Next Dim strUser As String Select Case grpUser.Value Case 1 strUser = "DIRC" Case 2 strUser = "BMAN" Case 3...

Hi I have a Main form and a Subform linked together via the staffno On the main form there is a combobox that the user selects an employee name from. This then populates the Main form with details like Name Address etc. The subform is then populated with his sickness records. What I would...

Hi I have a form that works perfectly...... Until I try and add a new text box as soon as I do I get the following when I use the combox. Run-time '2467' The expression you entered refers to an object that is closed or doesn't exist. BUT IT DOES because 5 seconds earlier before I added...

Hi I currently have 6 tables that reside in SQLServer. I connect to them through an ODBC connection created on the machine then I have Linked to the table in Access. Is there away that I can create the links in VBA, so that I don't have to create the ODBC connection on the users machines...

Hi I have a combo box chat has two columns Firstname and surname How can I assign the Firstname to one global variable and the Surname to another global variable I can do it on the Firstname as this is the first column G_Forname = Me.cboUser.Value How can I select the second column...

Hi Maybe I need to explain fully. I have a SQLServer Database that I link to through linked tables in Access. this works fine. I can see my tables an update them directly via datasheet if needed. I have a form that contains the Main form and a Subform. The main form is based on a simple...

Hi I have an Access database that connects to SQLServer via an ODBC link I can see the table fine. I have a main form and a subform. What I want to do is update the subform with the inputs from the user on the main form. but I get an error Private Sub AddRecord_Click() Dim rs As...

Hi I have a Main form and a subform The user select an employee from the list this then populates the main form with Name, Address etc. And the subform contains anysickness. On the main form there are input boxes for the user to enter NEW sickness details of an employee. There is an ADD NEW...

Hi How do I reference the recordset of a subform from the main form. ? Thanks

Hi People I have a form and a subform. The main form displays the details about the employee e.g. Name address etc. The subform contains any sickness the employee has. They are based on two seperate querys And they are linked by the STAFFNo 1. Is this the best method I have input boxes...

Hi I have a series of name e.g. BRANCHADMIN none 101315 - P Mayor 101296 - J Smith 101173 - G Tisdell 101082 - S Penny 100895 - L Butler 100827 - P Flemen 100725 - J Ferris 100674 - J Tailford 100671 - N Carrington 100665 - N Hammond 100456 - C Hillhouse 100452 - L Sunter 100440 - J Mokienko...

Hi I have an input box that the users enters the number of minutes and seconds to include in a query. I need to convert this date format 04:30c (4 minutes 30 seconds) into the seconds equivalent. Is there a function that will do this ? Thanks Phil