Search results

Figured out what I was doing wrong, here is the statement that gets the results I'm looking for >=(IIf(Now()-365>[ReceiveDate],Now()-365,[ReceiveDate]))

I may not understand what you're suggesting. It sounds like what you suggest would give me all dates between a year ago and the ReceiveDate. Am I wrong about that? What I'm trying to do is have the criteria be either all Release_Date(s) greater than NOW()-365 or all Release_Date(s) greater than...

I am trying to pull data based on the greater of 2 dates. One being today minus a year, the other being the date entered in the [ReceiveDate] field. This is what I have in the criteria section for the other date field [Release_Date]. IIf((Now()-365)>[ReceiveDate],>Now()-365,>=[ReceiveDate])...

Re: hymnal form combo box duplicate values Try building a query against the hymnal songinfo table that only includes the song. Then use the Totals/Group By to only return 1 row for each song in the query. Set your row source type on the combo box to Table/Query and choose the query you built as...

Hello, I have a combo box that displays all the files in a specific directory. Below is the On Load event for the form that makes the combo box work (found this by a search, thanks to whoever that was). After they choose the file they want to work with, I have a button to do the import of the...

Hello, I have searched the forum using various search criteria and can't find anything dealing with this. I also googled it and couldn't find an answer. I want to send query output in an excel format but I want the file to be password protected. It would be the same password each time the file...

Hello. I have a macro that runs a select query to pull back all group data from an outside database. The next step is a find unmatched query using the data pulled back from the select query against a table I want the data appended to. Next step, append the data retrieved with the find unmatched...

Thank you for responding. I went to the command button that kicks off the process, it doesn't have an On Error property. Right now what happens is if the table created from the MkTbl Query is blank, it just pulls up the doc with no data in the mergefield.

Sorry to keep going back to the crosstab, but I use a cross tab query and use the Group By to produce other values. For example, I pick the field to use for Row, Column, Value on the wizard, but then modify the query. I drop the additional fields into the query, choose Row Heading as the...

I have a database that is being used to house data for Mergefields in a Word doc, among other things. The document is in Word because it is about 16 pages long, but only needs the data for about 12 fields. However, the doc has 2 versions, one for the state of TX and one for everyone else. What...

That worked beautifully. Thank you!

I have a form opened from another form, filtered by a query with the criteria of a value in a field on the first form. If there is no data brought back by the query, the form opens with just the header label, no other fields. How can I have a message display that no data was returned instead...

Nevermind. I just started over, and I think the problem was that I was using an Option group for them to enter information by checking the correct option. I redid the form using combo boxes, and it works fine now.

It did not work. I hadn't tried basing the form on a query and having the query fields Group Number and Group Name refer back to the PlanAdminStatus form to get the criteria for what to display. I set that up and tried it, but it didn't work either.

I've got the fields pulling the Group Number and Group Name data from the first form, and the new data being entered on the new form is saving to the table, but if you exit out of the new form, and go back into it for the same group that data was just entered on, it doesn't display the data...

There is a main form with the fields Group Number and Group Name. It has other fields with information about the group. The button takes the user to another form which is built on a different table, with the link being Group Number between the two tables. It has check box fields for the user to...

Hello. I have a form, FrmPlanAdminStatus, that has a button to open another form, FrmPlanDoc. I searched the forum and found how to have 2 fields on FrmPlanDoc prefill based on the record displayed on FrmPlanAdminStatus. I am setting the default value on the FrmPlanDoc to the field on...

Great! Thank you!

Thanks for your reply. However, with the SignDate as 9/5/2006, Between (dateadd ( "y", -1, [SignDate])) AND [SignDate] is bringing back everything greater than 9/5/2006 in the results.

I have been looking through the search results using various phrases to try to find what I need. I probably have found it but just don't know how to apply it. I have a Date_Created field to pull back payment information. There is another field, SignDate, on another table. I need to pull back any...