Search results

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

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

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 ?

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, I have not used MSAccess for sometime (not a expert to begin with). I know I used to be able to do quite a few thing but I don't seems to be able to use the same syntax for same operations. I have various records display on a form when a record is added or deleted, I want the form be...

Hi, I want to insert some records into a table. (The records are from one table (TProducts) and depended on user input, the records will be copied to another table (TProject) for user to make changes. Hence in the Table TProject, the records would be vary). At present, I used a query to do it...

Hi there, Not sure whether I am in the right forum. It is Table, Form and Query. Have a table which index to sort on 4 fields - Proj, SubProj, Team, SubTeam. 1. I used this Table on a form, the data seems to be in random sequence instead of above. 2. Then I tried to sort it in a query which...

Hi Got a continue form which has a checkbox. I want to have this checkbox to turn on if the a field value is found on another table. For example, List of item with checkbox beside them Table 1 with follow values desk tv record cd rewriter pencil pen pencil Table 2 with following values...

Hi, I have been getting this error the whole afternoon and having been trying to reduce the parameters to identify which one is causing the problem. Then tried different datatye but still no joy. I have double checked again and again with the tables layout, and think only one place would be...

Hi, Is there a way to create subsection in form just like we do in report. In report, I use the wizard to help me to make the grouping. So I have no idea how it is created manually. I need to display data in certain ways - Just like the subsection types in report. Could this be done in form ...

Have a report which I need to 'auto add' a sequrence to grouping and subgrouping, Just like bullets and numbering in MSWORD. Can this be done in MS Access Report please ? So the numbering is 1 xxxxxxxxxxxxxxxxxxx 1.1 xxxxxxx 1.2 xxxxxxxxxx 1.3 xxxxxxxxxxxxx 1.4...

Hi there, Don' t know what happen, have not change any settings but the command button or subform/subreport wizard doesn't work at all. There may be other wizard which doesn' t work but at present only aware of those two. When creating form and report, the wizard still work. Used to be able to...

Hi there, This may mean stupid question to you but I find that some of the events or types in the properties which give me 'no meaning' at all. For example, has module on form, on retreat on report. THIS IS ONLY A sample, my list would be endless. Thanks in advance

I want a form to display specific customer order on a subform when select by customer id or customer name in a combo box. In the main form. At present, I can't get data populated on the main form let along the subform. I know this can be done, I checked the northwind sample but just can't see...

Hi, I am not an experience user, at present, I face two problems in one of the form 1. Display format in a continue form, please see further down for required display format. 2. How can I allow multiple checkbox or option selection in a continue form. Since I don’t know how to do the required...