Search results

thank you very much

yes thank you.. it is working..the combo is selecting the fields based on the form criteria at the moment though.. my sql query is selecting 2 fields.. and they are being displayed in 2 separate columns.(as normal) here is the sql, i want the JobFrom and JobTo data to be in the same column...

ok.. ok.. look.. i dont have the address in a memo field anymore.. i have it in a text field.. also the database i am making is short term.. when we have more work then we can handle.. we wont be using this system.. my user (1 person) copies addresses straight from websites.. he does not...

i know me saying.. "still blank" doesnt really help on my behalf.. off the top of your heads.. can you think of any reason why it wouldnt work?

thank you.. i completely understand regarding the normalization comment.. for now though.. it will have to be like this due to time constraints.. thanks for the code..

thats great.. the problem is that if my user enters.. this.. london sheraton hotel, knightsbridge, WC1 6YQ then it becomes London Sheraton Hotel, Knightsbridge, Wc1 6yq i dont want the postcode to be affected.. so how can i edit that rule so that if the letters are already in capitals then...

still blank..

this code Me.txtincflightfrom = UCase(Left(Me.txtincflightfrom, 1)) & LCase(Mid(Me.txtincflightfrom, 2)) turns this tel aviv into this.. Tel aviv.. i have tried to fiddle with it without success.. basically i want all the first letters of each word to be a capital so tel aviv, becomes Tel...

i want my combo list to display addresses (text datatypes) that have been previously used by the person who made the booking.. in my tblJob table, there are records with tblJob.tblJobTo addresses where the tblJob.fkBookerID is 3 ****ON MY FORM the control Me.txtbooker has the value 3...

thanks, that does seem like the logical answer in hindsight

if this makes the first letter a capital.. how can you make every letter a capital.. Me.field = UCase(Left(Me.field, 1)) & LCase(Mid(Me.field, 2))

yes.. i understand.

so are you saying there is not even a need to store the total as a field because at any point in the system.. i can retreive the total by adding whichever fields i wish together?

lets say i have three fields in my table.. all currency fields.. jobprice.. jobcarpark.. jobtotalfare.. is there a way at table level.. to set jobtotalfare as jobprice + jobcarpark because at the moment i am simply ensuring that in all the forms.. if the price or carpark is updated.. so is...

thats the one.. thanks.. i knew it was something like that

hi.. im sure this cant be that difficult.. is it possible to add a where clause to this control source of a textbox.. basically i want to add 'if jobtype=1' to this.. =Sum([JobTdFare])

Yes. that has fixed it.. thanks bob.. i knew if i tried to do as much as I could.. it would make this process much easier.. thanks..

ok. can anyone see what is wrong with the bold line in this code.. does it make sense? Private Sub txtjobdate_GotFocus() Dim dteFormDate As Date If Me.txtjobdate.Text = "" Then dteFormDate = CDate(InputBox("Enter the date:", "Date Entry")) Me.txtjobdate.SetFocus Me.txtjobdate.Text = dteFormDate...

let me describe the issue in words so maybe someone can see the solution from the code.. when my form opens.. a message appears and prompts my user to enter a date.. (txtjobdate is the first control in the tab index..) Private Sub txtjobdate_GotFocus() Dim dteFormDate As Date If...

thank you joe.. that db may prove to be very useful to me in the future.. if i may ask one last favour regarding this form Peter.. (Batman) basically i want to create a form that deals specifically with one day.. my user will allocate drivers to the pre-bookings at the end of the day...