Search results

Hello, I have a database that located on a network. I have several child replicas that only certain persons can access. The main database, everyone has all rights to. The child only the person allowed to have access has rights to. We keep getting the message that the database is already...

The command button code is as follows. Also, when I replace the criteria in the query from the reference to the forms text box to an actual date range, the module runs alright. Private Sub cmdSurveyTally_Click() Call UpdateTally 'DoCmd.RunMacro "Macro1" DoCmd.OpenReport "Survey Topic...

Excuse the formatiing. I am blind and haven't found an easy way of formatting the code. Function UpdateTally() Dim db As Database Set db = CurrentDb Dim RecSet As Recordset Set RecSet = db.OpenRecordset("Data", dbOpenDynaset) Dim RecSet2 As Recordset Set RecSet2 = db.OpenRecordset("Topic...

Greetings, In my database I have a form that inputs a start date and end date. A query uses these dates to give wanted records. I have a module that updates a table. A command button is on the Dates form and runs the VBA code then opens a report. When the command button is pressed, I get an...

Hi Everyone, I have a combo box and a list box on a form. I want to choose an option from the combo box and a number of options from the list box, then, open a form based on the criteria. I can get them to work sepately, but not together. Here is my code. When I click the Find command...

Hi, I have a query that recieves criteria from a form. I want to use the same query, but use criteria from a seperate form. Is there a way to have the criteria of a query ignore the reference to the form if the form is inactive? I've tried the following, but still get prompted for a value...