Search results for query: *

I have two tables; Abstract table and the Completion table. They submit a tentative proposed budget goes into the Abstract table after they completed the activity they submit actual budget which goes into the Completion table. I would like to generate a report that if Completion reports...

I have been trying to automate my update query. I have a database that imports data from excel file. One of the field captures test scores and they are in a text format. I would like to update these values into a numeric values in a new field. Like: TestScore TestScoreNumeric (NEW Field with...

I post this question at another Thread but could not get any answer. Please help? I have a table which one of the field is Hyperlink to Word document. I have 244 records in my table and each records link to Word document. The problem that I have is that if I move to word document the link will...

Hi, I have a table which one of the field is Hyperlink to Word document. I have 244 records in my table and each records link to Word document. The problem that I have is that if I move to word document the link will not be there. Is there a way that the link can be made more dynamic? Thank you...

I would like to update partial Hyperlink fileds in Update query. For example existing fields starts with \\Fs3 but I want to replace with D:\ and keep rest of the hyperlink(text in the field) Existing records looks like this: \\Fs3\agency public data\Project Plans\AF\Cameroon\Plan\FY...

Hi All, I want to my database closes automatically every night at 12:00am. The database locates at the Agency Server. If somebody forgets to log off from the database, it fails to back up. Is it posibble to close it by itself? Any help is as always greatly appreciated. Seda

Hi all, I am working in Access 2000. I would like to copy calculated field from one table to another table. My database’s relations set-up with Act_no field through out the database. I have main form name is Activiy Tracking based on Activity Query(ipbs_test(table) +...