Recent content by smdemo

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...