Hi Ramu,
Look, try to remove "Compact on Close" option. This must solve the problem. Then make a schedule for compacting the database manually, maybe every week or two. By the way, how big is your database?
Abolos...
abolos
Last Activity: Sep 25 '07, 01:42 PM
Joined: Apr 27 '07
Location:
-
Thank you for your suggestion, but actually it didn't work. Could you please revise it and write it back.
Thanks for your efforts,
Abolos...Leave a comment:
-
textbox not working if in the header of the form
Hello all,
I have a query with the following code:
SELECT tblData.Name
FROM tblData
WHERE (((tblData.Talk ) Like "*" & [forms]![frmtbltalksdata search]![text30] & "*"));
The text30 is in the header of the form and not in its detail section. Because of this the query is not running correctly. Instead of giving me the records that contains the work in text30,... -
Thanks linq for the explanation and sorry for making things this way....Leave a comment:
-
opened files in other computer in my network
Hi,
I want to know if there is a utility built-in in Windows XP that can let me know what files are opened in another computer in my network. If a free third party utility is available, then it is OK.
Thank you,
Abolos -
good job mmaccarthy. very useful SQL statements.Leave a comment:
-
Suppose you have a combobox in the header of the form and you have many textboxes in the detail. If you want to have the combobox in the header to be selected when running the form, then you have to use the setfocus command.
For the textboxes, whenever you want to use the value or the text that the textbox contains, then you must use the setfocus. ex. if using <SELECT ... WHERE textbox=??>, then you have to setfocus the textbox...Leave a comment:
-
Thanks for your suggestions, I'll try to use the timer and see. I'm using Access 2000 in this database....Leave a comment:
-
You also may try the SQL by creating a query and open the SQL view then past it there.
Abolos...Leave a comment:
-
You may use this:
Shell ("c:\windows\sy stem32\net send <computer name> hi")...Leave a comment:
-
abolos replied to Help building a simple query from two tables, limited by the records in one table?in AccessHi,
use the SELECT SQL command.
SELECT <field> from <table1> where Address line 1 =physical address 1
abolos...Leave a comment:
-
In your case you may use the SELECT SQL statement. Give it a try.
Abolos...Leave a comment:
-
Use this:
Select MAX(field) from <tablename>
This sql will bring you the max number in the table, then add to it 1. Use the Insert or Update sql statement to update it if they want.
For any other help feedback,
Abolos...Leave a comment:
-
As to my knowledge you have to pay for it....Leave a comment:
-
As to my knowledge you have to pay for it....Leave a comment:
-
Hi,
Try to use the SUM.
Select SUM(hours) from <tablename> where name = A
This SQL statement will give you the summation of whatever A has. Then multiply it by 10 in a field. Last put the result in another field (10*19).
Abolos...Leave a comment:
-
Just one other hint for Manoj missinglinq.... ......... thanks.
Go now to Forms and create a form for this table using a wizard, this is the easiest way for you now.
Abolos...Leave a comment:
-
Thank you guys for your assistance regarding this matter,
AbolosLeave a comment:
-
Try not to delete the record, just mark it as deleted programatically . Add a field named Deleted and make its type Yes/No. When you delete the name then the Deleted will be Yes. And then make a query so that not to show you the Yes data. This will now show the deleted data for you, but will keep having it in its calculation.
Hope you are happy with this.
Abolos...Leave a comment:
-
You can create a sub report in the main report. This is just an idea between much more. But to me I find it fine.
Abolos...Leave a comment:
No activity results to display
Leave a comment: