Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Ms Access Not Showing Fields on Form
- I have a form that is used to update lookup tables of a format ID, Lookup Value, Valid From, Valid To. I open the form based on hte user selecting the list to amend from a combo box. The code is as follows: Dim db As Database...
- Tags: frmLookUpTablesAdministration, Microsoft Access, Microsoft Corp., ms access, munrrob, Name, Name Debug.Print tdfTable.Fields, programming, vba
- Discussion threads 2006-10-26
- MS Access Combo Box Problem
- I have a form using a query looking at 3 tables to populate it. In some of the tables I have fields that are populated from combo boxes with their own recordsources (sql of look up tables containing the code to store and a description. I display the description and...
- Tags: combo box, munrrob, programming, Microsoft Corp., Microsoft Access
- Q&A 2006-08-11
- SQL Server Dates Pre 1900
- I am using DTS to transfer data from a Progress database to SQL Server 2000. Unfortunately, due to poor data collection, there are dates prior to 01/01/1900 in the progress database that cause the process to fail (I believe due to the fact that SQL does not support dates prior...
- Tags: dateTime, Microsoft SQL Server, munrrob, programming, server
- Q&A 2006-01-30
- Access- Show Leading Zero
- How do I get an Access table to store and display a leading zero in a number field?I don't think you can store a numerical value with a leading zero, but when you retrieve the value via a query you can build an expression such asExpr1: IIf([Your Table]![Your Field]
- Tags: Access Table, Field, Microsoft Access, munrrob, programming, Table, Zero
- Q&A 2005-08-01
- Error 3075 due to apostrophe
- I am using Access VBA to create a recordset. The code works fine until I try to read in a field containing the name O' Donnell. I get the above error due to the apostrophe. My code to open the recordset is: strStaff = "SELECT * FROM...
- Tags: rsMailingList!Last, Chr
- Q&A 2005-05-26
- Open external document using VBA
- I have an MS Access database that allows users to link to a document and store the path in a table. I now want to allow the to open the document by pressing a button on the form. I have got the open file dialogue box being displayed but need...
- Tags: munrrob, programming, VBA
- Q&A 2005-05-26
- Invalid procedure call or argument: left
- I am using an ASP page running on IIS6 using VBScript as the programming language. I am trying to display the first part of body text from a freetext field as part of a news headline section on the home page. The code I have is: if not isnull(objRSNews("tblNewsTitle")) or objRSNews("tblNewsTitle")""...
- Tags: munrrob, nBody, objRSNews, programming, response.Write, tblNewsBody, tblNewsTitle
- Q&A 2005-02-02
- Interrogate user login name
- This is probably bread and butter but I need to know how I can capture the log in name for a user on a Windows 2K domain using a VBScript asp page running on an IIS intranet server. There is more than one domain accessing the server but I do...
- Tags: Auth_User, domain, Microsoft IIS Server, munrrob, programming, server, Server Variable
- Q&A 2004-10-13
- << Previous
- page 1 of 1
- Next >>