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

I have a database that does this, I use the sendobject.sendreport command and loop through the records I put the code on the on open event of the default form and I use Task Scheduler to run the database at a specific time everyday.

everyone is probably going to give you a lot of code to do this, but if it is as simple as firstname<space>lastname then I would export the table to comma delimited (text file) then open it in MS Word and do a find and replace for the <space> with a comma (or other delimiter) and then import it...

If all you want is a splash screen, then save your splash screen image in the same directory and with the same name as your MDB file. If want you want is a form to pop up then that's a little different depending on what you want.

Thanks Peter that works great.

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

my joins were wrong. Thanks.

yeah, I realized that about 10 minutes ago, although now I'm having problems with that, It doesnt seem to be updating. If I run it it tells me that a user has modified the record.... but it doesn't update the other records I set the update value to the two form objects.. UPDATE tblFull INNER...

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

using the data tools in Excel you can actually link a spreadsheet to a database in go to Data/Get External Data and New Database Query, it's pretty easy to walk through if you have good knowledge of Access and Excel. The first time you open the workbook after saving it it will prompt you to...

what about exporting it to HTML and having an embedded webpage object. Not sure about the details.

I know this is a little late, but you can embed a snp report into a webpage, or even better would be printing the report as a PDF.

Well, what I would try doing is everything you said, but then I would rename the external file that you have a reference to, and then try to compile it...aha missing reference, remove the reference and try again....SUCCESS. Somehow (and someone may be able to answer this one) even though the...

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 wound up giving up on this method, instead what I did was create a query SELECT tblShowWeeklyReminder.WeeklyReminder, tblShowWeeklyReminder.ShowValue FROM tblShowWeeklyReminder WHERE (((tblShowWeeklyReminder.WeeklyReminder)=1) AND ((tblShowWeeklyReminder.ShowValue)=True)); and then use the...

You can put your database online, which is a little advanced and would require a program like Dreamweaver Ultradev (or Dreamweaver MX). Or you could request that secure.com send you the information in comma delimited format in the same order as your database fields and write an import routine...

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