Search results

search for: You can have a button whose code is Private Sub myButton_Click() 'do search code, or, to share with what you already wrote, Call Searchfor end sub I'd set the value of Searchresults to "No results" rather than use a message box. Sorry, don't have answers for your other questions.

Could you post more details of your source table and queries? I can't picture them clearly from your description. You can't have headers and footers as such in a table, but you might be able to get the result you want by using a Union query.

Could you post a sample row with field names and example contents? You might be able to use the Like keyword to help do what you need. Select aField from aTable where aField Like "*Pest*" will return all results where Pest appears anywhere in the field.

The VBA could be quite modest. In the field on frm1 choose properties>events>after update>code builder code is something like Private Sub field1_AfterUpdate() Forms!sub-form2!yourfield=Me!field1.value End Sub

I think you should avoid changing PKs and in any case, PKs must be unique so you can't have two companies sharing one PK. If the company being acquired ceases to exist as an independent entity, you could run update queries which replace all FK instances with the PK of the acquiring (still...

The MS site has a decent guide: http://office.microsoft.com/en-gb/access-help/create-and-use-subreports-HA010209281.aspx Short version based on Access 2007: 1 Use the Report Wizard and create a report based on your first query. 2 Then create a new blank report. 3 In Design View on the blank...

If you are just displaying the account numbers in a single combobox that gets its list from a query then adding the Distinct keyword should do what you want. Select Distinct accountnumber from customertable; It may be easiest to create the query first, name it something like queryforcombobox...

If the queries all have the same number of fields, of the same data types and in the same order then you can do a Union query. Select T1.a, T1.b UNION Select T2.a, T2.b; Alternatively, make a simple report for each query and put all of those in as sub reports in a new report. This will...

If you create a query joining the employeetraining records to courses and have a column with a date function you can get pretty close. employeetraining.empID, emptrg.CourseID, emptrg.CourseDate, course.validperiod, MonthsElapsedSinceTrained: ((Date()-emptrg.CourseDate)/30) the /30 is to...

I think harkirat already has automated but needs to know if process will scale if there are more fields. harkirat, my guess is that importing xml to access will not be a problem even if there are 100 fields. You might find the import process takes proportionately more time. edit to add: have...

If only I'd put it in the terms Mihail used! That's what I meant by 'ragged right edge' but I realise it was not at all obvious to anyone else.

you could apply a custom function to replace "0" with "" (a zero-length string), I'm assuming you still want the field to exist in the row otherwise you would have a ragged right edge.

You can hide individual report elements based on the value in a field - the results would be returned but not visible to the user. something vaguely like if [theField]=0 then txtboxonreport.visible=false

I've looked for a vba interface to the gtalk API but not found anything.

Put the query results in a record set and loop through, doing the pdf process to each one Dim rsItemsAs DAO.Recordset Set rsItems = CurrentDb.OpenRecordset(SELECT test0.ID, test0.item FROM test0 WHERE (((test0.item)=[ItemNumber]))) rsItems.MoveFirst Do While Not rsItems.EOF...

There really isn't a better solution. If you extend the desktop across 2 monitors and run 2 instances of your app, you still can't use them both at once because you only have one mouse pointer and one focus. ie, if till operator 2 clicks in their instance, till operator 1 won't be able to do...

This looks like a security risk - I can download your whole database to my PC. Not done much in this myself, but as I understand it Access's web interface is intended only for your local network and not across the public internet. The access application acts a bit like a server and you use it...

Agree with Mihail. Since you are reporting on an HR issue, you do care about the reasons a person cancelled and you don't want to have just a grand total. Going back to the query grid, did you make it look like the following? This will show you counts separately from TypeOfAction Feild Name...

It does make sense. I was really suggesting dodging the issue of network speed by making local copes of the postcodes workbook and opening them.

You have two things to do: 1. Apply the business rules (the status changes based on dates) 2. Update status every so often I think you can cover this with what pr2-eugin wrote, but make the query more detailed to cover the other options. But can you describe your setup a bit more? I imagine...