Search results

Hi, Thank you for all your suggestion. Done it in Report. Although I was told it was a standard report contents then contents may be changed. So done it report

I have a WORD document which should be a standard doc for all project. After printing report for the project in Access, I want the WORD document to be printed at end of report so user could have everything by clicking a button. How can I trigger to print a WORD doc from Access. Many thanks

Hi, I am using a table with 4 column in WORD 2003 to keep track of events. Titled Like : Place Event remarks As those info would be various in width and length. Since I would only set the paper to landscape however, some of the information still got truncated...

Hi Got 2 problem to resolved. 1. A form to gather info for job but some fields are not neccessary (hence each job required info is different) and user want to just fill in the required fields then either click on the Exit button or Next form which capture other information for the job and the...

Hi there, Three tables. Craete record on first table on form1 which has a button to next form which create the record on 2nd table which in turn has a button to open a form to create record in 3rd tables. However always get error to say there a related record required in 2nd table. I have...

I have 3 tables which info are related. For example, table 1 must have a record which would have many record in table 2. In turn each record in table 2 would have many record in table 3. At present, the way I set it is a form for table 1 which then open up a second form for input which in turn...

Tried that but same result

I was going to add a new record to a table but keep getting error to say I need a related record on a related table which record already existed. Have checked many time. Also I have not done any relation between the two tables. Am I going senile ?

Additional info MSAccess 2003 but 2000 file format, Win XP pro, Office sp3 and hotfix for sp3

Hi, The following keep coming up and I didn't do any cancelling operation. Run-Time error '2001' You canceled the previous operation. My code is If DCount("[CategoryID]", "TCategory", "[Category] ='" & Me!Category & "'") = 0 Then DoCmd.RunSQL "INSERT INTO TCategory...

Hi there, The refresh doesn't work the way I want it but I have used another way to do it. Instead of deleting the record, I logically mark it for deletion then the refresh work and on form exit, I deleted the logically marked record. Many thanks

Hi guy, The hotfix must be working. Yes, the sorting seems to work and also the refresh statement as well. Thought I was going mad. Thank you guys for all your help. Have a good evening

Hi guys, Thank you so much for your help. The checking is resolved but I will investigate Binsta's suggestion for future reference. Have a good evening

Hi Guys, Thank you so much. Now it make senses. Apology being so 'stuborn'. Getting too late. Have a nice evening.

Hi there, Thank you for replying. I understand what you are saying. I may have used the wrong wordings for the title. last week the error only occurred when the table is totally empty. If there was record, I don't get any error when appending the records to the table for anothe project...

Hi there, Please excuse me being naive. I don't understand how could a DCount help. I could do a DCount before append record to the table but it doesn't give me the info whether any record existed for a specific project.

Hi there, You are right. The auto doesn't work. (I thought it should). Anyway before I read your latest reply, I have already install the hotfix and will try it out tomorrow. Thanks guy, watch this space. Should update you nice guys tomorrow.

Ahhhhhhh. I set the update automatically and yes, it was installed. I am off to install the hotfix now. I am doing it though autoupdate. talk to u later

Hi there, Thank you for your advice. I find it abit difficult to follow but as you said it was a very crash notes. Would you mind to show me how to do it in DLookup. I found that if the file is empty or don't have any record for a particular project, I always get the Runtime error 94 - Invalid...

Hi there, I am using Office 2003 but on the menu bar, the file format is 2000. On Windows Xp Pro sp2 I noticed that I used to be able to achieve various basic using certain syntax but don't seems to be able to do it any more. For example, refresh form using code created by command button or...