Search results for query: *

I am trying to push tables of data to multiple databases using a master database. All of the child databases have passwords on them which is fine as I know them all. I am able to create the append query, but when I run the query I get an "invalid password" message. Does anyone know how to get...

If I understand what you are trying to do, you can add section breaks and protect the sections that have the drop down lists and leave the other parts unprotected to allow The user to enter text.

Skip - No, I didn't I tried too many things to get it to work, so I left that part out. pwise - That will work for this case, but I will have to use this again on another form but will have nearly 10 options to select from and again the last being to return all values.

I have a query linked to an option group on a form. The query works when I have option 1 or 2 selected, but I want to return all records if 3 is selected, but instead is not returning anything. Does anyone have any ideas? IIf([Forms].[frmQualityReview].[optReviewed]="1","Yes") Or...

I have a combo box that I need the selection options to be sorted. My row source is .xls files from a folder path that I have chosen. I have that working with no problem, but the sort order is messed up. Does anyone have any idea on how to sort this?

I have a search form and when (blank) is selected from one of my fields I am having a hard time getting the query to return all fields that are not null. If nothing is selected, return all records. If a name is selected, match the name. Logic tells me to write it like below, but I know it...

Worked perfect. Thanks a bunch.

I have a query that is linked to a search form that I am having issues with. I am fine with everything until I get to including a date range. I used the criteria of 'IIf(IsNull([Forms].[Search].[BeginDate])=True,[SubmitDate],Between [Forms].[Search].[BeginDate] And [Forms].[Search].[EndDate])'...

I never thought about entering the full path instead of using the folders. It worked, thank you.

Does anyone know how to link a table and have it use the network drive name instead of the drive letter? I have a multiuser database and the users have the network drive for this database assigned too many different drive letters so I need to use the drive name but I don't see an option when...

Hi Skip, Thanks! Any idea how to fix the problem to stop the text from printing over gridlines?

I've been stumped on this one for most of the day and can't figure this one out. I have a coworker who has a spreadsheet that the print preview looks fine but when printed the text in one of the columns goes over the gridline and is overlapping some text in the next column to the right. When...

I have a form where I had a field being reset to the original value if other criteria was not met. After a few updates were made to the database this code is no longer working. I am getting an "Operation is not supported for this type of object." error. If I save the record upon entering...

Hi AceMan, Thanks for giving it this much effort. I've put the code in on the AfterUpdate of the CloseDate field on the subform and I am getting nothing. Any idea what is happening? So there's no way to just refresh the parent either?

I'm almost there now. I've set an AfterUpdate macro to set the value of the max close date that I have calculated in the footer of the subreport. Now the problem is that the macro is running before the fields in the footer are calculated and its bringing the max value of the previous update...

Hi Aceman, doing ok, just puzzled by this. I'm not sure I follow what you are saying. I'll try to clarify what I am doing. I have a closed date that currently needs to be entered on the main form. I then have a subform with a varying amount of records and a field there is also a closed date...

PHV, Thanks for the help. I actually tried that before posting and ran into the problem of I didn't want the maximum if not all the dates were completed in the subform. I got around that by using the T/F test to only return a date to the field if the test was true that all dates were...

I'll be as clear as I can so we don't have to go back and forth so this is probably overkill, but here goes. To start, the subform is viewed in datasheet view on the main form. In the form footer of subform, I count the records in the subform with =Count([Policy]) and count the records with a...

Hi everyone, I'm a little stuck here and hope someone out there can help me out on this one. I have a subform that has dates when an item is closed. Currently the main form has an overall case closed date as well that does not allow a date to be entered until all dates on the subform have been...

Hi Ginger, I guess I should have included that in some cases these reports may only be a few lines so I will want to keep them together as much as possible. I'm beginning to think the best way will be for me to split this up into 2 reports and create the maximum sections with header and footer...