Search results

Thanks for the help from eveyone but i just ended up importing all the new tables queries forms and reports in to an older, stable version of the database. Still don't know what was causing the error because everything works fine in the new combined version. Maybe some weird corruption issue.

It has been replaced. All of the queries were built with the new table that is named "pipeline historical." I have no idea were the references to the old table came from and I get the same error from forms that were built before this newest form.

I tried adding the bracekts but it still returns the errors. The weird thing is that pipe hsit is an old table I had that was renamed and then deleted. I don't understand why thre would be any references to it since the form and report and the new table and the new queries were all created...

When I try to add a button to a form I get the follwoing error. Compile error. in query expression 'AppLoadString([bw_tblBtnActions].[Description])' I have other forms with buttons on them that jsut open reports. When I click any of them I get this next error. Compile error: Invalid...

I have a table that lists prospective sales as they travel through time in the sales process. Every month a snapshot is taken of the sales progress and uploaded to the table. This table has an autonumber as the primary key because the unique sales ID for all of these often duplicates when the...

Nevermind, I figured out how to add the autonumber. I feel kinda dumb in retrospect cause its easy. (In case anyone finds this through search just go into design view and add a field and select autonumber.) II'm going to play around with this solution for awhile and hopefully it works for...

I was just exploring this possibility but my only question is that many of these sales sit around pending for months so they would apear in the list many times. Is there an easy way to combine these tables and add a new autonumber as the primary key. The original Primary keys (the sale ID...

Alright I don't know if this can be done but I've been given this task by higher ups so I ahve to at elast try. The database I'm using has different tables going abck once a month for pending sales. These are each essentaily a snapshot in time of how far along the sales are and how many of...

Thanks a ton man. It took me a minute to figure out what you meant but I got my queries fully updated and a working form. Thanks again its a big help.

So I tried to create a form with a command button that opens up a report and a text box. I want to have the report accept the text from the text as input 12 times over. What would I ahve to add to the VBA code? Private Sub report_Click() On Error GoTo Err_report_Click Dim stDocName As...

Sorry this reply is so late but neileg your advice worked perfectly. Thanks again.

I have a report I created to that gives lots of different information on sales. The only problem is that it is made up of a bunch of subreports derived from queries and each of these need its own input. However, it is all the same input (a string that gives the year and month of the records...

I have to list sales by divison and for a period from a table that includes all prospective sales successful or otherwise. So I have designed a query to display the divison name and then the sums and counts for sales in the division. I then have 2 "where" functions to get the correct time...