Search results for query: *

I have a database which contains within it the addresses of clients. I need to be able to calculate which clients are located west of a certain area. For instance I needed to calculate if they're located west of Washington Road? This particular city is not laid out in a good grid format where...

I have a database which contains within it the addresses of clients. I need to be able to calculate which clients are located west of a certain area. For instance I needed to calculate if they're located west of Washington Road? This particular city is not laid out in a good grid format where...

Hi Ya'll, I have a table I'm importing that looks like this Customer Name Smith Brothers Product A Price of A Quantity of A Product B Price of B Quantity of B Product C Price of C Quantity of C and is a single row per customer. I'd like to convert this table into a real table like Customer...

Hello All, I'm writing a user manual. I have three levels of headers...heading 1,heading 2 and heading 3. In the footer of my document I have {STYLEREF "Heading 1"}, and the same for headingss 2 and 3. With the idea being that you can flip through the bottom of the pages and view the...

I'm trying to write a quick vb app to help replace server names in .ppx files. ppx files are Cognos PowerPlay files. The contain the server name that the .ppx is suppose to run against. We are a big PowerPlay shop. I'd like to write an access app which will allow them to identify the files...

Hey everyone, I have a table which was imported from another application. I need either a query or a report which will sequence the results by column heading. See example below (this is a simplified example...my actual data has 1800 fields...) So if my input is like this: City Address...

I've seen the file sharing lock exceeded error on this board many times for when the Access application is running, but I am experiencing this problem when trying to save a vb module... What would cause this problem?

I have an application that runs on a pc and loads data. This application runs for quite awhile so I've developed a few screens to let the users know where in the load process the program is. So.. first I have a main status form which has the high level steps the application goes through: Step...

I have an application that I've been working with for a few days. Everything was fine until after lunch today. I must have done something that I'm unaware of. When I open a form in design, and attempt to add a button to the form I get an error that says "undefined function...

Hi Everyone, Here's the high level view of what I'm doing. Opening a PowerPlay ppx file Saving the data into an excel file opening that excel file and doing some cleanup - deleting unneeded headers, etc save and close excel file transfer spreadsheet The transfer...

I need to write a query to rank a group of individuals based upon a score within a month. My data looks like this: Rep Month Year Score Dana 1 2004 33 Dana 2 2004 47 Dana 3 2004 65 Dana 4 2004 23 Dana 5 2004 56 Dana 6 2004 67 John 1 2004 45 John...

I'm trying to execute a Texttocolumns command from a vb module in Access against an Excel spreadsheet. Here's my code: Sub parsetext() ' ' parsetext Macro ' Dim strexceltab As String strexceltab = "excel" objXLApp.Worksheets(strexceltab).Range("b1").Select...

I am a Microsoft Access developer. I work for a major corporation which has provided me with Dragon NaturallySpeaking. I was diagnosed with Parkinson's disease three years ago and have difficulty typing. Dragon NaturallySpeaking includes commands for various software products. Does anyone...

Looking for advantages of upgrading from 2000 to 2005 for a 100+ sales force.