Search results

I have a spreadsheet that has Account Number, Trade Date (mm/dd/yyyy), and Trade Amount ($). What I need is to group by Account Numbers, and Sum Trade Amounts for any trades falling within a 30 days of each other (any 30 days, not necessarily the same calendar month) and determine if it is more...

I have the line Shell "C:\program files\programname\batchfile.bat" on the on open event of a form, but when it runs it gets the error message that the CMD.exe was started with the above path as the current directory (a UNC) CMD will now default to the windows directory..but nothing ever...

This is driving me crazy. I have a listbox that is generated from the selection in a combo box on the same form (the listbox data is determined by the combo box value and After_update of the combo box refreshes the listbox. Here's the issue. If you highlight a record in the listbox and then...

I have a form that list a single record and has two true/false fields on it. On the form is a list box that lists other records belonging to the same group as the "main" record on the form. I have a button that I would like the onclick event be to set the two true/false fields on the records in...

I have recently installed Access XP on a machine which already had Access 2000, I chose to install it to a different directory and save all previous versions. Whenever I run the 2002 version the next time I run the 2000 version it runs through the "configuring Access 2000 for use" stuff for...

I have the following code to test if a recordset is empty and if so delete a record, if not a msgbox telling them it is not empty basically. It ALWAYS seems to find matches in the recordset, even if there aren't any even if I set MySQL to a constant instead of Me!lstSchedule. help. Private Sub...

I have created a database with mulitple forms and reports and a refernce to an external database in the VBA editor. My access database compiles, it compacts (with both Access and Jet 4) and is fully functional as an mdb. When I try to create an mde file i get the above message, I have created...

I have a pop up form when my database opens that is actually opened by another form. I want the user to be able to check a box to turn off the pop up. I have a table with one record and two fields , the number 1 and a Yes/No field to determine if they get the popup (checked is "Show Pop Up") I...

I need to run a report based on a query for each value in a field of the query. Here's what I have, a query that shows a list of users and projects. I would like to run a report that shows all the user's projects for each user, it needs to be a separate report for each one since I will be...

I have a database which allows users to import data from an excel file that is located in /forms/user.xls off the root of the database. There is a button to open the spreadsheet to edit it and a button to import the data from the spreadsheet. The problem is that the spreadsheet retains the...

I have a form with a combo box on it that shows our companies employees. It has 2 columns the first one bound [UserID] and the second one an expression showing [LastName]&", "&[FirstName]. The first column has size 0. If a name is not in the database there is a button next to it that opens a...

does anyone know a relatively simple way to add add columns to a report depending on values in a field. The example is we want to generate an invoice showing people that billed hours to a certain client, but it HAS to be in the clients format which has the names of billing attys. as column...

How do you specify a template with the SendObject command, I can't get it to work. I have tried the full file path, relative file path, in quoted, not it quotes.... Do the other parameters matter (do they cancel the template??)