Search results for query: *

Has anyone found a limitation to the number of levels allowed using the group and outline facility in Excel 2003. I have got to level 8 and cannot create any more levels, but do not get any error messages. Thanks Sue

I am a complete novice in SQL (2000) and wonder if someone could offer some guidance. I would like to create a view or procedure, or something else, not sure what is best that would find out the status for each item at a particular point in the year ie: during week 24, how many items were...

Dear All, I would like to be able to count an item to see how many were open items within a particular week. So, I have a start date and a finish date for each item, and I want to count the items for each week that falls between these two dates. I have the following (which I copied from the...

Hi Everyone, I want to display the week number, which is no problem, I can get the week number using the datepart formula. But this returns a number with decimals ie: 34.00 Is there a way to make this formula just the whole number? I've tried various functions, fix, truncate, round with no...

Hi Everyone, I hope someone can help. I have a small report, that I use to export data. On the report I have had to put a subreport to bring back one field. I had already tried to do it in the report, but it takes too long to run. So, the subreport gets some data, then I bring that data...

Hi Everyone, I have a form with a continuous subform on it. I want the user to select the data in the subform based on the data shown on the main form - they have to do this, as it is a manual matching facility. At the minute, on the subform I have disabled the scrollbars, so they have to use...

Hi All, I have a column in a view that I would like to do a DBLookup to another view in the same database, based on another field in the view In the help files, it says : 'This function does not work in column or selection formulas, or in mail agents.' I am a bit of a novice at development...

Dear All, I currently have various excel files, in a set file structure. All of these files currently have links to each other and also a link to a summary document. We need to copy the whole file structure, and rename the files. Currently I would then need to go into each workbook and...

Hi Everyone, Does anyone know a way I can set file permissions using code in Access. I've had a look at the 'SetAttr' function, but this just seems to set the file attributes. What I would really like to do is set the security permissions. So the person logged on would have change control...

Hello everyone, I currently have a runtime database that opens exclusively with the /excl command on the shortcut. Unfortunately if the database is already open, and someone else tries to open it, it gives the following message : 'You can't open 'c:\data\thedatabase.mde' for exclusive...

Hi Everyone, I have a small database that I link to various tables. The number of tables can vary, based on what the user asked for, so for example the user could ask for tables 1 to 10, which I then link to and show them the results. The next time they could ask for tables 2 to 25, so I...

I would like to be able to show the number of unread marks alongside a Hotspot for a specific database So far I have been able to get the number of unread marks and display it in a message box. The thing I'm having a problem with is displaying this value in a text box on the navigator. I...

Hi Everyone, I have a continuous subform, which has 4 combo boxes across the record. I currently have the combo boxes querying depending on the previous combo box, and have put the code in the oncurrent, so it does it for each record. My problem is that I need to display all the records as a...

Hi All, I have succeeded in getting Access to send an email to a user on Lotus Notes, but what I would really like to do is send a different form. The form is basically a copy of the memo with some standard information on it, that the user cannot edit. I've tried setting the name, using ...

Is there any way I could send a button to all our notes users, so that when they click on the button, it would edit a field within the Public Address Book only for the individual who has clicked the button? Thanks in advance