Search results

I’m having a problem displaying my charts in Access 2k. Anything greater than 3.4 inches, in either height or width, gets cut off. That size is far too small for most of the charts and graphs I’m trying to build. Can anyone help me get the charts working or recommend an add-in?

I've got an Access 2k database with a linked table connected to an Excel spreadsheet. Unfortunately the name of the Excel file changes daily (the name includes the date). Is there a programmatic way to update the path of a linked table? I'd like to avoid forcing my users to run the Linked Table...

Hello everyone. I have here a function I wrote to forecast sales. Basically, I’m trying to adapt Excel's 'Forecast' function for use in Access 97. The code below works, but is rather slow. I'm hoping someone can help me improve it. The function pulls from a table, tblMonthlySalesAll, that...

I don't know whether or not what I want to do is feasible. But, I have a module that runs some action queries using the CurrentDb.Execute method. While that module is running I also have a form with a sub in its On Timer event that updates some controls on the form. The problem is when the...

Hello everyone. I have a form that uses a multiselect list box to set its filter. This much works fine. What I'd like to do now is code the list box to deselect all other items if one certain item is selected. Here is a sample list to help illustrate what I'm trying to do. All Green Blue Red...

Hi all. I’m having a problem with questionnaire I’m building. Technically I think this is a problem with a form. But I’m posting it here because I’ve got a feeling the solution will lie in code. The questionnaire is built as a form containing a question with a continuous subform listing a number...

I have an old DOS based database that I’ve been manipulating with some Access scripts. Basically I take information from my Access DB and use sendkeys functions to copy the information into the old DB. (Not pretty, I know. But, the old DB only accepts keystroke input.) Everything worked fine...

I'm trying to create a script that appends or updates a table when a report is opened. I've written a script and tied it into the report's 'On Open' event. It works fine except for one thing. When the script goes to update the table I get a popup message that says, "You won't be able to undo the...

I'm creating a user-defined function. As part of this function I need to sum the total values of a field, [Qty]. However, I can't figure out how VB sums values over multiple records. The following code produces an error message "Sub or function not defined." Dim intResult As Integer Dim vrQty...