Search results

Copy the table but only paste the data strutuce not the data and provide a new name. In the existing tables, remove the auto-number field and the copy and paste into the new table. This will start the autonumber over in the new table. Hope this helps. I have done this in the past and it works...

I figured out a way to HIDE fields if they do not meet a certain criteria on a report and I have used the can shrink figure to squeeze everything together, however, I still have some big gaps in the report. Is there anyway to remove all the "spaces"? The reason for the HIDING is that I could...

Hello, I am in need of some help! I have a large database that is shared among 250 users. The server the database resides on is having some problems and has caused me many headaches. I was able to run the repair and it corrected the table problems, however, I can not compact it. The error...

Thank You! I thought about that earlier because I have used it in a query to extract by date range however I neglected to use it on the report. THANKS again!!! Deborah

You can go to word and use the mail merge feature under tools. When you get data, search for your database and use the query you created. I do this all the time and it works like a charm. HTH, Deborah

I have a report that should print people with a hiredate of 11/01/03 with a certain number of training that should be completed and another number if their hiredate is less than 11/01/03. =IIf([hiredate]<11/1/2003,1,2) This is the statement I use and it is not working correctly. An example is...

Hello, I have been asked to design a database to attach to a website. The website will allow browers to request information about the company. The client wants to capture this information and generate a database so reports and labels etc.. can be developed. I can design the database with no...

I have a database that we use to keep up with employees who are delinquent in their training. I am not concerned with MM/DD/YY format to extract people. I want Month only. Our fiscal years runs from Oct to Sept. I want people from 11 (Nov) to 5 (May) to print on my report. Currently, the query...

I have a database that captures attendance for varies course that we teach. I need to produce a report that will take the data and align it in columns instead of the data in rows. For Example: (names of the courses) Name.....Job...

We have a program that we call the winmenu. It is a wininstall feature that allows us to display a "calendar" (lack of a better term). The user selects the page and box and double-click to activate the program. We use this to help with security and install programs on certain computers. I have...

Hello All, I need some help. I need to develop an access database that will act like a scheduling system but have database features. We are currently running two different systems and having to key data twice. I need to know who scheduled an appointment and then print various reports and sort...

Yes. I need to find only the people with an O and no other record and then add a new record for this training. It will be classified as AT. Eventually, a person who has worked a year will have 3 records - 1 for new employee Orientation (will always be there and will have hire date as date...

Good Morning! I can not get my mind to work this morning and need some assistance from someone!! I have data from another database that I want to incorporate in my database. The other database (let's call it "A") has training information from all over the company. I track only certain...

Our company is in the process of upgrading to Windows 2000. I have several 97 version Access Databases that are struggling with the changes. This is the error message I am getting: DDE Server Window:msaccess,exe - Application Error THe instruction at "0x0401f9f3" referenced memory at...

I have form that contains a calendar on the top ans a subform with a list of classes on the bottom. When you open the form, the current date is selected and a list of available classes appears. The user can click on the class and register for the class. It was working great until our computer...

I have a large database that keeps track of people attending our training sessions. I have a table of employees, course, and courses attended. I have created a query that will tell me who has attended class and who has not. I have generated a report that shows when a person is scheduled for...

Is there a way to tell who is currently logged into the database? I have activated the Access Security and generated all the accounts. I want to find out who is using the database. I know that the network can tell me through the network end but is there a way in access? Deborah

I have large database that has been working great for the past year. Just within the last few days, I start getting a record locking message. They database is used by a lot of people and I have check all the options under the Tools, Options, Advanced. It seems to have started acting funny when I...

I have a macro that imports a file from Excel and adds the data to an exisiting table. The macro has worked for years. Last week, our wonderful IS department rebuilt several computers and now the macto will not PASTE APPEND in the existing table. WHY??? Is there a reference missing? Please...

This is how I overcome this problem. I copy the table with all the data and paste the structure only. Add the new field and make sure the type is autonumber. I copied the old table again and then paste using the append data to existing table. It automatically numbers the data you existing. I do...