Search results

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

The reason which was 1, just because I was using 1 to test but the project ID shoudl be text. After saying this, I did run a test with your suggestion and it does work with number. when it works with number, I added the removed additonal condition in and still work. I went to change the field...

Hi, before I sent my reply, the IE crushed. the actual value is 1 but as I said, it is a text frield and show so in the form and on the coding "1"

I see. Thanks.

Hi pbaldy, The change doesn't make any different, I have the alert notification on which said 0 row of record deleted. The value for the project ID remain unchanged. Hi Mick, Still same error. I have tried other combinations eg making xtemp as long but not try other combinations yet.

Yes, ProjectID is text which is the unique key on TProject ProjectItemID is a autonumber on TprojectItems and ProjectID is another field on the same table but as text which has relationship with TProject BTW, does anyone has the same experience, I have to keep logging on to the forum. Even I...

Hi there, Thanks for suggestion. But it still doesn't work, the same error. I have been trying to delete the record rather then read it but still not getting anywhere. DoCmd.RunSQL "DELETE * FROM TProjectitems WHERE ProjItemID = " & Forms!FProjectItems.ProjectID Since the lookup...

Hi there, Thank you for taking an interest in my post. I know it is not easy but my boss doesn't think so but there is no point to argue. No, I have no idea how long the number will be. As a matter of fact, I have been thinking about achieving it another way but that is not easy either but I...

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 there, I don't want an subform. Also in report, you don't need to create subreport to have the various sections. For example, I have Level1Cat, Level2Cat then after level2cat have many items. In report, I would group at level1Cat then level2cat and also would have summary of items. They...

Hi, You are right, when you click on the control wizard, nothing noticable happened and it is next to the textbox and control so I might have accidentally clicked on it without knowing. I know I have not changed the settings but still looked into options under tools cut just can't find...

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

Hi there, My saver. Yes, you are right. Found it straight away and yes, just like magic wand waved and work. Thanks

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

Hi there, Thank you for replying. I got a user who have all these items grouped in 3 levels, 2 of them are titles and the 3rd one is various items which related to each project. The titles she uses was very long and I simplified them in my original posting. Since the format was used for over...