Search results

Post Your Code snippet and we have a look.

I know what you are trying to do.Deleting a Record and wanting to store it in another table.Hope iam right. Ifts its not that then Remove the DELETE Query from the code below. Make sure that the table where you want to store your deleted records is present(i called it tblDeletedRecords) Here is...

If you go to Module1 and comment out DoCmd.ShowToolbar "Visual Basic", acToolbarWhereApprop the caption wont appear again. But after the form loading. It should display the most needed of access toolbars. If you close and you press shift and click on you db. it should be able to open. Dont...

Glad to be of help.

You must have screwed up Your Access. :D If you are the type who doesnt like the Access Menu Bar and ToolBar like me, you Will have to run into this quite often. More so during development. I Developed my self a Menu Bar and Toolbar resetter which resets my Menus and Toolbars in case my Access...

Now another TreeView Issue. I have an Edit/update button that updates my treeview nodes and also gives the Selected Node(to be edited) the update stringName. I need to setfocus to the selecteditem/Node(so that its highlighted with the default highlight blue color). I dont want to set its back...

Congs Pat.

Yap, the problem was the network printer since it was set to be the default and yet it was off.I set another as the default and now iam back on track. :cool:

I have been running in this problem and i didnt know the cause but ive just realized now. A mouse over the print button on the Menu Bar hangs my A2K for some Minutes. Other buttons on the menu bar dont. A network printer is the default on my PC, but this is of as for now,it needs servicing. I...

Thanks Ken. I think that will work. Let me give it a try.

i need some help here. In my Report, i have a group header(Companies) and in the details there the contacts in the companies.Another Company is pushed way down the report according to the number of contacts in the Company sorted to come before it. So if the later Company has equally a good...

You need to create a recordset, loop through it, then count the Records.

For Any Beneficiaries, here is how i made it up.

Thanks Pat for the Information, Because of time,i am not so much into Commercial Development,i develop for my organisation. But i just make sure that my commercial applications goto those with a retail Version Of Access.

Thanks Wayne, i will give it a go.

Now i need some help here. I adapted this code from somewhere on this forum. But iam having a problem with using the 'ALL' criteria. It Opens a Report Dynamically from multiple selections in the two multiselect ListBoxes, but when i select 'All' and select any other item in another listbox For...

If you dont have the Developer Version like me,you can also use any windows installer to package your DB. I for one uses wise Installer and it works great for me.

Thanks Man. i Replaced As Bogus with As Correct.

I need help here. i have a multiselect listbox on my form and i want to hard-code its rowsources depending on certain selection criteria.Iam finding a problem. Actually i dont get any results when i use the query below. Any idea what iam missing out. Me.OrgTypesLB.RowSource = "SELECT DISTINCT...

Fixed. Thanks.