Search results for query: *

Bob Thanks for the suggestion. Forms however are set to ALLRecords.

Hi I have a form with a linked subform. The subform is in datasheet view on the form. I have the following three fields: fld1, fld2, fld3. Fld 3 has no tab stop. On the Before Update event of the subform I call two procedures to check the validity of the data entry. If the data entry is ok I...

Thanks Norris68 You are right that when i remove the dbo. form my ADP it works ok for me, but it then doesn't work for my users as they are looking for dbo. As I don't want two different ADP front ends this isn't a solution for me. In the end I solved it by having two windows logins. One that...

What i do is write a Make Table Query based on the table you want to export. Create a field instead of your date field as follows NewDate: Format([YourDate],"dd/mm/yyyy") Then export the newly formed table to anything you like will get rid of the time. Hope helps

When i created tables in sql they appeared in my adp project by name + (dbo). In my VBA code everytime I refered to a table I qualified it with dbo. I then distributed this to other users and everything worked fine. This was the test db. The database was then moved to the production server and...

Thanks for your suggestion. I finally solved it by finding the error message on ms website. It wasn't an issue of permissions but one of having Microsoft Jet Service Pack 5.0 See link below. http://support.microsoft.com/default.aspx?scid=kb;en-us;264254

I have developed a ADP file that i have copied to other users. When i open a view and do filter by selection on a variable everything works ok. When i try it from another users front end, they can open the view but when they click on filter by form the following error message occurs 'One or...

Thanks Steve101 I did what you suggested but no improvement. I am working with a form (based on a view) containing four subforms all based on views. Each view has one or more joins in it. But only one table needs to be updated. I tried everything suggested above but it just didn't make any...

I am having the exact same problem as Steve101 have tried all the above and ResyncCommand and am still getting error message 'The data was added to the database but the data won't be displayed in the form because it does not satisfy the criteria in the underlying recordsource' As with Steve101...