Search results

Perfect Wayne Thanks

Attached is a zip I made of it the last time I was trying to fix it. There are some errors that you can ignore as they are caused by leaving stuff out. When you open up the form , hit Add and then the error occurs when you try to type in a part number.

I have had to remove the parent cild link due to a problem with creating a new record (which I have tried multiple times to fix). SO this is the work around. I would prefer if my Parent/Child link was working properly

Yes right click does not pop a menu like it does when you have full Access. So it is possible to simulate it.

No afraid not - "Cannot find the field named mySubFormName"

I am trying to requery a subform in the oncurrent event of another form. I am using the syntax provided by Mile-O-Phile on this site as follows Me.Parent![fsubDrawRev].Requery Forms!frmDrawings!fsubDrawRev.Form!fsubDrawRevsubform.Requery The first requery works fine but the second one says I...

Thanks worked perfectly.

Yes sorry it is Access runtime that is installed with .adp packages. Does this mean that right click etc should work so on these machines.

Thanks guys. My flickering was actually cause by unassociated labels (its an MS bug apparently) I just associated the labels with textboxes and it's fine. I still have some of the flickering caused by the things you mention but it is at an acceptable level.

Does anyone know how to stop a requery causing the app to flicker.??

I am using the following command to delete records. DoCmd.RunCommand acCmdDeleteRecord which is fine if the user presses OK but if the user presses No it just crashes. How do I code this with my own error messages. Below is what I have so far but that deletes whether you press or no as the...

I have been using Access .adp and Packages to deploy the app on a PC without Access installed (thus reducing no of licences required) as far as I was aware that was the purpose of them.

ghudson I am now using this method but how do I deal with it when the user hits No. On a machine where Access is not installed it just crashes. I have tried the following butthis just gives me 2 MsgBoxes the access one and my own. Any ideas ? Dim Msg, Style, Title, Response DoCmd.RunCommand...

It does I was just hoping to avoid putting in a button as it's not suitable on some of my forms. Think I'll have to go with that.

I agree you would have to uninstall and reinstall to update the packaged app.

Unlike everyone else I want to enable right click but ticking the allow Default Shortcuts Menu won't work for me as I am using Access .adp which runs on machines that don't have Access installed (therefore they cannot have shortcut menus). How do I get around this or do I have to find another...

Why not use the Access Pivot Charts - saving you the hassle of exporting. Have you tried me.txtbox = me.cboCombo.colum(1) in the afterupdate event of your combo box

No joy I'm afraid same result.

I have a form (1) that is just a list so it does not need to be updateable so I set recorset type to snapshot. On another tab I have another form (2) and a subform (2a) that shows more details about the record shown on form 1. The master child relationship between Form 1 and 2 is as follows (on...

I have a view based on 4 tables. From this view I need to show only the highest revision of an item. The revision number and details are held in one table while the main data is held in another. This is the code I was using but which doesn't work as I wanted it. I need to only return 1 line per...