Search results

I have a form I created a tab on. Is it possible to have a report or sub-report open inside on the tabs when it is clicked?

maybe in the form have Monday Tuesday Wednesday Thursday Friday Saturday Sunday Then code between start date if calendar= monday then monday=monday .. eh?

I have set up a database that schedules a job for a specific day at a specific time period. Job ID: (auto) Job: job1 Startday: 6/14 StartTime: 9pm Endday: 6/15 Endtime: 9am Is there a way to schedule this weekly or every other day or bi weekly. Looking for a periodic event scheduler. Code or...

ah I see... I didn't know about the ( + ) feature of the datediff. And I was putting a time in my date box. Thanks for the help it all works perfectly now

Well it says data type date/time but there is no option for just time. do i have to just set it that way in a VBA code when im doing the dateiff code? Or is there a way to choose only time or only date

Hi, I am trying to calculate the Hours between two dates... I have one box that input date started sch_Date, one that inputs time start sch_Time, one that inputs end date sch_End date and one that inputs end time sch_EndTime. I know i would have to use the Dateif function but is that only for...

Thank you, That worked just perfect. I only had to put Int( ) around sch_filterNumber during the debug. Thanks for all the help.

ok, so what if I wanted to add a third text box (which I do) that filters store number along with the other two filters. I believe i read that access already assumes = me.sch_filterNumber is an integer. So would i have to dim iFilter as integer or can i somehow add [sch_filterNumber]= " into...

Thank you that worked! For personal knowledge, what was the main difference from the code i was writing to the one that actually worked.. for me it wouldnt filter both criteria at the same time. for yours it worked like a charm. I imagine other people have the same problem as i had..is this a...

Yea i figured it was something tricky with the dates. But it also wasnt working when I needed to do just a text and plain number filter. Each one on its own works fine, but when I put the code into one line for a double or triple filter simultaneously it doesn't work. The code you wrote still...

Hi, I've created a split form and am trying to make a search field which incorporates 2 separate text boxes. Now, I've made a button for on click event for a single unbound text box and used the code : Me.Filter = "[sch_StoreName] = '" & Me.sch_filterText & "'" Me.FilterOn = True Me.Requery...