hello, I am wondering if it is possible to get a specific user group from my Ms Access database.In my application the user menu depends on the user group.So I need to assign a specific menu for each group of users. My connection string contains a UserId and Password attribute. What I'm left with is how to get to know the user group once the connection is established. I know of a method "Is_Member()" in sql Server but unfortunatelly it is not recognized by Access db.I need to implement a method for doing that and I couldn't get access to sysusers or sysfilegroups tables like in Sql. I'm new to MS Access so if any body can give me a hint.By the way I'm using C# ,MS Access, OleDb. Thank you

Hi, Does anybody knows the MS Access equivalent for IS_Member(Role) in SQl. The Is_Member() specifies wether the db user belongs to the group Role or not. if anyBody knows how to do this with MS Access please help.Any other suggestion is welcome Thanks all

hello every body, I usually work with sql server so if anybody may help with MS Access I'd be thankful. here 's my C# potion of code: string selectId = "select categoryId from Category where categoryName = @catName"; myCommand = new OdbcCommand(selectId,myConn); myCommand.Parameters.Add("@catName",categoryName.ToString()); myCommand.prepare(); myReader = myCommand.ExecuteReader(); at this level an exeption is thrown at the level of the odbc driver it says not enough parameters or something. 1 parameter missing. In my string i'm having only one parameter and it's @catName. in the definition of the Add()function it says that the second parameter is the value of the named parameter. The function that contains this code receives the value of categoryName however it's not set! can anybody help pls

hello every body, I usually work with sql server so if anybody may help with MS Access I'd be thankful. here 's my C# potion of code: string selectId = "select categoryId from Category where categoryName = @catName"; myCommand = new OdbcCommand(selectId,myConn); myCommand.Parameters.Add("@catName",categoryName.ToString()); myCommand.prepare(); myReader = myCommand.ExecuteReader(); at this level an exeption is thrown at the level of the odbc driver it says not enough parameters or something. 1 parameter missing. In my string i'm having only one parameter and it's @catName. in the definition of the Add()function it says that the second parameter is the value of the named parameter. The function that contains this code receives the value of categoryName however it's not set! can anybody help pls

hi, A problem raised when I changed my Connection string by removing the Integrated Security = SSPI in order to allow multiple users to access the database. The problem is that the connection does not open at all!with any user and I got the following error : System.data.sqlConnetionException and System error nothing else. I'm working on the server machine. and myConnectio string looks like the following Workstation Id = TOTO;DATA SOURCE=TOTO;Initial Catalog= files;MAx Pool Size = 200; user Id = toto;password = foo" Can anybody help please

Hi, my problem comes from the fact that I'm trying to make my progressbar progress while I'm scanning directory files.the awk thing is that my scan function is defined within my datalayer as a dll.I want my progress bar to follow the files processing. I first thought about threads but could'nt move on.probably got allergy for threads.can anybody help? thanks in advance

thanks for your answer, I checked the project output it's set to class library. I think the problem comes from the fact that when trying to register the dll using regsvr32 it does not find DLLRegisterServer entry point. the msg I got is mydll.dll was correctly loaded But the DLLRegisterServer entry point was not found. Unable to register within windows. (I got the msg in french , I think this is the eng version.) I didn't know that I'll need to have the .net framework installed on my clients

hi, and sorry again. I followed the steps that are in the link and got some problems I couldn"t deal with. The first is that my DLL couldn't be registered within Windows. It says "No DLLRegisterServer Access point found"? I don't know what it means. The other problem is that within my project the "register for Com Interop is set to false but does not allow changes to true. What I did is I created a new projet containing only the class needed to the translation an builded a new DLL named CRUFLctw.dll. Bt I 'm having the problem of Access point ??So the function still does not appear within formla staff in crystal report... Please, I m really blocked and need your help Thanks in advance -- modified at 14:01 Wednesday 7th December, 2005

hi everybody, I have a small question concerning the use of ToWords() method that is embeded within Crystal Report.This function translates numeric values into their coresponding words value ex:150 --> One handred and fifty. The problem I got is that I got an automatic english conversion of my numeric values where I need french corresponing string value. Is there any way I can swish it to french? Or how can I add my function, that does the french translation, to the crystal report embeded functions? If anyone can help pls do.

hi everybody, I have a small question concerning the use of ToWords() method that is embeded within Crystal Report.This function translates numeric values into their coresponding words value ex:150 --> One handred and fifty. The problem I got is that I got an automatic english conversion of my numeric values where I need french corresponing string value. Is there any way I can swish it to french? Or how can I add my function, that does the french translation, to the crystal report embeded functions? If anyone can help pls do. Learning is never ending

hi everybody, I have a small proplem with my stored procedure that looks like this create procedure MonthlyBill @startDate datetime, @endDate datetime as select * from Bills where Bills.date >=@startDate and Bills.date<@endDate the problem I have is that when I execute this query using the following command: execute MonthlyBill '01/10/2005','30/10/2005' I get the following error msg: Error converting data type varchar to datetime. both @endDate and @startDate are declared as datetime variables.From where does come the problem?I anybody knows and would like to help please do!!!I'm thankfull The will to learn

Hi there, following my last question where I inserted data coming from different tables, I displayed these data using crystal report. Up to here everything is fine. The data displayed is grouped by Appartment Code Id field.In my report, data look like this: Appartement Code : 1737/R1 inhaitant Name: Mike Jones |month |Amount due |07-2005 |100 |08-2005 |100 total Due:200 Appartement Code : 1737/R2 Inhabitant Name: Emilie carter |month |Amount due |06-2005 |100 |07-2005 |100 total Due:200 As these are grouped by Appartement Id each time I click on the appartment Id A new page with only the group information is displayed on a separate page. What I want to know is how can I custom this page so that It can e used as a letter to my client? example of what I need: Once I click on 1737/R2 I want to get in a new page: Dear Mr/miss Emilie Carter, I'm glad to announce you that you owe me a total of 200$ for the rent of your appartement for the unpaid periods of 06-07 2005. compliments Something like that! If you can help please do! anyOne who shows you something you ignore gave you a real tresure!he's your master.To thank him,transmit what you learned

thank you very much

hello everybody, I have an sql statement that I want to automatially run at the beguining of each month from server side. I'm using sql server 2000 and didn't find anything about dbmsjobs in sql! Can anybody help me with that please -- modified at 15:23 Tuesday 27th September, 2005

thank u Mr Mackay, my tables look like this inhabitant ---------- inhabitantId ... info about inhabitant Appartment ---------- AppartementId inhabitantId Amount //the amount that the inhabitant shoul pay monthly Payement --------- inhabitantId AmountPayed //the amount payed is what's paid each month if done date //date the the paid amount PostponedPayement ----------------- InhabitantId amountdue Referencedate //the reference of the unpaid month I need to get the inhabitants that didn't pay for each month and store these in my PostponedPayement table. for example Appartement Inhabitant Payement --------------------| ----------------| ---------------------------- ApptId inhId Amount| InhID | InhaName| inhId |paidAmount|Date --------------------| ------|---------| -------|----------|--------- 177/R1 inh1 150 | inh1 | James | inh1 | 150 |01/08/2005 177/R2 inh2 180 | inh2 | Jone | inh4 | 100 |05/08/2005 177/R3 inh3 150 | inh3 | Greg | 177/R4 inh4 100 | inh4 | mike | in my PostponedPayment table I need to get this for august payments plus what is left from other months PostponedPayement ------------------------------ InhabitantId|AmountDue|Refdate| ------------|---------|-------| inh2 | 180 |08/2005| inh3 | 150 |08/2005| inh1 | 150 |06/2005| I did the following query to get all those who paid and those who didn't : select Appartement.ApptId, date, Payement.Amount from Appartement left join Payement on Payement.ApptId=Appartement.ApptId I get the following --------------------------------- InhabitantId|Amount | date | ------------|---------|----------| inh1 | 150 |01/08/2005| inh4 | 150 |05/08/2005| inh2 | Null | null | inh3 | Null | null | all I need to pik up are the 2 last values in the example and insert them into PostponedPayment Hope it's clearer now!excuse my English But I thank yu very much Thanks to all those who help and those who try to help

hi, I know this may look easy for some,but I need help with it. I have three tables "inhabitants","Payement" and "postponedPayement". I need to select from inhabitants those that didn't pay their loan and store their Ids along with the unpayed period into table "postponedPayement". The table "inhabitant" gathers all the inhabitants of a bulding while "Payement" table gathers all the payement made by an speific inhabitant for a specific month. I wonder if someone know how I can do it automaticaly by the end of each month using SQL. thanks in advance It's not shame to ask if we don't know but it's shame to pretend you know when u don't -- modified at 11:53 Thursday 22nd September, 2005

hi, I'm new to crystal report staff and I need some help!I have to print a receipt using crystal report.The receipt should be filled from a database table.I tried with an orinary table without parameters and it works. The problem is that my receipts are customizable so that each client could get his own receipt that 's why I need parameters, So instead of assigning a table from a database, I tried the addCommand and wrote down my sql statement that looks like this:"select * from bill whrere customerId='"+param1+"' and date ='"+param2+"' these parameters were filled in a windows form"biling" previously in textBoxes.Now the qestion is how can I pass both param1 and param2 from "billing textBoxes" to my query? So that I can get the required data in my bill. I'm using C# in VS.net. If anyone can help I would appreciate! Thanks a lot