Search results

Hi All, Can anyone help me with the brain teaser ive been struggling with i have a table with 8 "ward" yes/no fields I want to query for everything that is in one of the 8 (say ward1) But records may have multiple entrys (ward 1,5,8) all ticked When i use this formula (Frm_wards is a search...

I'm trying to make the following code work. It basically adds up the check boxes if there are ticked so that i can display in a text box "multi fields selceted" am i using the right code? is there an easier way of doing this Private Sub Ward_2_AfterUpdate() Dim Multi_Count As Integer Dim...

Hi guys, im not sure if this is the right board to post this problem on, but what the hay ill give it a go. I have a database for issing work orders to our workers i have a issue date that is calculated by the computer date() function. I also have a combo box with different options for a target...

Hi All, Im trying to make up a vb command to send date from a query based from to a table i have no clue how to even start. The database is to record when a item is inspected so a user would type the date in to a unbound box and then at a click of a button the date along with the id code will...

Hi All I have a database that everyone in the office uses daily I have made a small change to it, so that an order raised in this system can be canceld by a tick box, so i have a small code in the from "on current" If CANCELED_BOX = -1 Then Me.Label331.Caption = "Cancelled On"...

Private Sub LstBox_DblClick(Cancel As Integer) Dim stDocName As String Dim stLinkCriteria As String stDocName = "SelectionForm" stLinkCriteria = "[IDNUM]=" & Me![LstBox] DoCmd.OpenForm stDocName, , , stLinkCriteria End Sub ive got a list box that when you...

Hi All, I have a database that has route lists for drivers, I have a combo box that lets the user select a route and a timescale and with that data it populates the list box,,, The list box displays -- Route -- Period -- Month eg -- 1 -- 6 montly -- jan, jul...

Hi All, I have a database that has route lists for drivers, I have a combo box that lets the user select a route and a timescale and with that data it populates the list box,,, The list box displays Route Period Month Now then, I need the database to be able to double click on the...

Hi All, I have a database that has route lists for drivers, I have a combo box that lets the user select a route and a timescale and with that data it populates the list box,,, The list box displays Route Period Month Now then, I need the database to be able to double click on the...

Hi All, I have a database that has route lists for drivers, I have a combo box that lets the user select a route and a timescale and with that data it populates the list box,,, The list box displays Route Period Month Now then, I need the database to be able to double click on the...

Help please, im using this code Private Sub Target_Combo_AfterUpdate() Select Case Target_Combo Case "Emergency" Me.TARGET_COMPLETION_DATE = Me.ISSUE_DATE Case "3 Days" Me.TARGET_COMPLETION_DATE = DateAdd("d", 3, Me.ISSUE_DATE) Case "3 Weeks"...

Help Please Hi, Im having a little problem with the following code in one of my queries Expr1: IIf(IsNull([Forms]![editLookForm]![Company_Name]),True,[Company Name]=[Forms]![editLookForm]![Company_Name]) What this does is, it take an typed entry from the form (editlookform) and seaches for...

Hi, im new to access go easy please, Ive got a works orders database that requires some tweeks, This database records faults & locations and the target completion time for the job Just now the operator fills in the fault and location and the issue date appears automatically as todays date...

Hi, im new to access go easy please, Ive got a works orders database that requires some tweeks, This database records faults & locations and the target completion time for the job Just now the operator fills in the fault and location and the issue date appears automatically as todays date...

I have an update query that looks for a name eg "first" then it is suppost to update a field with 1 I have a command button that runs the query This then says "you are about to update 1 row(s) so i press yes, but the field doesn't update But if i flick through the database and then come back...

undefined :mad: Hi im new here Ive got a db that im having problems with (Access 97) i got a date field (date1) - which is automatically todays date ive got a combo box (option) as below - it displays the name - :- name days one 1 two 2 three 3 and another...