Search results
-
A
Making MDE File Problem
I,m trying to create mde file but a dreadful error mesage appeared :( Here it is: This error is usually associated with compiling a large database into an MDE file. Due to the method used to compile the database, a considerable number of TableID references are created for each table. The... -
A
Parameter query
Hi All, How can I check the Parameter query interval is out of range? Details: I have a table with Date column. With parameter query(by Date field) I extract records between two dates. How could I make a check when taping in Inputboxes, am I or Not Between the Last and the First Date? Thanks! -
A
Txt Box in a Report Looking Up to another Record source
HI All I am trying to create a report whose record source is a for example 'Query 1'. So, now I have to place a txt box whose record source has to be diffrent from 'Query 1'. How this could be done? Please help.Thanks! -
A
Variable in a query
Is it possible to use variable in a query criteria? For example: DateAdd Func has 3 arguments (Arg. 1, Arg. 2, Arg.3) -> Arg.2 is Integer. I want Arg.2 to be a variable and its value come from a Txt Box placed on a Form. Thanks! -
A
DMax and DateDiff func
HI All, I'm using Between DMax("DateFieldName","TableName")-10 And DMax("DateFieldName","TableName") expression in query to find time interval 10 days prior the last record puting this into Date field in my query Criteria. It's working fine. But I want to find time interval a Month and an... -
A
Is it possible..... to link external file again
When I rightclick on the linked table there is a thing called Linked Table Menager and there is a check box 'Allways prompt for new location'.That seats me fine but doesn't work. In my opinion if this check box is selected every time the database is open Linked Table Menager is expected to... -
A
Is it possible..... to link external file again
What if the backend is linked text file? -
A
Is it possible..... to link external file again
Is it possible to link external file again when database is ready and the source file has been moved to other location? And going farther -> is it possible to create some kind of dialog wich prompts user to point the external file as linked? Thanks! -
A
Numeric Field Overflow ->with linked txt file
No Sometimes is working ,sometimes Not -
A
Numeric Field Overflow ->with linked txt file
May be you're right! I 've removed column with non-numeric values and for now is working. Thanks! -
A
Numeric Field Overflow ->with linked txt file
When I'm trying to execute a query using agregate functions. This error message occurs "Numeric Field Overflow". The table is linked to text file. Any idea? -
A
Date\Time period between last record in table and given Time interval
:D Yes, Now is working, the way it should do! Thanks a lot! -
A
Date\Time period between last record in table and given Time interval
'Disappeared column' is fixed. What now troubles me is when I use the function given to me from JonK(I'm very grateful to him) returned records slightely differ from what I expected. If last Date is 06-Apr-2005 7:00:00 PM when I execute the query(10 days prior) the first record is... -
A
Date\Time period between last record in table and given Time interval
I think is working but Date column disappeared -
A
Date\Time period between last record in table and given Time interval
Thanks, I'll try it! -
A
Date\Time period between last record in table and given Time interval
HI all, I am still new in Access databases :o I have a table with 'General Date' column. So I have to create query wich extracts records between Last record (via Date field) and 'for example' 10 days before. But Last record in Date column may differ from Now(). When this is done I have...