Search results

it seems you just copied all the code direct into your form without internalising it. Any way,Here we go... Try to first remove all the Error Trapping and All the Code that calls the macro. Also replace ID in the WHERE clauses with the Unique Identifier of the table tblAssetMain. Replace...

ohh my my...it seems that you never tried the solution i posted. Try it out GarageFlower. That implies that if it jams, i will need your vb code snippet, but you can also post your SQl statement.

Is your Menu Bar There? If not then Behind that command button, try this. Application.CommandBars("Menu Bar").Enabled = True DoCmd.ShowToolbar "Menu Bar", acToolbarYes Dim i As Integer For i = 1 To Application.CommandBars("Menu Bar").Controls.Count Application.CommandBars("Menu...

Nothing is impossible in Access. Go to the Property options of the form you want to open and put the Popup option to Yes. From Your Button Open your form as normal. You dont even need to move the sizes.

But pikou, even if you unchecked every thing in the startup options. There would be no problem. Press the shift key and Click to open your DB, then try to put a startup form(Display Form/Page). Or post some thing small.

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.