Search results

yea I know guys, I was put on an access course through work which basicly showed this is a table, form, query and report.

Can the combo box be set on form load show this month?

;) cheeky, and I appreciate your time and help guys. Private Sub Form_Load() DoCmd.Maximize monthtext = Now() End Sub Is that correct on the form load to get the date for the textbox

I know mate but two bloody days on this. I know im a pain and im sorry, This is to find the first and last days of the month.......... "[Date]>=#" & DateSerial(Year(Me.monthtext), Month(Me.monthtext), -1) & "# AND " & _ "[Date]<=#" & DateSerial(Year(Me.monthtext), Month(Me.monthtext) + 1, 0)...

guys I am going around in circles here

I dont know mate, I am new to this. I just want it to select everything for that month and only that month.

Heres the database, The textbox is on the mainmenu form and the query I want to filter is Data Query

I can get it to work with the Between #01/01/2010# And #03/31/2010# type critiera but i have used different variations of forms!mainmenu!monthtext as search google and forums. Sorry for being vauge, im not sure what ones I have used and I really dont know what I am doing

I have been through google trying ones I have come across. I also have used a table as the control source with the default value as Now() formatted mmmm yy and and went to use that to filter the results but then I lose the command button. I have got other forms to filter using the textbox but I...

Can anyone help me please?

I only have one text box that displays the current month when the form is loaded. I have two buttons then will then change this month. That works and I have managed to get it to filter the data when I wanna view it by the month. I just need the query to filter data by what month and year is in...

Hi guys, I am trying to run a query that will only display data which dates are within the month and year selected by a text box on the main screen. I am having so many issues with this. I have tried google but no joy so far. The textbox is on a form called MainMenu and the textbox is called...

cheers guys works great

Oh and thanks for that last night, works like a dream now

Private Sub Product_Code_AfterUpdate() Me.ActiveControl = UCase(Me.ActiveControl) End Sub

Hi guys, me once more with a silly question. I used a Ucase code to turn the text in my textbox to CAPs using the After Update Event. This was working fine but now it send me to debug the code. Is there a simple way or do you guys know the best code to use for this to work? Many Thanks

got it to work I used DoCmd.OpenForm "P1list", acNormal, , "[DateOfWork]>=#" & DateSerial(Year(Me.monthtext), Month(Me.monthtext), -1) & "# AND " & _ "[DateOfWork]<=#" & DateSerial(Year(Me.monthtext), Month(Me.monthtext) + 1, 0) & "#"

this is not working how it should be, it still doesnt filter alright

mate i have to go in a bit. the wifes birthday and i have to get up with the kids in the morning. Can you help?

on the P1 table it is full date, i need this info. it is in p1 table