Search results for query: *

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...

I have created a DLL using Visual Fortran to perform a series of calculation. The routine is called from a button on an Access form. This works OK on my PC and a number of others but in a few cases users get a File Not Found message for the DLL Lib file declared in the VB statement. These PCs...

I am using Access as a front end to a Fortran 90 program. The F90 code does all the hard work and writes its results to a text file. I wish to automatically display the contents of the results file to the user, either via a button on the form or VB, but can't find how to do it. Any suggestions...

I am trying to convert from 97 to 2000 but get a permissions error on tables Msysobjects and Msysaces. When I look at the table permissions user Admin does not have Administrative permission but I cannot give Admin this permission as the owner of the table is Engine. How do I give Admin the...

I am trying to read a free text file from a module using the following code intHandle=FreeFile() strFilename="Filename" Open strFilename For Input As #intHandle Do While Not EOF(intHandle) Input #intHandle, strLine etc but each input statement seems to break on a comma not at the end of a...

I am using Access Reports to produce a number of letters with dates within the text. All my dates are in Long Date format so there can be a large difference in field widths between "11 May 1991" and "20 September 2008" etc. This tends to leave a lot of white space within the letters. Is there...