Search results

I have the onlick of a button programmed with Dim stDocName As String Dim stCriteria As String stDocName = "Rallies this year" stCriteria = "[Year of Rally] = " & Year(Date) MsgBox (stCriteria) DoCmd.OpenReport stDocName, acViewPreview, "", "", stCriteria the output...

Thanks Roger for the file. I haven't yet worked out how to apply it to my situation. I'm also worried in your example linking all the tables making a circle as in my experiencing that causes a problem. I'm not clear how that design ensures one knows when certificate an employee has when they...

I have a problem of how to structure tables to pay employees the employee recruit people to attend sessions so there are three tables, employees to sessions many to many attendance resolves the many to many, so Employees 1 to M Attendances and Sessions 1 to M Attendances Attendances contains...

thank you lagbolt SendKeys "{TAB}{TAB}{HOME}^{TAB}^{TAB}" doesn't seem a prolgramming and parameter approach but effective as you suggested I'd rather program a DoCmd.FindNext than use the Action Menu approach. I don't understand why VB doesn't cater for this.

Hi I have a form with a combo box that opens another form to the user's selected value and then when the user has finished with the second form and closes the user is then back at the first form - but the value in the combo box is still shown. I know how to program to clear that - as I can add a...

I'm using Access 2010 and I wish to email a report to the client I select from a combo box on a form, so the where clause would be "[ClientID]=" & Forms![FormName]![ClientID] but I have been told that SendObject does not support a where clause is my thinking is I have one query behind the...

How do I go about emailing a report to a Client selected from a combo box on a form thank you ion anticipation

thank you veraloopy somehow must have turned off Use Control Wizards now found it (in 2010)

Thankyou Brian and Mike. My form has seven text boxes on it - and is kind of working. Having performed a search, for males for example then I clear the form and even manually refresh and then search for married a reduced resultant list is produced as I am getting married males. It's a little...

When adding a button to a form the wizard for the command button doesn't start in any database I have including creating a new database. Can anyone suggest a fix please? I am getting better at programming the buttons myself - and certainly eager to do so, but the wizard is helpful to show you...

Thanks for the reply John. The structure involves 4 tables (more in the whole system but enough for this explanation) - involving tracking whether participants attend seminars One job has many seminars One seminars has many attendances One participant has many attendances attendances being the...

I wish to be able to run the one report from either of two combo boxes on a form and the query/report runs with the value from one or the other combo box. Is this possible and if so how?

I have a user who wishes to be able to choose the field to search by and then enter/select a value for the criteria for exaplanation basically a customers table (but will also show information from orders in the output) where the user can choose/specfiy suburb and then choose/enter a value eg...

This one has been solved

I wish to open a form by using a button (from a switchboard if you like) where the records displayed match a criteria eg. Clients.Status = true and I also want to the able to open the same form - using a dikfferent button where all the records are displayed, eg. All client records so I wish...

Re: Opening one form and then another based on values Apologies for the similar posting on the opening form thread I have now tried DoCmd.OpenForm "History", , , "[ClientNumber]= " Me.ClientNumber I am getting an unexpected end of statement error and the ME highlighted (Access 2010) I am...

I am struggling with opening a form Opening a second form based on a value in the first The first form has a text box called ClientNumber and I want to open Form2 based on the value in the textbox on Form1 and Form2 has a text box called ClientNumber I have tried DoCmd.OpenForm "Form2", ...

Unfortunately I have not quite got what you suggested to work, I have tried to olpen a form called History with DoCmd.OpenForm "History", , , "[ClientNumber]= " = Me.ClientNumber but I get an error Method or data member not found and .ClientNumber is highlighted

I wish to run the same query from three different forms - where the criteria is the client # on the currently loaded form from which the query will be run. I can make 3 different queries of course - but is there a way with the same query? Help always appreciated.

Re: Postcodes I have run into trouble when trying to implement the Postcode and Suburbs into another form, eg. Clients, and I am getting an error Update or CancelUpdate without AddNew or Edit when I try and close the form ideas please