Search results

thanks peter.. if you ever come through heathrow give me a pm and ill arrange a spanking new e-class for ya.

thats great.. i think the remove driver may come in handy also.. the problem is when you try to remove 2 drivers in a row.. it doesnt let you.. did you notice that?

ok..here is what the form will look like.. http://www.londonheathrowcars.com/prvw1.jpg and are you saying that when items are highlighted in each listbox.. and the user presses the button.. like so.. http://www.londonheathrowcars.com/prvw2.jpg then jimmy will be allocated to the Twickenham...

i think it does make sense.. this form will be a daily form.. it will display all the jobs for a single day.. and my user will allocate drivers to all the jobs on a select day that dont already have a driver registered to them... let me make the new form.. and show you my interpretation of...

ok.. yes i have just realised the example i am talking about is not a combo in a listbox.. it looks as if it is.. but really it is loads of combos next to each other.. here is that picture.. http://www.londonheathrowcars.com/dingding.jpg the form i want is a review and edit form.. the...

hi.. basic table layout.. http://www.londonheathrowcars.com/db_tables.jpg have a query that displays jobs with no drivers.. http://www.londonheathrowcars.com/nodriver_qry.jpg i have seen that combos can be placed in listboxes.. i want the following form that will allow my user to set a...

yes.. it is a bit of a poor title..

thats is much better.. and easy.. thanks..

ok.. i have searched many posts on this forum.. what i want to do is not allow my user to scroll through records using the mouse wheel.. whether the mouse wheel is locked or not... i just dont want the form to allow more than one record to be accessed at once.. when the form opens.. i want a...

i fixed it using else if.. here is the code for formalities sake.. Private Sub btncontinue_Click() If Me.cbojobtype.Value = 1 And Me.cbopaidby.Value = 1 Then DoCmd.RunCommand acCmdSaveRecord DoCmd.Close ElseIf Me.cbojobtype.Value = 2 And Me.cbopaidby.Value = 0 Then Dim stLinkCriteria As String...

you know what.. i have just realised i dont need the grid on these reports.. lol.. what a waste of time.. i see what your saying though.. its not really the traditional client-designer relationship.. its pretty much my business aswell and the only reason we are not completely abolishing 'pen...

gettin a few probs with the code.. its sayin error 2467.. the object is closed or doesnt exist.. on the bold line.. is there a better way to group this code.. ill also add that one of the following conditions will ALWAYS be true when the button is pressed... Me.cbojobtype.Value = 2 And...

you legend.. thanks

the reason i have built the grid in the first place is because i need the whole page to have a grid.. even if one record prints.. the rest of the page has to have a grid because my user will be writing details on the page.. wouldnt it be easier to keep the grid i have (even though it is...

you are probably right.. but this is the level i have reached at the moment.. i dont know any other way to do it.

i have some code below.. i have wrote the part in bold that needs to be coded.. its just a small part.. If me.txtfkAccountTypeID.Value = 1 Then DoCmd.RunCommand acCmdSaveRecord DoCmd.Close End If If me.txtfkAccountTypeID.Value = 2 And me.txtfkPayByID.Value = 0 Then Dim stLinkCriteria As String...

this doesnt even work.. stLinkCriteria = "[fkAccountTypeID]=1"

fkAccountTypeID is a number datatype if we just look at this part.. [fkAccountTypeID]=1 is this the correct way to assign a number value to a number datatype??

ill just add that the below line successfully sends across the job ref.. im just trying to expand this statement now.. stLinkCriteria = "[JobRef]=" & "'" & Me![jobref] & "'"

no same problem.. it compiles but nothing is sent across... the form that opens is just blank with no fields displaying