Recent content by wezhogan

No it is definately the file path. I get an error saying that it cannot find the file New.mdb because it stops at the first space which is between "New Beginnings".

Hi again. I have another problem that I hope someone can help me with. I am using the shell function to open database B from a form in database A. The reason I am using the shell function is because the databases I put together will be used in Acccess Runtime instead of regular Access so the...

Any idea where I can find the code I would need to open database B from the form in database A without using the createobject function? I don't need to open database B to a specific record, just have to open it to a specific form. I can set up database B to just automatically open that form in...

Well I spoke too soon. Everything is working in my .accdb file of the database. I am now getting a runtime error when trying to run the .accdr file on another computer that just has Access Runtime loaded on it. Any ideas on this?

Thank-you so much. That fixed my problem completely.

I am having a problem openning a form in database B from a form in database A. I know the issue has to do with database A being open when openning database B. There is a table in database B that is linked to database A. Is there anyway to relinquish control in database A when trying to open...

I found this thread as a result of looking for information on how to open a form in database B using a button on a form in database A. It worked for a little while but now I am getting errors or database B opens and then closes right away. Here is the code for the form in database A...

I have searched and searched using various key words but cannot find the answer to my question. I have three tables: tblClient (for basic client information), tblDischarge (for client discharge information), and tblAppointments (for appointments that are added to an outlook calender). All...

Sorry, I answered my own question. Once I changed the Outlook username to the same as the Windows username it worked perfectly. Maybe this info will help someone else. Louise

This is such great information, thanks so much. I am having a problem though. I am running Access 2010 and Outlook 2010. When I create the appointment and click the Add To Outlook button it says that it has been added but when I open outlook it is not there. Not sure where to start with the...

Hello to everyone here. I was so excited to find this site a couple of weeks ago. I used to work with Access many years ago and did some minor VBA programming with it. I have just begun helping out a nonprofit organization to get their data into an electronic format and bring them up to the...

This is the sequence of how it is suposed to work: Navigation Form (User clicks a button to Open the Client Selection Form) --> Client Name Selection Form (User selects a client name from a combo box then clicks a button to open the Client Detail Form) --> Client Detail form opens in edit...

The combo box is poulated by Expr1 in this query: SELECT Contacts.IDNumber, Contacts.[First Name] & " " & Contacts.[Middle Name] & " " & Contacts.[Last Name] AS Expr1 FROM Contacts;

I have a form based on a query. The query populates a combo box and when a name is selected from the combo box it updates the value in a text box on the form with the ID number of the record selected. The value in the combo box is created from this expression: Expr1: [Contacts]![First Name] &...

That did it. I appreciate the help, especially so quickly. This is what I did for anyone searching for this answer: Private Sub bnNext_Click() DoCmd.OpenForm "frmPrescreening", acNormal, , , acFormAdd, acWindowNormal [Forms]![frmPreScreening]![IDNumber] =...