SQL Server Run-time error "-2147467259 (80004005): 0 830 (4/26/2007 5:16:20 PM)
I am connecting from an Access front end to a SQL Server 2005 Express database on a remote PC. I have enabled TCP/IP on the server and turned off firewalls on both boxes. The first recrodset opens and reads th...
Dave

Check box question 1 130 (4/24/2007 4:20:54 PM)
I have a form with a check box used to indicate if a receipt is voided or not. What I'm trying to do is go to a new record after the checkbox is marked. I have the following code in place and it works. Kin...
tlamm

Shifting fields up in the form if data is not present 1 219 (4/26/2007 2:13:41 PM)
I have a form I've constructed in Access 2003 to display data that comes in via a web form. One of the areas of the form asks for information on all the individuals who were involved in a particular incident...
Brian

Open a particular Tab from the on_open of form 2 393 (4/26/2007 2:27:24 PM)
Hi, I have a form with a tab control with lots of tabs. In the on_load of the form, based on where the user came from, I want to be able to tell which tab is "open" when the form is drawn. Any idea? Thanks, St...
steveinbeloit

Parameter query for a combo box row source 1 909 (4/26/2007 2:34:18 PM)
A query for a combo box on a form uses a value from a text box on the same form. Can I refer to the text box without specifying the form name? e.g. Currently I am using "Forms!Form1!Text1" - would like to use...
JimP

How to Tell a tab control which tab to have open from the ON_Load 1 169 (4/26/2007 2:24:06 PM)
Hi, I have a form with a tab control with lots of tabs. In the on_load of the form, based on where the user came from, I want to be able to tell which tab is "open" when the form is drawn. Any idea? Thanks, ...
Utf

Problem importing data form textfile 3 372 (4/26/2007 7:54:41 AM)
Hi, We are migrating our database from Access 97 to Access 2003. In our 97 version this line worked fine: DoCmd.TransferText acImportFixed, "HDMARTPC", "tbl3031_HDMARTPCDAT", "C:\HdbDatabase2003\hdmartpc.dat"...
a

Subform issue 3 113 (4/25/2007 1:50:03 PM)
I have tblRemodelInfo that holds info about all the remodel projects that we've done in our stores. On tabbed FrmStoreInformation it displays static information about the store (address, sqft, etc) and uses ...
Utf

help on combo box... 1 101 (4/26/2007 10:50:46 AM)
i have a combo box cbPayee... on top of the list is "add new payee..." below which are the other names ...how can i enable it that when the 1st row is selected, a pop-up form wud appear for data entry... thank...
ai_enjoi

How can I parse or Loop a list based on single field to Googlemaps 2 126 (4/24/2007 9:24:02 PM)
This is some code that will parse each sequential field [Point_#) into a list for googlemaps. [Form_Runs].WebRouteMap.navigate "http://maps.google.co.uk/maps?f=q&hl=en&q=" & "from: " & Me.Point_1 & (" to: ...
Utf