TechRepublic : A ZDNet Tech Community

8 Resources for

munrrob

  • Subscribe to this listing via:
  • RSS
  • Email

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 >>


IT Manager's Tool Kit, Third Edition
Proven peer-authored advice and over 30 templates cover a variety of management topics to help you overcome staffing, financial, disaster planning and other technology challenges.
Buy Now
Quick Reference: Linux Commands
Reduce stress and speed up resolutions with the easiest command references right at your fingertips. You'll receive a PDF file covering Linux, packed with the most common commands you'll need and use daily.
Buy Now