drtitus7759
Last Activity: Jan 10 '08, 07:33 PM
Joined: Nov 7 '07
Location:
-
That makes sense... but what about retrieval. Will I be able to retrieve both columns once the user selects a row?... -
Tabs in a Listbox?
Using MS Access 2003 I am currently populating a listbox via a query where I concatenate 2 string fields seperated by a "-". The fields are a description along with the key so when the user makes a selection I can then retrieve the appropriate values.
The values are running together and difficult to read. Is there a way I can incorporate Tabs in the Query so that additional VBA code won't be needed on the form? -
I understand the footings, but is there anyway I can get the overall total to print at the employee level?...Leave a comment:
-
Reporting: Showing Number completed and % against Org Total
I need a report which will show how many tasks have been completed for each employee and a percent of that based on the total tasks possible.
Example:
Tasks Total Pct
compl tasks Completed
Joe 5 20 25%
Mark 10 20 50%
Steve 5 20 25%
I'm drawing a blank on how to get the 20 for each person. -
I don't have any menu items or toolbars available since I didn't want them to do much of anything. Can I select a custom toolbar for the Print Preview window?...Leave a comment:
-
Setting Window Size for Form and Print Previews
I am using MS-Access 2003. I have a restricted applications for multiple users where when they start it up, it enters a series of menus and screens and does not let them at the various Access menus, buttons, or options.
I would like to set the Access window size to a specific size and maximize the form within the Access window.
Also, I perform a print preview on all reports and have the users hit Ctrl-P to actually... -
Changing Database Setup Mid-Stream
I am using MS-Access 2003 with a split database on our server. I have the front-end in one folder and the back-end in another. I have the users using a shortcut to the front-end. Of course this restricts what I can do as far as development during the day while the users are online.
Can I implement the scenario where I put the forms/rpts/queries/etc on each user's local drive and point to the backend at this point? How would I accomplish... -
Query with outer join?
I'm having difficulty in generating a query the way we need it. I have a the following tables:
Segment Master:
Project
FIPS
Segment
Production:
Project
Yr
FIPS
Segment
Segment master contains all valid segments while Production records are generated over time over the year. I would like to get a % complete for the year based on FIPS but if a FIPS has not... -
Preview/Printing Reports
I have an access database with an extensive amount of VBA. I am creating reports based on queries and parameter forms. In the production database everything is modal and accessed via forms. No access is given to the ms-access screens. I control all access via forms with buttons, etc. When running a report I would like to display a preview, then print if the user wishes. I do not give the user any menu bars or toolbars. How can I accomplish. Currently... -
Sharing data between forms
I have an appl where I have a main form and several other forms (detail) where information is collected. All controls are unbound and I control all db updating via vba code. I would like to set values in the controls on the various detail forms from the main form. Also, once done I need to retrieve lots of control values from the detail forms from the main form in order to perform all the I/O. There is too much data to pass between them. Also quite...
No activity results to display
Leave a comment: