Search results

The only thing I can think of is that it is not seeing your field as a date. Try the following: Dim xx As String Dim st As String Dim DF as date if isdate(forms![FWDTIMSA]![Text30]) then DF = cdate(Forms![FWDTIMSA]![Text30]) Else msgbox "The value you entered is not a date value", vbokonly...

What are you typing in the text box on the form that is and is not working?

You can execute an update query in your code after the user has selected a date. Private Sub Command20_Click() On Error GoTo Err_Command20_Click Dim xx As String Dim st As String Dim DF as date '__________Run Import____________ xx= "Import Excel Table" DoCmd.RunMacro xx...

In the Form Before Update property you will need some code to check the dates- It will look something like this: Private Sub Form_BeforeUpdate(Cancel As Integer) If Me.ConfirmedServiceDate < Me.OrderDate Then MsgBox "The Confirmed Service Date must be later than the Order Date", vbOKOnly...

Try the following: Like & IIf(IsNull([Forms]![frm_search]![KVA]),"*",[Forms]![frm_search]![KVA]) The only other problem you may be having is that if the datatype is numeric than this may not work. If it is numeric data you may want to create a fake value that you know will return all of the...

Gary - I can assist you with the if statement if you can give me a bit of information: On your sample report you have it grouped what earnings codes represent each group? Planned PTO 921 Planned PTO Planned PTO Sick 921 Planned PTO Sick Unplanned PTO 961 Unplanned PTO Unplanned PTO...

Gary - I am not sure if or how you want to group the other values. If the only ones that get grouped up are 961s and 961u, then the whole iif statement will look as follows: iif([EARNINGS CODE] In ("961s","961u"),"921", [EARNINGS CODE]) if you have more Earnings code groupings than you will...

There is not a really simple way to do that from where you are. I will look at it some more. It may take a few days so if someone else has a great simple way to do this- Speak Up Now! I will take a peek and see what I can come up with. GumbyD

You can create a general function to call on double click: Public Function ShowName() MsgBox Me.Name, vbOKOnly End Function In the On Dbl Click property put ShowName() GumbyD

Gary - I think your best bet is to create an iif statement in your query and then group by the results of the iif statement. The iif statement will look something like: Iif([YourCodeFieldName] in ("961s","961u"),"921",iif([YourCodeFieldName] ... I hope you get the idea. Then you can group...

Check out this site it may give you what you want: http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B153756 GumbyD

Adam - I see what you are trying to do, but I am not sure if the extra records are really necessary. If you create a query the groups by nest and then get the max on the year, won't that give you the last year the nest was used? Then you can just criteria for <2000 for this year or <2001 for...

Are you using the Class Value field in any expressions on the report itself? Do you have the parameter defined in the query with a specific datatype? GumbyD

I had a client with that same issue. They would Compact and repair the database and for some reason the file would lose the Inherited permissions that it was given from the folder it was located inside of. Not sure it that is exactly what you are seeing. My memory was that when they assigned...

I agree with Chenn - a percentage of the what is paid for your work. If you had a contract and you hopefully had a decent relationship with the people you were sending the work to I would think there would not be too much trouble in getting paid for the lead after the fact. I guess the other...

In the code you have in your last post you are missing a closing ")". Your post: [fldreference] & " " & [fld_free_text] & " " & [fld_txt_book_lesson] & Iif(IsNull([fldpages]," "," pp. " & [fldpages])) How it should look: [fldreference] & " " & [fld_free_text] & " " & [fld_txt_book_lesson]...

I took a look at your database and report and updated to what I think you want. Please take a look at the new report that I added. I made quite a few changes so you will have to look it over. Post back if you have any questions. GumbyD

Gary - In a new report create add two subreports to the Detail section of the report. Set up the record sources as the first report and the second report you have already created. There is no relationship (I assume) between the reports so you will not need to set up child / parent relations...

If you create a new report and then add both of the reports as subreports with no link to the main report it should display both reports. GumbyD

Your very welcome! Have great holidays down under! GumbyD