Search results

Hi everyone, Can someone tell me how to set up a run time application in Access XP. Specifically: is it possible to set up a run time application from a client computer pointing to a database out on a sever over a network? Several computers running run time apps all pointing to one database...

I am having tremendous problems with what should be a simple function with hyperlinks. Here is the situation... I have a projects table that contains project fields such as Projects.Project_ID, Projects.Project_Code, Projects_Address_ID etc... I also have a Server_Location table that contains...

Hi, I have a strange problem. I have a table that contains 500+ hyperlink fields that point to file locations on our server. I've created a form that allows the end user to select a project file and also click on a link that bring him to the file location on our server. This worked fine...

Hi, I was wondering if anybody knows if it is possible to enable a double click rather than a single click to activate a hyperlink data type when you define the data types in a table. Cheers,

Hi, I have a question that I believe should be a common problem. I have a very simple form that creates a very simple report. The form contains a combo box that allows the user to select from a list of Clients. Upon clicking a button, a report will be generated that lists all the projects...

Hi, I have a simple question I think. Is it possible to have one MS Access database stored on the server and allow multiple MS Access front ends on different computers accessing that data? How does one go about doing this so that multiple people can access the same database on different...

Hi, I'm wondering if there is someone out there who can help me with this: I have a [Projects] table in my main form that contains project information (i.e. project number, work description, project manager etc). In the main form, I have a subform called [Client] (contains client contact info)...

this should be a simple problem. I have a form that contains the following fields: Year FileNumber ProposalPhase JobPhase There are approximately 2000 project entries in my dbase. What I want to do is sort these project entries by FileNumber first, then by ProposalPhase, then by JobPhase...

Hi, I have a relatively simple question. I have a field called "proposal phase" in my projects table. Sometimes the field contains numbers that indicate the particular phase of the proposal and other times there is a blank to indicate that no proposal was written for the project. How do I...

I have a relatively simple question. I have created a report with several fields, one of which is a Project Manager field. What I want to be able to do is this: If there is no Project Manager assigned to a project, instead of having a blank field if no project manager is assigned, how do i do...

I have a problem. I want to create a relatively simple form to generate a relatively simple report. The form I want to create contains a dropdown menu (combo box) that lists all our clients. What I want to do is allow the user to select a client from this combo box and then click on a preview...

Hi, I have what seems to be a simple problem but I can't seem to solve it. I have a form (report form) that has a drop down box that lists all my clients alphabetically. The form's record source is from a query that combines multiple fields from several related tables. The purpose of this...

Hi, I have a report that generates a list of project numbers along with a project description. I want to have each project numbered in the report. For example: 1. file 000456 - Bakery shop financials 2. file 000123 - Grocery store financials 3. file 000598 - Department store auditing 4...

Hi, I have a form that contains a dropdown box that list 8 project managers. The form also contains fields where you can enter a date range. The idea is to select a project manager and date range and have the form generate a report of all activity for that project manager with the date range...

Hello, I have been stuck on this problem for days now. I have a PROJECT form which contains a subform that contains information on the Project Contacts and the Project Manager. I have about 1000 projects and 10 project managers. What I want to be able to do is to select the project manager...

I have a problem adding fields to a table using a combo box. I have a bunch of project files that each need to be assigned a project manager. There are only 10 possible project managers. I want to enable it so that I have a combo box where I can select a project manager for each project...