Search results

Hi I have this expression in a query on which a report is based and would like to use Between And to select the date period, but cant get it to work, the table has Feb and March dates in it but the query brings out March dates if I select 01/02/07 and 28/02/07 (UK date format) ..it works if I...

Found the answer, thanks Looked a bit harder and found this =Format([Enter Shipping Begining Date:],"mm/dd/yy") & " through " & Format([Enter Shipping End Date:],"mm/dd/yy")

Thanks Sohaila For this =Format([Enter Shipping Begining Date:],"mm/dd/yy") & " through " & Format([Enter Shipping End Date:],"mm/dd/yy") was just what I was looking for cheers fi

Hi Have done this before on a report, but cant remember how , shown in this case the date selected on the underlying query's Between And selection could anyone help me to remember how to do this thanks in advance for any help Fi

RG !! How can I thank you I wouldnt have worked that out in a million years, as you can see i am pretty basic and just keep adding bits and pieces as I learn them from you wonderful people..my boss is going to be so happy there was one wee bit that I changed as sfOnline wasnt becoming visible...

Open Subform Hi RG Thanks for your offer unfortunately my internet connection went down just last night, here it is a bit messy as still very much WIP thanks again Fi

thanks for being so explanatory, hers is what i now have but am still getting Runtime Error 424 Option Explicit Private Sub ShowSubForm() 'Save unsaved changes to currently open subform DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 'Display appropriate subform based...

Hi RG I dont suppose you could do me a massive favour and add this where it should go on the code i posted, and post it back to me as I am getting just a little confused as to be honest i do not understand what Call is doing your time and patience are greatly appreciated Fi

Hi RG Sub ShowSubform() is what I had to start with, am I really not understanding what you are saying, does what I said on my post before this one have any meaning in that it seems to let me get further ?? Fi

Hi Changed the codeslightly and it seems to be getting as far as Private Sub Form Current () where it gives the error message 'Compile Error Sub or Function not defined' 4 * against the line below where the error seems to happen thnaks again RG Option Compare Database Call Sub ShowSubform()...

Hi RG hope I havent made you think i know what Im talking about during the past few conversations !!! I changed the code to what I think I understand from your post but am getting 'Compile error Identifier expected' , can it be that the subform are not being recognised by how I have them set...

Hi just tried it and still get the runtime error 424, I found this is code from another forum it was in a sample DB and worked perfectly so I guess there must be something wrong within my Db to stop it working, I am searching on this runtime error to see if I can find anything that way..thanks...

Hi Rural Guy apologies for not answering correctly, Main Form is POrder the Combo Box is on the main form its RowSource Type is set to List and the Value List is "Online";"Press";"Directories"; I am trying to make the forms visible depending on the selection made in the combo rather than...

on my last post I had Me. infront of the subform names I was trying to see if that made any diff to the runtime error it didnt infact it made it much worse so that has been removed and I am back to just runtime error 424 'Object Not Found' PLEASE IGNORE THIS POST

Opening subfiorm via combo box selection Hi Rural Guy thanks for your reply apologies for not starting a new thread, will do in the future, I thought the original thread seemed to be almost what I wanted which is It is basically an Orders DB, on the main form POrders when a new order number...

Try not to laugh.. In relation to my post about opening a subform specific to a selection made in a combo box on the main form would something like this ever work (assuming the correct code & syntax both of which are beyond me..were used....) as always any response would be more than welcome...

Opening subfiorm via combo box selection Hi Having searched and read through various postings this one seems to be what I'm looking for, being a fairly basic user I cant get my head round where to put the form/table names from my db into this statement to get it to work, could you point me in...

IIF or Switch Thanks for the advice Banana, I will look it up, I just tried something Brian Warnock had suggested earlier Expr1: IIf([Deal]='CPA',[Quantity]*10,IIf([Deal]='CPM',[Quantity]*100,IIf([Deal]='CPA',[Quantity]*1000))) ie 3 brackets at the end, I have put 4 at the end of my IIf and...

This was working really (below..) well until I added a fourth IIf, havin searched the forum the general concensus would be to avoid IIf,s like the plague I have seen posts on Switch as an alternative could anyone point me in the right direction / help me out ..please Expr2: IIf(([CPM])='CPA'...

TimeFormat Thanks for your reply Brian, I am working on a time logging DB which is working ok in that it is recording time as an employee logs in and out, what I am trying to do is Sum the times ie I will run a report at the end of the month which can be selected for a period it will show the...