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...

Thank you so much lespaul. I have created a new table and an update query; CODE: UPDATE LANGUAGESCORES LEFT JOIN tblnumericscores ON LANGUAGESCORES.[Test Score] = tblnumericscores.TestScore SET LANGUAGESCORES.TESTSCORENumeric = [TBLNUMERICSCORES].[NUMERICVALUE]; It works fine. Thanks again.

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...

Thank you so much Richard. Yes, I need to move from location A to B couple of times. It is very time consuming to re-link every record to the word document. I will try to create code to toggle from N: to D:. If you have code already written can you post it here. Thanks, Seda

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

I will try to email you. What is your email address. Thank you taking your time .

I would like to know why is a bad idea storing calculated field in the table or form. The reason I would like to store the calculated field is; I have one to many relations for each Activity with four different tables(transfer table, Travler table, contractor table, publication table). When I...

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) +...