Search results

Works like a charm! Thanks!

Hi, I want to query one of my table based on a textbox in a form: if the user enters nothing in it, I want to return all records; if he enters something, I want to filter the records using his value. The filter is applied on a numeric column. How can I do that in a query? I'm presently using a...

Here's the answer to my question: You cannot use filters in Access 2003 if the form has the "Pop Up" property set to true. But that will work in Access 2007.. Good to know!

I have an mdb file that will be used in both Access 2003 and 2007 versions. The "Filter For" context menu works well in Access 2007, but is grayed out in Access 2003. I'm using the exact same mdb file. See snapshots if that's unclear! Thanks for your help.

By the way, the Access databases are never connected on an intranet or internet. Their new content is manually exported and imported on a USB drive.

Hi, I'm using several disconnected laptop computers with an Access application. At night, they export their new content on a server, which has the same application. I was wondering if I can really rely on the Autonumber primary keys...for example, if user "Alex" with ID "47" fills a document...

Thank you both for your help...after playing with vba a little, I found a way to automatically create a record if the user goes directly in the subform...here's the code: Private Sub SubForm_Enter() If IsNull(Form_PK) Then ' Set focus back to the parent form to create the record...

I like your suggestion...but instead of bringing the cursor back on a field on the main form, I would like to create the record associated with the parent form once the on_enter event is triggered. I've tried this without success: Private Sub MySubFormContainer_Enter() If IsNull(FormPK)...

Hi, I have a form that contains many tabs, one of which is a subform, which itself contains 3 more subforms. As you may expect, an error occurs if the user creates a new record and goes directly in the subform (or one of the 3 sub-sub-form) to enter data, since the parent record is not created...

The "Me.Requery and Me.Recordset.FindFirst" is a nice workaround to my problem. I was hoping Ms Access would provide something cleaner to that particular situation, but if it works, why change it?! ;) Thanks for your help

Hi, I have a form that users fill on a tablet PC, and the content is transferred overnight on a server if they have checked the "completed" checkbox on the form. I don't want them to be able to modify the content once they have checked the checkbox (but it's ok if they uncheck it and then...

Exactly what I was looking for! Thanks!

Hi, I'm developing an Access project that users will use daily to fill reports that they used to fill by hands. Basically, there are 10 different reports that contain 90% of the same information (date, name, temperature, etc), plus 10% specific to the kind of activity. Since the application...