Recent content by Sanibel

Sorry. The problem was not with my VB code but with the form that I was using to display the results. Which I have now resolved. Thanks to those who replied anyway.

Using VB in Access 2007 I am trying to insert up to 500 characters into a memo field. The memo field is always truncated at 256 characters. The insert has worked, data following the memo field in the same Insert statement is inserted into other fields OK. Does anyone know what is causing the...

I have resolved this problem. In case others have the same problem look under Access Options/Current Database. The Document Windows Option should be set to Overlapping Windows not the default value of Tabbed Documents.

In Access 2007 I am unable to see the min/max buttons on any of my forms. I have the BorderStyle set to Thin, ControlBox to Yes and MinMaxButtons to Both Enabled. The buttons are not displayed when I work with forms in Design View either so it could be a database not a forms problem. Have tried...

I have an Access VB routine which prompts the user to enter the name of an Excel spreadsheet and import data. It would be much neater if the user could use MS Explore to locate the required file. Does anybody know how I can run MS Explore in VB and get the full path and filename of the selected...

Thanks for the suggestion but I have already tried that. When I convert the MDW file I get a couple of errors saying it can't read MsysObjects and MsysACEs but it does produce a new MDW file. Unfortunately when I try to open the database using that I get a "You do not have the necessary...

I have converted an Access 97 database to 2000 but am unable to open it using my 97 MDW file, getting a "not a valid account or password" error. What do I need to do to convert the 97 MDW file to 2000? Thanks

I wish to add some code to an Access 2000 form which will run if the user selects to Undo any changes but I can't find On Undo in the list of form events. Looking on the web it seems to imply that it should be available. If it is not available, how can I trap when Undo is hit. thanks

Thanks for the suggestions. Both run but produce my original problem. Data is loaded into the Schedule Codes form but each load overwrites the first record leaving me with just the last data loaded. I still can't move onto the next record in form Schedule Codes so that all loaded data is displayed.

Hi, I am trying to load a number of records into a subform "Schedule Codes" from form "Certif" using the followowing code. Do While Not RS.EOF With RS Forms![certif]![schedule codes]![GroupNo] = !GroupNo Forms![certif]![schedule codes]![Code] = !Code Forms![certif]![schedule...

Thanks very much. That was just what I was looking for.

I have a number of reports in tabular form which only contain a few columns. The reports are quite long so go over a number of pages. Is there a way that I can force reports to print more than one set of data alongside each other ie to convert ValA1 ValA2 ValA3 ValB1 ValB2 ValB3 ValC1...

Thanks for the advice. The Record Locks property was set to All Records on just a few of my reports, including the one that first highlighted the problem. Setting these to No Locks has resolved the issue. Thanks for all your helpful suggestions.

Thanks for the suggestion. I have split the database into a front and back-end. I have created two front-ends and tried opening the form in one and running the report in the other and still get the same "could not lock table" error. Any further thoughts?

I have written a shared Access database but am getting the following error whem testing it in a multiuser environment. Could not lock table xxx; currently in use by user yyy on machine zzz. I get this error if user A has a form open and user B tries to run a report accessing data from the same...