SQL Server Run-time error "-2147467259 (80004005):0830 (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 question1130 (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 present1219 (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 form2393 (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 source1909 (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_Load1169 (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 textfile3372 (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 issue3113 (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...1101 (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 Googlemaps2126 (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