Search results

Hi everyone, A simple question here: I try to copy my 97 access database application to 2000 version I recently installed, but I could not run my db since it dose not recognize the DAO objects, such as object currentdb ..., in my code. I would like use DAO objects in the access 2000, what...

Hi all, Here is a simple question: I have a few users (2-4) may use the db application at the same time, so I decide to make my Access database application as replicated system. Before I use the replicate menu in the access interface or write the code to make the system becomes replicated, do I...

Hi All, I have a function that checks the CQ evaluation expired date in my Access DB. The Expired date using the short date format is DD/MM/YYYY When I use Datepart function to extract the month from the Expired date, the function returns wrong Month. Also, I have a very simple function to...

Hi All, I am developing a BDMS by using Access, have been asked to publish data to a word table, I inserted some bookmarks into this table. I try to pull data form access and insert these data onto mapped bookmarks. When I run the code, I get a runtime error: You entered multiple destinations...

Hi All, I set up a word template and have inserted some bookmarks into a table in the template. I try to pull some data form access to this word template. However, I get a runtime error: You entered multiple destinations for a page, line, footnode, endnote or document. I had done some programs...

Hi all, I have encountered an update Query prolem. the following is my code: ResultSql = "UPDATE ExamResult SET ExamResult.Rsult = " & DoubleQuote(Me![Result]) _ & " WHERE (((ExamResult.AppFileNo)Like '* " & AppId & "*') AND " _ & "((ExamResult.ExamName)Like '*" &...

Hi all, I have Export data from access to Excel worksheet. I am trying to change font weight form normal to Bold form each Schedule heading and Schedule table colmn headings on the fly. I have tried by using: with objWs.Row(PreColheading, PreColHeading+3) .Font.Bold = True .Cell(..) end...

Hello Everyone, Although I am new to the forum, I have search this forum and get greate help. I have worked on a DBMS application project using Access for 5 months. I adapt Automation for my project, so my user can pull data form access to word and Excel for varies of Letters, and schedules...

Hello everyone, I need help for how to set up a word doc on templet so that I can export report or pull data from my Access database through MailMerge to the specified word doc. I can open an empty word doc from Access by using vba code, however, I could not pull the data to the word doc and I...