Search results

I've tried a couple of times to do that, how would I add it? Just with another & Contract = etc etc, or with a comma?

Code currently looks like this Private Sub Command19_Click() On Error GoTo Err_Command19_Click Dim stDocName As String Dim stContract As String Dim StartDate As Date Dim EndDate As Date Dim ResourceID As String Dim stLinkCriteria As String StartDate =...

I've just had a look at it, and whilst the dates work, when I go to change the combo box value for the Contract name. I still get the results for all the contracts. I didn't notice it at first. I had a feeling the code for Contract was wrong... any ideas?

Works like a charm. I can't believe I didn't try it earlier!

Hi all, I'm currently trying to fix a database that hasn't been working properly and have come unstuck trying to run a report between 2 dates. Basically, each report shows a date (DayDate) and belongs to a certain Contract (Contract). I have developed a form with a combo box (cboContract)...

Hi all, I'm relatively new to Access and need a little help with a combobox and subform. My form is called Contact Register. The form contains a combobox that has two columns showing the Company Name and Division and a subform that I want to show the Contact details of each person relating to...

That makes sense. Not sure the Wizard in 2007 has that option. I'll keep trying

The problem I find with the subform is that it's great as long as you can quickly find the Company you're looking for. I've gotten rid of the duplicates, but if you're say at company 800 and it tells you that it already exists, how do you go back through all the other records quickly to find...

I was hoping to avoid a subform and use the query to make the form. It's just the double up I'm getting that's driving me crazy.

I'm a beginner at Access and I can't seem to find the correct answer on any other forum online. I have a number of tables, forms and queries set up, it's just the very basic that is stuffing me up. To break it down, I have two tables 1. CompanyRegister - contains 2 fields CompanyID (Auto No...