Search results

Hi, Is anyone else out there using Access 2003 and Windows 7? I seem to be having a little problem and do not know if it is a version problem or what. I have set up my tables, created a query to link them together. The I design my form in design view... but when I click on form view, I get a...

Gee Whiz, ok, you just went over my head with that one. How would I go about doing that? I have a query that works in SQL Server for this, is there a way I can build a VB application that runs the query and returns the fields I need?

OK, I cannot change the structure of any of the tables. Each company has it's own table, then there are other tables that support the company tables such as a Comments table, Term Codes table, Employee Status table, etc. This is an application that was written by someone else, and I have been...

Let me try this again and try to word it differently. Sometimes I have to search for one employees ID number through 50 different tables. Is there a way that I can return about three fields from a record that I search for using the employees ID number? What I need is a form that when I input...

The tables in my MS Access application are linked to tables in SQL Server 2000.

I am using MSAccess as the front end to a SQLServer2000 DB. And as you know, the tables are reflected in the tables when you open Access.

OK, here is the Query that I have been running from the Query Analyzer in SQL Server 2000. I now want to build a form that will run this query by clicking on a Search button on the form. If it finds the ID Number, then it will populate the fields I have requested in the Query... if it doens't...

I have a query that I wrote that searches several tables for an employees work ID number. The query works GREAT! But now I want to build a form with a search button that when clicked will run the query and if it finds the employee in any of the tables, it will return the requested fields on the...

No, I still have not been able to change the number in the report to the Month of the year. I tried the suggestions and got varied results.

I import one text file that is evenly spaced with maybe 25 fields. I need to add another 20 or so columns to get this file to match up with an import routine I have written. This company sends me 3 different data feeds in text format. One of them has 45 columns, the other has maybe 30 columns...

I have a text file that I will be importing into a new table once a week (every week) that I will need to add about 30 more columns to before I export it to a new text file in preparation for importing it into another Access application. Is there a way through a query to add the columns without...

Worked perfect guys!!! Thanks!!! Actually I only had to use the "ltrim" command to move the numbers to the left justify position.

I have a table that for some reason when I imported the data, placed some spaces before about 75% of the numbers in only one column. I need these numbers to be exactly the same as in another table because I use this number to compare to records and import other data depending on the...

Thanks guys... it worked perfectly.

Hey Guys, I have a db that has about 100 tables in it. I need to backup only one of the tables and then restore it to a different db. I looked through the Online Books but didn't find anything that told me how to do it. Any help will be greatly appreciated... Dave

Works perfect... thanks for your help.

perfect... thanks guys. I'll let you know how it goes.

If I want to move all of the data from Column A to Column B, deleting the data from Column A, and making sure the data stays with the same row, how do I do that? Would it be something like: update tablename set [dateB]=[dateA]; del [dateA]; I am only guessing here... Thanks, David

I got it to work with the first query. I looked and looked for reasons as to why it would not work and everywhere I went, they pretty much said to do it the way I was doing it. So I went to the physical SQL Server and opened the Query Analyzer and typed it in with the same results. So I opened...

Yes, positive... actually at first I was using a code that wasn't in the table. So I looked through the table to find an existing code.