Search results

Hi All, i am sorry about the typo, but it was not the problem,, i kind of figured it out about 5 min ago :cool: ,, all what I had to do is add “dbo.” Before the qry name, so something like the following: DoCmd.OpenView "dbo.qrySummary", acViewNormal, acEdit Anyway, I want to thank you all...

Thanks anyway for trying ,, :)

yape, this is an ADP database,, sorry forgot to mention this

Microsoft office access can't find the object 'qrySummary' Hi all, I have an Access application that has SQL Server as front-end database. i created a view called"qrySummery" in SQL, in access i wanted to show the results from this qry by clicking a button in a form, so in the vb i had the...

thanks pbaldy,,, it did work :)

Open Report Using Two Combo Box , VBA Problem,,, Pleas Help Hi All, I have to generate a report "List of Names" using 2 combo box 1 would be "province" and 2 would be "City",, ie provide a list of name for those who live in Halifax, Nova Scotia. I have created this code below and it seems...

I figured out the problem,, it is all because of the table which is linked to the filed does not have a primary key and atuo number generater. I do not why is that :confused: ,, but anyway it is working fine now ,, thank you jzwp22 for your contribution :)

There is some code running behind the main form, but it only to fine a record “Search engine”. Non of the code behind related to any sub-form. and yes jzwp22, each sub-form is tied to a table that forms the many side of a relationship to a corresponding record in the main form's recordset.

Fields Disappearing + Can't Update on a Sub-Form Hi all, I have a problem with 2 sub-forms out of 3 on my main form. All of the sub-forms are linked to a unique ID on my main form to show specific info. The problem is when I am trying to create new data entry; the fields on two of the...

For Me,, customized main menu, because it isn't supported by a table

Hi All, What would you like to have in your database application, a switchboard form which will have the forms and report you want to display, or would you customize a tab in the toolbar which will replace the Switchboard ? And why ? Thanks

I also tried what you just told me to do, and tested it to generate a report,,, it is taking forever to generate one report !!

Hi boblarson, One reason would be that the number of users using the current database has increased dramatically.

Hi all, Could some one please tell me the steps on how to convert an Microsoft access 2003 database from .mdb to .adp database. i have been googling this thing for hours now and could not find anything, is it impossible to do :confused: Thanks and looking froward to your responds