Search results

thanks everyone for your help

Brian you are my hero, "(Between [Forms]![AMKReportFramework]![AMKDate1] And [Forms]![AMKReportFramework]![AMKDate2]) Or Is Null " worked a treat. perfect. Thanks so much

Hi Brian Sorry for the lack of info. The user enters to and from dates in a text box which corresponds to another field called passed to credit. This brings back all records between these 2 dates. Now some of these dates are left blank. I need these records to still show on the report...

Hi All I have a report which users run again passtocredit dates. How ever some dates are blank which are not showing on the report. Does anyone know what I need to enter in the query to show all values whether they are blank or not Thanks R

Thank you every one for you help, I have found a resolution below is the coding I put on a command button: Private Sub Command31_Click() DoCmd.SetWarnings False If MsgBox("Would you like to see summary version", vbYesNo, "title") = vbYes Then DoCmd.OpenReport...

I found the answer if anyone every needs it Private Sub Command31_Click() DoCmd.SetWarnings False If MsgBox("Would you like to see summary version", vbYesNo, "title") = vbYes Then DoCmd.OpenReport "claimsbypartno/warrantycode-product summary", acViewPreview Else DoCmd.OpenReport...

Hi All Im trying to have a command button so that when you click on it you will get a message and then the option to answer yes or no buttons. If they select yes one report will open and if they select no another report will open. does anyone know how I would start this coding? THanks R

Thank you I tried with the check box as I think thats the way I want to do it, nothing happens when I click on the command button to open the report now. I created a check box on the form where you click the command button to open the report called check145. I went to the report in question...

Thank you, can you explain in a bit more detail please. Thanks R

Hi All I would like to set a command button so that when a user clicks on it, they get an option to show the summary version of the report or a detailed one. Can anyone advise on how to do this please? Using Access 2007 Thanks R

Thanks big booty :) that worked great. R

Hi All I would like it so when users hover over a command button a message appears. The command prompts open up reports, but they have to put certain criteria in text boxes for this run. There are that many different reports with different criteria its hard for users to remember everything...

Hi I have a macro set so when a user click inside a field a form pops which is a calendar, but Im struggling to find how to connect what the user has entered to show in the field. any help greatly appreciated Thanks R Office access 2003

Thanks for this, but the date may be any dates between 2004 till present. This coding would only allow me to enter the current year's date.

I know, you would think so wouldnt you but it seems that users dont know how to enter date properly!!!! so I thought to make it easier for them they can enter dates from the calendar. They are inputting 2020 instead of 2010 or 120 instead of....I dont know really, think they are not checking...

Locking the text box prevents users from entering dates manually, but you can select from the calender either.

how do i lock the text box please? Will they still be able to enter the date via the calender though?

I have tried this and makes not difference as the text box is disable and nothing can be selected.

Hi All I have a form which requires users to enter dates in several fields. I have got it so they select a date from the calender, but i would like it so they cant enter the date manually and they have to enter the date via the calender. Can anyone advise me how to do this please? Access...

Sorry Ive been away, thanks for your help