Search results

stLinkCriteria = "[JobRef]=" & "'" & Me![jobref] & "' & [fkAccountTypeID]=1" the job ref is gathrered from my jobref control but the account type i want to set it to 1 manually.. this compiles but no values are sent across to my second form.. whats wrong?

i have a problem with positioning the totals on my report.. im using a template that automatically draws lines across the page.. at the moment im putting the totals in the report footer section.. here are the problems.. this is what my report looks like in design view...

yes.. thank you.. before i was only interested in the string value displaying on the report so my operator could tell how the driver should meet the passenger.. its all good now.. i have used ur method.. thanks bat!

ok i think i need a bit of help on this one.. i have created a database with one table and one form.. http://www.londonheathrowcars.com/chkform.jpg mg = Meet & Greet os = Meet Ouside these are important so i will be storing their true of false values aswell as adding the string to the place...

hi.. i have a tickbox that when ticked adds ' (M&G)' to the end of my jobfrom field.. here is the code.. Private Sub JobMg_Click() Me.txtjobfrom = Me.txtjobfrom & " (M&G)" End Sub so the job from field will contain This House you tick the box and it displays.. This House (M&G) which is...

yes that did it.. thank you

ok.. this is not a hugely important issue, however.. it is a slight annoyance that i would like to resolve if it is possible.. most of my currencies will be whole numbers like twenty pounds or five pounds.. so i chose to set the decimal point to 0 which displays it like this.. £50 which is...

yeah i figured that out.. i tend to tip toe around the pond rather then belly flop into it..

i fixed it.. thanks

i put this.. Format([JobDate],"dddd") in the control source of my unbound textbox and got this error Syntax error (comma) in query expression and without the comma i get another error.. and using the other method it says extra ) in expression.. ?

i have a field on my report that is called job date.. it is a date time field.. and displays the date as 01/01/2007 i was told that access has the ability to extract the day of that date automatically.. so if i create another textbox.. how do i format that textbox to display the day of the...

i got it working.. cheers man good memory

ok wait one minute.. i didnt have any records displayin thats why the error came up.. one minute

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If [textboxcounter] Mod 8 = 0 Then Me.Detail.ForceNewPage = 2 Else Me.Detail.ForceNewPage = 0 End If End Sub my textbox is in the detail section of the report.. it has.. a name of textboxcounter a control source of =1 Running...

oh dear, i dont have a premium account and i am unable to view the solution.

i have searched a few posts and havent found the solution.. basically i want to get rid of the circled record here.. http://www.londonheathrowcars.com/thispic.jpg so based on the size i have set.. it prints 9 records per page.. i want it to print 8 per page.. how can i do this??

ok.. ill have a look at that soon and report back...

the actual scenario for when the record moves across is flexible.. whether one database is open.. or both.. or whether they are in the same folder.. or on the same network.. it doesnt matter.. all that matters is that the user can press a button.. (whether this is a transfer record.. or...

http://www.londonheathrowcars.com/transfer.jpg fairly straightforward picture.. you have a record in db1.. you view that record in a form.. click the transfer button.. and the record is transferred into db2.. i need something like this quite desperately.. if anyone has done this in the past...

and records are the fishes