Search results

I use the adhOfficeGetFileName function in a MS Access application to allow the user to browse for a file. This works fine, except for filenames with accents on characters, f.i. with ‘ź’ in it. The function then returns the filename with a question mark on the place of the character with the...

I would like a solution for the following problem. A table in my database has the following fields: - intID: long - strDescription: string 50 characters: This is a description of a particular image - strURL: string 255 characters: this is an URL that links to a particular image on the web I...

Hi, I'm trying to migrate an Access 2000 project to Access 2007. I want that the frontend doesn't look like Access. This means: no ribbons, no office button, no Quick Access Toolbar, no database panel. In 2K, this was rather simple, but in 2007 I only managed so far to get rid of the ribbon (by...

Hi, When an error occurs I use the VBA error trapping to log the name of the screen, the user, the error number and the error description in a table. Is it possible to dump the local variables (f.i. as seen in the Locals Window) as well ? Can this be done with VBA or with an API ?

In an MS Access 2000 - SQL Server 2005 project I use a "Microsoft Office PivotTable 9.0" control on a form. The control is populated by a stored procedure. This works fine but when the pivottable opens a messagebox with the title "Microsoft Data Access Components" and a message "This page...

In an MS Access 2000 - SQL Server 2005 project I use a "Microsoft Office PivotTable 9.0" control on a form. The control is populated by a stored procedure. This works fine but when the pivottable opens a messagebox with the title "Microsoft Data Access Components" and a message "This page...

I have a report in MS Access XP with a textbox bound to number field. I want to display the number as 12 123,12 (a space for the thousands separator, a comma as decimal point and 2 decimals). In the format property of the textbox I type in ##\ ##0,00 Access doesn't accept this setting and...

I have a form where the recordsource is a stored procedure. This forms shows a list. When the user clicks on a column title, the column is sorted by using OrderBy in VBA: f.i.: Private Sub lblCode_Click() Me.OrderBy = "strCode" End Sub As a result, in the properties of the form, for...

I made a webhelp project with RoboHelp HTML X5.0.1. I want to integrate these helpfile in a MS Access project 2000 application. These are my goals: - if users click the help in the helpmenu they see the application helpfile - users can use the "what's this" function - in a field, users press F1...