Recent content by dfuas

No problems. I am just happy to know that you've tried to help. df

Hi, How do I format data in my report to display with a dollar sign? I am using the following format $#,##0.00;($#,##0.00), but somehow I get a Format$ paramater to enter value. Thanks df

Hi Happy new year everyone, I have designed a Access 2000 report which is getting data from a query. However when I run the report is asking to enter a parameter value which is Format$. Running simple the query is all fine but when running the report asks for this parameter and it seems that...

Hi, I am cloning records in Access 2000 and once a record is cloned, I want to give a record number such as if I clone record with autonumber = 23 the cloned record will be = 23-a and if I clone 32-a will be given id of 23-b. This should be for any record within the database. Right now when I...

Hi, On login I want to give certain rights to my users, i.e. unable or disable certain commands, etc. I have a sql server db table with users and they are allocated departments as Temp, Admin, etc. According to which department a user belongs, on login would have access to certain commands...

Hi, How do I populate results on a datagrid based on the user I select from a combo box. I have a combo box with X number of users and want to show the results for a user A only. I am filtering the results for each user based on option buttoms whether the job is finished, live, or all. Right...

Thanks all for your help. Thanks to your input I managed to find the solution. Regards, dfuas

Hello everyone, I have a combo box filled with info. from a sql server table. And I want to fill a text box with some information depending of the selection I make from the combo box. Can anyone help please? I have a table with 3 fields, id, priority, and description, and a combo box filled on...

Thank you. I will try this.

I am trying to achieve the following: If ([Trade].[Vintage_ to] field is empty then look at the ([Trade].[Vintage_from9]) value and return this value or if this is also empty return the next which is ([Trade].[Vintage_from8]). ie. return the 1st no empty value between ([Trade].[Vintage_from9])...

Hi, Can anyone see anything wrong with this query? I have 10 combo boxes where years are selected. If the last year nothing is selected (meaning is empty) then my query should return the last selected value. It seems the IIF query does not seem to work (Still showing empty). Can you please...

Hi everyone, I have a problem trying to run a Access 2003 WinFax application. These application was originally designed in Access 97 and I am trying to updated to Access 2003, but when I run it I get errors such as: error: -2147352573Unable to run specified macro and error:4198Command failed...

Hi I just wrote my first macro in Excel, but the problem is not saving any changes I make when I click the close button on the right top corner. Can anyone help, please? Sub Auto_Close() Dim OrigName As String OrigName = ActiveWorkbook.FullName ActiveWorkbook.Save End sub thanks dfuas

Hi, Does anyone know how to protect a Excel Workbook file from being modified? Allowing read but not write by enyone apart from the creater (without requiring password) and also to be saved always in the same directory with the original file name on the network. I have never written a macro in...

Thanks, done it. dfuas