Search results for query: *

I created a query def that uses an existing query but selects records based on data selected in a multi-select box. The logic works fine. However, I just realized that the field being used as the selection criteria should not appear in the output so "select *" can't be used. strSQL = "select...

I have tried many different ways to connect to a SQL Server db but can't get any to work. I am logging in through VPN and then remote desktop onto a machine and am working directly on the machine (there's no external IP address). It's SQL Server 2005 and Windows Server 2003. Each way I tried...

I created an Access db (2003) that contains contact info with a lot of custom logic. My client wants to be able to use Outlook to "see" these contacts and create distribution lists from the data in the Access tables and queries. I have done automation the other way; that is, having Access...

My php page has 3 dynamic drop-downs reading data from a MySQL db with select statements like this <select name="VehicleYear1" onchange="this.form.submit()">;. The drop-downs are all working fine, however, the first time the drop-down submits to the same page, I lose the $numcars value that I...

I started this thread in the Office forum since it had to do with Excel but I was told that it should be posted in this VBA forum. I wrote code to hide sheets in a workbook using xlVeryHidden until a password is entered, when I unhide certain sheets. Dim Ans As String ActiveWorkbook.Unprotect...

I wrote code to hide sheets in a workbook using xlVeryHidden until a password is entered, when I unhide certain sheets. Dim Ans As String ActiveWorkbook.Unprotect ("12345") Ans = InputBox("Please input your password") If Ans = "12345" Then Sheets("Title Sheet").Visible = True...

I am working on a basic page to display data entered in a text area. If the user enters the text below, is there a way for my php page to use the html formatting entered? <H2>Here's my heading</H2><br>More text here<br><b>I am done now.</b> This would give the user some control over...

I used VBA in Excel to calculate an expiration date for a spreadsheet, using OnTime. I only need to run the OnTime logic once and then I cancel it right away using Schedule=:false. That all works fine and I get the value I want. The problem is that every time I open the spreadsheet, the value...

Hi. I have a basic HTML page with many text boxes and drop-downs set up in a table (no form tags). The last drop-down has two choices. Based on that choice, the user is redirected to the next page. I created a Javascript function to handle the redirection and call it from the select tag, and...

Hi! I wrote a page to have 3 drop-downs based on car year, make and model data in a MySQL database. The 3 drop-downs are dependent on one another. The problem is with the second drop-down selection. The logic works fine if the selected value is a single word but doesn't work if there is a space...

I am an Access programmer who is very proficient in VBA. I am trying to help someone out with a VB application they have and I am very confused. I hope someone can just point me in the right direction. I have reviewed many forums here at Tek-tips and on the internet and there is so much...

Hi! I have created a subreport that shows the heading only on change of a type field. This subreport works fine when I run it on its own. However, when it runs as part of the main report, I am losing the last record in the subreport. When I put test messages in the logic that does the...

I've searched the forums here and looked on Microsoft's site. I have a mail merge document in Word 2003 for which the data source is a query in a secure Access 2003 db. The security is handled using an .mdw file. When I do the merge and select "Use existing list" and try to use the secure...

Hi. I am creating a column heading in a crosstab query as follows: ColHead: [Question] I can see the resulting column heading but not the entire string. For example, if [Question] is "Do you have any upcoming initiatives in store for the end of 2005, early 2006?", I only see "Do you have any...

I wrote pages in ASP/VBScript (no JS). It was working fine in IE but some of the pages had issues in Firefox. I've resolved most of the issues but can't seem to get this one. I've pasted my code below. The doc list displays but there's no hyperlink in Firefox. I reviewed posts in this and...

I created a Word form with formfields from which data is loaded into Access through VB. The load works fine except that the text form fields are loading one garbage char (ASC13) at the end of non-null text loaded or full of garbage if text is blank from Word. I have written VB code in Access...

The following logic works in Access 2003/Outlook 2003 PC but doesn't work in Access 2000/Outlook 2002. This is the same database on two different machines. The email is sent in both cases but the message part of the email is blank in Access 200/Outlook 2002. In Access 2003 I use the Outlook...

I have an IP address, login and password to view an Access db on another system. I have read many posts in this forum but I just can't get this work. I set up an ODBC connection but get the error "You cannot use ODBC to import from, export to, or link an external Microsoft Jet or ISAM database...

Please see the thread below for details, originally posted in the Access VBA coding forum but with no response. thread705-951390 I created a Word form with multiple tables that I want to load into Access. The cells of the tables are all formfields. I have no problem reading the data from text...

I wrote a VB program to load data from a Word file with many tables into Access. The Word tables are all form fields, some of which are drop-downs with several choices. The load is working except for one problem. I created buttons on the protected form to allow users to add or delete rows as...