Search results

Issue Resolved Got It. thanks

Hello, I am in need of your help creating a pie chart on my report. I have this small database that analyzes survey results. I have the report ready the way I wanted except the chart. I never worked on the chart before and my first attempt failed. In my attached database there is report called...

still need help Thanks Brian1960 for the help. That is actually what i need, but i am still having difficulty getting this going. Basically, I am trying to print survey (as a report) for each course. Course numbers are unique and course enrollment will let me know how may surveys i have to...

Hello need some advise. I have following on the table: ID Name CopiesPrint 1 Jim 10 23 Sam 2 56 John 3 Report Source Query: select id, name, copiesPrint from table1 I would like to print 10 copes of id 1 Jim and 2 copies of id 23 Sam and so on. I tried...

I am in same suitation - need advice I am working on a SP to send result of a query via email. If i could save the result of query (@MSG3), then i could attached that as @message message body. Is there better way to do this? sa CREATE procedure olc_id as Declare @MSG varchar(255)...

I need a help/pointer converting this cascading list boxes into treeview control. Please help. All the data I need to construct a treeview is already at category_info table, but unable to show it attrib_cde (parent), Stage (child of parent), and ID (child of Stage). Any help or a quick example...

quick example

Try this - read the post carefully. It talks about username and password - http://www.access-programmers.co.uk/forums/showthread.php?t=50449&highlight=fCreate_DSN

Search the forum for POPUP MENU - i am sure you will find answer to your question. Hint: Create a custom toolbar and add command to open report. In the properties of the new tool bar set the type to popup. sa

I could not figure out this myself, please help. I have a monthview ActiveX with monthrows setup as 3 so it will display three months in row. However instead of showing lets say current month at the bottom of the row list, i would like it to show the current month in the middle. If the month is...

check this multiselect listbox exmple. It will point you to right direction. http://www.access-programmers.co.uk/forums/showthread.php?t=72319

Thank you SIR!!. I think i tried that. Let me give it a go again. sa

Help Anyone??

I added bound text value to quickly check the function. I will remove it once i get the function working. Do not worry about "6666". As you can see actual usage of the form would be: If CurrentUser = "Viewer" Then 'access denied message else 'open form with form name parameter end if thanks...

Have a look at this. You need user name and password to be able to download the attachment. http://www.utteraccess.com/forums/showflat.php?Cat=&Board=48&Number=664015&page=0&view=collapsed&sb=5&o=&fpart=1

Try On Change event instead.

I have that happened in the past. I have a feeling you may have some memo fields or textboxes with lots of characters setup as indexed field(s). It might be these two fields [categoryDescription] and [parentcatdesc]. If so change the index properties of these field(s) to no and give the query a...

Thanks for the reply FOFA, i thought about that but it does not work for me because i need to open form after the security check in ELSE part. And i want to use the function multiple times for multiple forms, do not want to create a function for the each form. Any thought? sa

It is very hard to tell what is going on without looking at your database. But for the start i will ask you to check two things under tools/options - record locking and database mode.

It did not work as i mention in my orginal posting. I tried: Check_Permission Forms!form1 or Check_Permission (Forms!form1) or Check_Permission (Forms![form1]) ' Just in case of if you have the spaces in form name CurrentUser is a builtin function to get currently logged on user name. Viewer...