Search results for query: *

I have a report that is grouped on a couple different levels. Header 1 - Category Header 2 - Group Detail GL SL Footer 1 - Group Subtotal sum(GL) sum(SL) Footer 2 - Category Subtotal sum(GL) sum(SL) Report Footer - Totals sum(GL) sum(SL) So if the detail GL = 1 and SL = 1 I want the Group...

I need a vertical line that stretched over some headers, detail and the footer of a report. Without having to draw a line in each section, is it possible? Thanks!

Hi, I am using the switchboard as my main menu system. I have a subswitchboard that people will go to run reports. From this menu, I want them to choose the report that they want to view. However, instead of going to the report, its going to go to a form which is going to make them specify...

Hi, I am having issues trying to decide the best way to build a form. I want to build a form that will allow the user to view and update a group of data from a grid-like form. So for example here is what the form will look like: Group: _____ Person: ____v Status______v The info that I want...

Hi - I'm having some difficulty with a form. I want to be able to look at a record in a form, on the form is a bunch of subforms. I want to be able to update the data in one of the subforms by hitting a button, having a new form popup. Now heres where Im having the issue. When the new form...

Hey, and thanks in advanced to any advice that is offered!!! I need to find some kind of whitepaper, or documentation out there that proves that we can add users to our AD so outside clients can access certain portions of our sharepoint portal. Basically certain "decision makers" are concerned...

Thanks in advanced!!! Here's the issue. When I synch with active directory, it imports resource names like this lastname; firstname ideally I would like it to look like this lastname, firstname Ive been told since project uses the comma as a separator, it wont import with a comma. Does...

Hi, I have a computer that I want to put server 2003 on. The computer currently has 2000 pro. I want to do a clean install, however the way the drive is currently partitioned, all the space is being used by the existing partition. Is it ok to format that partition, then install server 2003...

Here's the problem, thanks in advanced... I want have a function that is sending a string to another function. basically I want to take a string, and split it... Here's what it looks like... 11111;22222;33333 of course the length of the string between the semi colon can vary. Also I am not...

Hi! Thanks in advanced! I have created a table that contains Metadata (information about other tables in my db) I did this because I am working on a massive data conversion, and there are many fields in the db that I am working with that have multiple values. Instead of parsing these fields...

I'm setting up a DTS where I'm using a SQL query as my data source. In the query I'm doing a bit of data manipulation for example... Im converting some dates using CONVERT() Im using CAST() for a few of the fields. I want to know if theres a similar method that I can use to strip carriage...

Please Help... Heres what I am trying to do... there is an author field in my database. There can be multiple author names in the field, but the format is always the same... Basically it looks like this: J.T. Smith A.; B.A. Jones B., etc. I need to do 2 things... On one report I want the...

Ok, heres a tricky question (i think) I have data in a table that needs to be printed to a 5 page report...the problem that I encountered was that Accesses limit on height didnt allow me to build all 5 pages in 1 report using page breaks. So for each page I created a new report. This works...

Hi...I have a form with an option group...If the user selects an option a the value is stored in a table. I want to include a button next to each option group that I create to allow the user to clear their selection...basically for data analysis I need to know if no choice was selected...Please...

Hi! I am building a system in which the user can search for a string in specific fields. The user will chosse the field to look in, type in the string and hit search. I am using a query to find the string in the specific field. I am sending the results to a cursor. Now here's the tricky...

I would like to be able to open 4 seperate Access DB's from 1 access DB. Basically I want a form with 4 buttons, depending on which one the user pushed a different access DB would open...any suggestions. Thanks!!! Mike