Recent content by neeko1226

We're looking for a way to select a record from a list of records on a search form which will then open a record detail form. The issue is having the record detail form display the current values for the fields, but also be a drop-down with other relevant options for each field. For example...

I have a SUM(CASE expression that is not working when I run it in our new SQL 2014 (Windows Server 2012) environment. I run the same EXACT expression in our old SQL 2008r2 servers and it works. Any idea what might be causing the issue? SELECT AA_Category, SUM(CASE WHEN...

I have a vendor software that stores files in folders in the gui. In the actual db (SQL 2005), the files and folders are stored as Node_Name (varchar(128)), Node_ID (int) and Node_Path (varchar(900)). Here's an example of the data: Node_NameNode_IDNode_Path Mortgage 20044.1.2.4...

Thank you for the reply PHV, but I guess it's not all about the $ here. I added the the $ and received the following error message: "Run-time error '3010' Table 'Data$' already exists." I've been searching the net for a solution and it looks like some people are activating the worksheet...

Is it possible to export to a specific worksheet in Excel and overwrite the existing data using the transferspreadsheet method in VBA? I need to export a query to a worksheet that holds the raw data in an Excel workbook. There are several other worksheets in the workbook that connected to the...

We are in the middle of a migration from MS Access 2003 to SQL Server 2000/WebFOCUS 7.6.1. Everyone I speak to outside of my employer tells me that I should be writing SQL Stored Procedures to get my report results, and then connecting WebFOCUS Dev Studio to that result to display/format it...

I was able to get it to work with what you suggested, but I had to modify it a bit. Here's what I did: If IsNull(Me.cmb_Priority) = True Then MsgBox "Please select a priority number and try again." Me.cmb_Priority.SetFocus Exit Sub End If If...

The pre-reqs: I have a db that stores project requests by the department that requested them. Each request has an unique ID (project_num) and a priority number (dept_priority). I have never had more than 10 open requests for a given department at a time. I have a priorty form that includes a...

Does anyone know of a way to track user log in and log out times in MS Access 2003? I can write a vba script to track when they log into the system and the main form opens, but I can't come up with a way to track when they log out. Any help would be greatly appreciated.

I appreciate the input Sister. I will pay close attention to the converted datatypes and replace any If statements with Select Case statements. I would still like to find some sort of training class for us to attend if at all possible, so if anyone knows of a good one please let me know...

Denny - Thanks for the Reply. I tried using the upsizing wizard in Access, and it created the tables in the SQL DB. It worked extreemly well and did exactly what we'll need to do. Are you aware of any things that the other developer and I should look out for after the tables have been...

Good afternoon - Myself and another developer in my department have been tasked with converting an environment containing over 200 MS Access 2003 databases to a SQL Server backend - MS Access frontend environment. I would like to know if anyone knows of a good training course that we could...

We have a Citrix environment that our MS Access world resides on. There are approximately 220 Access 2002-03 databases on the server. The server itself has corruption issues, so we are in the middle of a migration to a much bigger and better one. In testing the new server/environment, we've...

I've attached the vba code I wrote in an attempt to get rid of the dups I don't need. It is only to delete records with duplicate "Applnumb", once I get it to work I will create a simalar process to delete duplicate "LoanNum" records. I appologize for the naming conventions, this db was built by...

I tried it on application number first, I would repeat the same steps for loan number after the application number dups are eliminated. Here's the SQL for the find dup query: SELECT CurrentExceptions.Applnumb, CurrentExceptions.FileDt INTO tbl_AE_Applnumb_Dups FROM CurrentExceptions WHERE...