Search results for query: *

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

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

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

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

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

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

I have a table which contains the number of times that users have accessed a particular facility. I have produced a report via a query to list the total number of times that each user has accessed the facilty. This works fine, but over time the report is getting lengthy. Is there a way, within...

I have modified an existing database for a new application comprising just one form and one report. The original application printed to a specific printer, I require the new application to print to my default printer. I have done File/Page Setup/Page for the form and changed specific printer...

I have a combo box on a form called APPLCTN. I wish to restrict the values displayed by the combo box depending on the field SiteCode within the APPLCTN form. I have set the Row Source Type to Table/Query and the Row Source to SELECT [CERTIF].[CERTNO] FROM CERTIF WHERE...

I have a number of Access 2000 reports which I wish to print double sided. I have set my default printer preferences to "Print On Both Sides" and am using the following command to print the reports DoCmd.OpenReport ReportName, AcNormal, ,Criteria The reports however print out single sided...

I have a number of .bat files which I run at regular intervals via the Task Scheduler. These all ran OK under 2000. My PC has recently been upgraded to XP and these jobs now fail to run. When I edit the .bat file I get a warning message "The publisher could not be verified. Are you sure you want...

If users are logging onto an Access database (2000) via an MDW file is it possible, within Access, to examine the LDB file to find out which user(s) are currently connected.

I have created a macro to export a table to a delimited text file using a Schema.ini file. When I execute the macro I get an "option is invalid" error on one of the fields so I need to modify the schema.ini file. The schema.ini file was created via the Advanced button on the Export command and I...