Search results

ODBC Connection I actually figured it out. but just in case anybody needs to know. I did it by writing to the registry after all an ODBC connection is just some entries in the registry.

I have the following problem: I have a PurchaseRequest table with the following fields PRNumber, RequestorId, BuyerId I have a HR table with the following fields EmployeeID, FName, LName I have a Phone table with the following fields EmployeeID, PhoneNumber Both the RequestorId and the...

Hi, I am creating a MS Access front end database with the forms and reports to a SQL Server back end. To set this up I understand that I have to have an ODBC connection set up. I would like to set up the connection with a installation program or programatically. Does anyone know how I can do...

What are you trying to do? Are you trying to code this from within your database. If so dim db as DAO.Database set db = CurrentDb

using value instead of text property Thanks a lot Pat. Using value works perfect. Sorry but I am new to programming with VBA. It is the first project I have ever gotten to do with VBA and Access. I mainly work with C++/MFC and C#.

Setting focus to previuos control that had focus I am trying to give focus back to a control that had the focus after updating data on other controls in a sub. Since I have to Setfocus to the textbox that I need to update I would like to give the focus back to the control that the user...