Search results for query: *

Any help would be appreciated. I would like to add a check box to my form that relies on the following condition; however, I can't seem to get the syntax right. Iif([tblbib].[ISSN]=[tblprior].[ISSN], TRUE) Many thanks, jessica

Thank you, Thank you, Thank you. I started to ask how would I write the SQL, but I figured it out during the typing process. UPDATE tblbib, tblcoverage SET tblbib.EstimatedVolumes = tblcoverage.EstimatedVolumes WHERE tblbib.ISSN = tblcoverage.ISSN; Thanks again, jessica

I have two tables: tblbib tblcoverage I want to apphend a column (estimatedvolumes) from tblcoverage to tblbib where tblbib.issn = tblcoverage.issn. I created the column in tblbib prior to running the append query. I dropped column estimatedvolumes into the append query - click run (because...

Jeff - Thank you for pointing me in the right direction! -j

Is there a way to create a custom query interface for users where they can select multiple criteria to run a query just by selecting say, radio buttons or the like?

Is there any way to set referential integrity for a relationship between a linked and nonlinked table? Thanks, jessica

Thanks Terry, Below see my SQL statement, combo box names, and the vba code for the combo boxes. SQL Statement: SELECT DISTINCT [qrycombo1].[ISSN], [qrycombo1].[Title], [qrycombo1].[Provider], [qrycombo1].[Frequency], [qrycombo1].[LC], [qrycombo1].[Authoritative], [qrycombo1].[Content] FROM...

Terry, Thanks for the suggestion but I tried that last week and it doesn't work. It's as though the query never changes except on the form. Even though the user is making choices it is not updating the query to reflect the criteria (if that makes any sense at all). -jess

Any help would be much appreciated. I have a form with two combo boxes (campus and provider) and a list box. The user chooses his/her criteria from the combo boxes and after update displays the results in a list box. How can I, if it's even possible, print the results displayed in a list box?

Kathryn - Thank you, Thank you, Thank you!!! Your fix worked and it was so easy. Regards, jess

Hi Jerry, Thank you for your suggestion; however, by deleting 'Me.Requery' from the event my edit on/off command button I created doesn't work properly. For example, my user is browsing the database she comes upon a record that needs to be updated so she clicks the button to turn on the edit...

Is there any way to stop Access from returning to the first record when a command button turning on the edit mode is clicked? For example, if a user is browsing the database via the form and comes upon a record that needs to be updated and clicks on the turn on edit mode button she invariably...

I have duplicate data in a table, but when I run a report I would like to hide the duplicate data. When I click Yes to HideDuplicates in the text field property and run my report - a blank space remains where the duplicate data is hidden. How can I both hide the duplicate records and remove...