Search results

Hmm I tried this and I'll still getting a problem, when you click a command button it should eventually close the form, first it should update the value of a bound combo box, but fails on this line of code that should do this. Me.exhibitStatus = 6 'you cant assigne a value to this object'...

Hi Is there a way to save any data changed to a bound subform without refreshing the master form? If you tick a few boxes on the subform then try close the main form there seems a problem with the data not being saved. Me.mysubform.Refresh doesnt seem to be an option Me.mysubform.Requery...

well dont ask me why but if I put 'on error resume next' before the datasheetview command.. it works fine! not only do I not get a debug, the form changes to datasheet view as requested.

Right, I've stipped it down to one main form and one subform. The main form is linked to a query. The subform has a link master field / link child field set up to the main form. The results are being displayed as I would want them to be. Yet I am still getting the same problem :mad: this is...

Fraid so tried that.. no change! There are several subforms on this page, with only one visible. Usually the command makes whichever one is visible into datasheet view.. but I've tried stripping it down until there is only one subform, setting focus, then doing the command. Still fails..

I've tried everything I can think of.. if I maximise the background and right click and do form -> datasheet view it works fine.. so no idea why I cant do this by code! Could it be anything to do with the recordsource of the form? On my form where the command works fine the subform is linked...

still stuck on this :(

Hi I'm trying to get my subform to switch between form view and datasheet view with the following commands: DoCmd.RunCommand acCmdSubformDatasheetView DoCmd.RunCommand acCmdSubformFormView I'm getting the error: 'The command or action 'SubformDatasheetView' isn't available now.' The command...

Aaaah the main form was linked to a query but the subform was linked directly to the table. Changed this and its working now wihtout making the subform invisible! thanks. Not sure why it was dependant on the amount of data in the field, but I'm beyond caring now :)

Interesting update: There is a subform open that is linked to the same table (although the field I am trying to update is not bound to this form). If I set its visibility to false before I try to update the table by code, the problem, goes away! So I have Me.subformExhibitInfo.Visible =...

It's an access back end, so the memo field should be able to hold a lot more than 2048 characters, hence im a bit confused as to why the code works fine for small amounts of text, but doestn work for larger amounts of text. Also the memo field is not displayed on screen or bound to any form. The...

Hi We've got a rather strange problem with our access database, we're getting the following error while trying to udpate the text in a memo field 'Could not save; currently locked by another user' This occurs if only one person is using the database. Performing a compact/repair doenst fix the...

Tried it without the .Value and calling it from the form instead, and it's now saying 'you cant assign a value to this object' maybe it's one of those things that cant be controlled by code..

I've got the button positioning working by using pixels as suggested thanks! Although I'm still stuck on activating/deactivating the control box It's saying 'invalid qualifier' The change is taking place from a module 'MainControl' in a sub that is called by the form load propery Private...

Hi I'm trying to activate/deactivate the form control box, and change the position of some buttons by code, but it wont let me do either TargetForm.ControlBox = False TargetForm.CloseButton.Left = 12.354 TargetForm.CloseButton.Top = 0 TargetForm.CloseButton.Width = 0.593...

How do you log everyone off? If I want to update the server file or compact/repair etc I have to run aroudn asking everyone to close down access which is a bit of a pain! Is there a better way?

Yes they all have the front end client. I'm going to build a version that keeps a persistant connection and distribute it! thanks peeps this has saved me much grief 303

Although I thought I had a persistant connection, I tried the 'bound form' solution on the link you gave me, and it seems to speed it up significantly! One further question though, are there any risks keeping a persistant connection? Up to 10 staff will be logged onto the server file at once...

Yes I think so, if one person has the client open there is always an LDB file in the same folder as the MDB file.

Hi My VB client links to a set of data tables that are stored on a shared network drive (the 'Z' drive). I develop it on my C drive (the local client) then distribute it for everyone to use with a server database (the live client) Recently we've had complaints the live client is running...