Crieteria Behaving Oddly?
Feb 26, 2007
I have a form which is to do with quotations which i generate. Parent Table 'FrmQuotations' and Sub Table 'FrmQuoteItems' the 2nd table details line items etc.
I have set up a query which takes the total cost prices from the total sell prices to provide a gross profit figure.
In the query, the first item is 'QuoteID' and in the criteria I expected to be able to say [Forms].[FrmQuotation].[QuoteID] so that when in a quotation displayed in FrmQuotation it would automatically generate the query based on the quote id of the open record.
Instead it always asks for the quoteID? Any advice? Thanks.
View Replies
Dec 19, 2006
Hi,
I´m having trouble with an automated process.
First, access exports a table to a text file.
Second, excel opens the file and runs a macro on a workbook that contains linked data to the file.
The workbook is linked back in access.
A few days ago I started having problems. Sometimes the file can´t be exported because of authority problems (this is because the excel object doesn´t quit after having done the operations but locks the file so that the next time the process runs, it halts)
Question: Is there a command in VBA that absolutely certain kills the instance of excel? (in worst case I´m ok with a command that kills all instances of excel)
I also have problems within the macro itself. Excel complains about the "range method of global failed" or something like that.
The thing is, it works when I run just this part of the process, but not combined with a few others.
It worked fine until a few days ago, and the only thing I´ve done is that I have added a few graphs on the main form.
Has anyone had similar experiences? Might there be some sort of memory insufficiency?
Fuga.
View 5 Replies
View Related
Feb 4, 2007
Hi,
I'm a bit puzzled with this so hopefully someone can help me out. I have a database that has around 20 users who key on their vehicle orders. The main orders table has a number of fields. I have started to notice that the 'Order Date' field that gets populated on completion of the record is now blank on almost half the records. (I have retrieved an older copy of the DB and the dates are there, so they did get input at one point). Further more, I have another field called Business Group which is a look up to a linked table. The Orders table is showing the records in Business Group Ascending order for some reason rather than by the primary key. And finally, when I open the table a progress bar appears at the bottom of the screen stating 'running query'. It seems my main table is now behaving like a query and is losing data.
Anybody got an idea what's going on?
And yes I have definately checked it is a table. Im using 97
Cheers
View 1 Replies
View Related
Jun 8, 2007
In my DB, I have a date field. The default format is set as 'dd-mm-yyyy'. I have made query to view the records of a particular day. On hitting the command button which is linked to the query, it asks for the Date input.
Now comes the strange behaviour of the query. If I type 04-06-2007 (i.e. 4th June 2007), records of 06-04-2007 (i.e. 6th April 2007) are shown. If I type 06-04-2007, records of 4th June 2007 are displayed. Why is this strange behaviour? How can I correct this problem? Please help.
View 1 Replies
View Related
