Search results for query: *

You guys are fast and very good. Let me explain this a little bit more. I am actually disabled and on full-time disability. I was an IT Project manager for a large corporation and have done some Microsoft Access programming in the past. Parkinson's disease robbed me of my career and my...

That's an interesting thought. The geographical area is rather small, so I could potentially create the zip code file myself. I'll look into it, thanks.

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

Sorry, accidently posted to the wrong forumm. This is an MSACCESS ?

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

Thanks to all for your responses. I used the union approach and it worked well. You've saved me a lot of time! Thanks, Cindy

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

Tony, Thank you so much that worked. However, you do say that this is rather poor design. What would be another approach to accomplish this? Thanks again for your help, Cindy

Follow this link to see whats happening http://pg.photos.yahoo.com/ph/cindyg1958/album?.dir=/4c67&.src=ph&.tok=phnD1YEBOhfmp8QC

I played with it some more this morning and discovered that if I remove my inserted page breaks and simply press enter forcing blank lines..the footers work perfectly. This is not how I'd like to do this thoughh.

2000

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

Thanks so much...that worked great!

...As String Set rst = New ADODB.Recordset Set objFileSystem = CreateObject"Scripting.FileSystemObject") strSQL = "select * from [tblPPXFiles]" rst.Open strSQL, CurrentProject.Connection gstrPPxFilePath = rst("Path") gstrppxFileName = rst("filename")...

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 managed to resolve this myself. Part of this application opened Excel spreadsheets and PPX files from PowerPlay. These resources were not being released. When the release of these resources was added, the problem was resolved.

Unfortunately, that doesn't seem to be it either, I've checked the running processes and msaccess is not there nor do I see any references to anything that looks like vb. Still stumped.. By the way, we are running Windows 2000, Access 2000 (9.06926 sp3) and VB 6.3

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?

Thanks so much Ginger...MODAL was set to No, but Popup was set to yes. Changed Popup to no and it now works great! Thanks Again

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