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...

didn't work Hi, Thanks for the suggestion but that doesn't work either. It doesn't produce an error message but it doesn't work either. I've been spending hours on MSN and ICQ with others trying to figure this out and it's puzzled us. Got any other suggestions?

doesn't work though Hi, The code below to open a link from a text box doesn't work Dim website website = Text1 x = Shell("explorer.exe website", vbMaximizedFocus) Can you tell me how to do this? I'm actually trying to open a link from a combo box. The combo box contains a list of...

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...

actually... Actually wait! My problem is that hyperlinks are not working in my form. It doesn't prompt the opening of the browser window when i click it, even though when i mouse over the hyperlink, it shows a finger icon (suggesting it's a link). splitting the dbase had nothing to do with...

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...

yes but.... I have a list of hyperlinks in my table. About 500 of them. Each one pointing to a file location in our server. The solution you provided does not work in my situation. Do you have any other suggestions? thanks

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,

yes but... thanks for the reply. It makes a lot of sense but i don't know how to separate my current db into front end back end. Currently my DB has many objects (Tables, Queries, Forms etc...) how do i chop it up so that only data is on the back end and the forms and switchboard are on...

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...

another question thanks for your reply. My Projects table already contains a Client_ID field. Are you suggesting that I insert a combo box in the main form [Projects] with data from the Client_ID field? How do I do it so that when I select from this combo box in the main form [Projects]...

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)...

Awesome! Works like a charm! Thanks for all your help!!

works great! Thanks for you help and speedy reply. I have one more question though. The code you sent me changes the ProposalPhase to be N/A if there is a null value present. Is there a way to create one update query that changes both the ProposalPhase and the JobPhase to N/A if there is a...

where do i input this Thanks for your help, where should i be typing this code in? the text box control source? i tried this one and it didn't work. Can you tell me where i should be typing this code into? thanks

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...

sounds like a good idea thanks. I think your suggestion will work. how would I write the Update query? thanks for you help!

it didn't work what i entered into the text box source control was the following: =Nz([Concatinate_Names.NAME],"Not Assigned") However, the report still displays a blank for the project manager if no project manager was entered. any other suggestions?

thanks but... currently the project manager text field contains the following: Concatinate_Names.NAME what it is doing is combining the first and last name of the project manager. If I input your suggestion won't this mess things up?