Search results

DoCmd.Close acForm, "Form Name" Also, why requery each item individually. Why not just use Me.Requery

Okay... sorry I didn't reply for a few days. My computer needed a new motherboard and Dell was nice enough to send one out, but it didn't get here soon enough. It sounds like you want to count the number of records returned in your recordset, determine the count number of the record you are...

I'm afraid to find out what it might have been. PM me with it if you aren't too embarassed. :) If I remove the non-standard characters it would change the official name of the sites which are my entries, so that's out of the question (but it is a good idea, so thank you for posting it). I've...

you would need to remove the filter in this case. Just use me.filter = false behind a button that removes the filter.

Can you post your code? Do all of the machines have the same version of access on them?

You can certainly do it using a query which would be the easiest method. Just make sure you set your relationships correctly in the query.

Does the query return a result by itself using the criteria? If so, then are you having your form requery after you enter the selection criteria?

can you post the code for the delete function and the counter?

can you post your code for the before update event? The other place to try is the On Exit event.

Where is that line in the code? What event are you using to trigger this code?

You can't add a null value, you can simply add a blank value (i.e.: a space). Why do you need a null value for this box, technically any field which has no information in it is a null field.

In the before update event did you have the code cancel the update if the field value is null? It sounds like you have a required field in your table that is being hit despite your before update event. Where do you have the field listed as required? In the form, the query, or the table, and...

how are you updating the information on your subform? You need to call the subform to requery after the parameter values are updated so that it uses the new values in it's query.

Please post your code as it sounds like an issue with the code itself, which is hard diagnose and fix without seeing the actual syntax. Thanks! :)

I'm having trouble finding an entry anywhere about this, although I'm sure I'm not the first person to come across it... When I am typing my entry into a combobox it begins to autosearch, highlighting the part of the entry that it finds that matches the beginning that I typed in (as a normal...

Pat, Thanks for heads up. :) Keith

Are you speaking about a subform? Because from the look of it in your code you have three forms open, two of which are subforms. If this is the case, search for "subforms" on this forum and research how to reference them in your code.

http://www.access-programmers.co.uk/forums/showthread.php?t=89505&highlight=openrecordset

Are you referencing an ADO or DAO recordset? DAO recordsets allow for findfirst, ADO do not. Check out the FAQ on ADO and DAO conversion for more info on this.

Check out the following information: http://msdn.microsoft.com/library/?....asp?frame=true You should be able to set the options you are asking about from within VBA regardless of the program you are working with, just have to be sure you are using the right option names.