Search results for query: *

I am running SQL Server 2000. I have a field which comes in as a string of numbers representing a date. For example: 122506 is christmas of this year. 70406 is the 4th of July. I need to get this information stored in a DateTime field in the database. I was hoping to write a stored...

I have a SQL server set up and want to create an Access Database which will reside on a network share and hit the SQL Server. It is pointing to the SQL server through an ODBC connection. This database will be used by dozens of people; is there any way to get it set up where I do not have to...

I have a Visual Basic .Net front-end to a Microsoft Access back-end. The Back-end is stored on a network share and during development, all of which took place on my desktop system, things went fine. The program uses an ADO connection to the database with the line Dim conn As New...

I am a programmer at a company where we are about to implement Easytrieve. I am the most experienced programmer in the group, with knowlege of C++, Assembler, Java, Perl, VB, etc. Most of our programmers are VBA proficient with a little Java experience as well. We are trying to take a 3 day...

I created an Active X DLL a few months ago in VB and it worked fine. Recently a crash left me without my VB files, but I had my code pasted from an e-mail. I have been trying to recreate the files but I don't know what I'm missing. The code should work because it's direct from the last...

I am an experienced VB EXE programmer, but now a client is requesting me to create a program in DLL form and I am lost. I have researched this on the 'net and in books but I'm just not seeing how this process goes. What I need is a DLL which will just return a simple string of data to the...

Is there any way to program a module in Access to connect directly to an SMTP server to send e-mails (with or without attachments such as reports, queries, tables, etc)?

I have a tab delimited text file pulled from an AS400 system which contains over 350 columns of data. What I need to do is go in and replace certain columns of data with placeholder data (data scrubbing). I have been working on this for several days and keep hitting my head against a wall. My...

I have Access applications which send out hundreds of e-mails each day. My company's restrictions have made the following rules: 1) We cannot modify our Outlook security to stop the "A program is trying to send e-mail on your behalf" message. 2) We cannot use Redemption 3) We cannot use...

We have recently upgraded to Access 2002 from Access 97. I developed several databases with user level security, which users would access through shortcuts specifying the database's (MDB) path and the path to the database's specific security file (MDW). It was locked down under 97 so that if...

We have recently upgraded to Access 2002 from Access 97. I developed several databases with user level security, which users would access through shortcuts specifying the database's (MDB) path and the path to the database's specific security file (MDW). It was locked down under 97 so that if...

I am on the verge of ordering all the parts for my new system when I hit a major snag: when did memory become so COMPLICATED??? I built systems professionally for 4 years and never saw anything like what I’m seeing now (back then it was ECC or not, 70ns or 60ns, 30 pin or 72 pin). Here are my...

At my company we are still running Access 97. During my tenure here I have created several databases with user-level security and, using Microsoft's Knowledge Base, I created many easy to use forms for such tasks as adding new users, changing user security levels, changing user passwords, etc...

I am using an access to store images. I have created a button which the user can click on and it opens an explorer window allowing the user to browse for an image file. When the user clicks "Save" the image's file name is stored in strInputFileName, and this code is run: If Not...

I am stumped on something and was hoping someone here could help me out. On several of my programs I use the basBrowse function found readily on the web from the book Access 95 How To (code pasted below). I then use this code to pull a file: Private Sub cmdAddCover_Click() Dim strFilter...

Dear Gurus, I have been searching for quite a while to figure out how VB.Net is useful in an HTML environment. I have seen lots of marketing jargon saying it integrates with ASP.Net and can make useful ActiveX components, but I am a VB programmer and I have a strong web development background...

I am in the early stages of a project but want to make sure I'm going in the right direction with which technologies we use. The goal of this project is to have a help system which will be viewed by users in several cities. I want to have a hierarchical table of contents, much like you find in...

My boss wants a query that is user aware. For example, if Jim Smith, user ID 123456, runs the query then the results will be records matching user ID 123456. Meanwhile, if Jane Doe, user ID 654321, runs the query at the same time it will return results matching user ID 654321. Now the sticky...

I am an experienced IBM programmer starting work on the AS/400 Query/400 system, and I'm having a problem. My company stores dates as six digit numbers in the AS400(not sure if this is normal or not), so if there is no date the field is 0. To query against dates the following is typed in the...