Recent content by neffs

Found my own answer If anyone is interested, I found the reason I could not split the database was because there was a corrupt record in one of my data files. The Access 97 repair utility did not repair the error. I had to delete the record and re-enter it. I found it by doing a search for...

I am attaching an Access 97 Database that I made up based on the info you gave me. It is the best way for me to simulate your problem. I have created datafiles, queries, and some forms that I think will help you or at least give you an idea of where to go. The attached database is rough...

Is each account number related to 1 country, 1 Sub-Region, and 1 Region? Also, are the regions divided into subregions? The way you have your table set up it seems like the region is a division of the Sub-Region.

I'm pretty sure you would have to use a subform. If you can give me a little more information about your datafiles and relationships I think I can help you a lot.

I used a database called Sculptor for a long time. When I started using Access, I needed to convert some of my Sculptor datafiles to Access. Usually what I do is dump all the data into a comma delimited or some other type of text file. There have been times when I had to write a report...

Are you using 3 different combo boxes on your form or are you just using one combo box for all three? How are you getting your list for each combo box? From a table or are you typing in a list in the properties or do you get it from a query? I think I would use 3 separate combo boxes and set...

I'm an old guy. Been programming for a long time. I have taken data from almost any type of file and dumped into any other kind of file. My suggestion is to forget the excel and write the gathering data application in Access and then import the data from their data files to the data files on...

I have a data base in a shared directory on a Windows 2000 Server. I created the database on my home computer and copied it to the Server. There are two workstations accessing the program and a person using the server as a workstation also accessing the database. I am about to add another...

I was trying to avoid doing that because I thought there should be another way. But I guess that it is not too inconvenient to do that so I will try it. I'm pretty sure that will work. Thanks. Sam Neff

I have a report that prints on a legal sized page. There is a header and footer which contain no columns. However, the main body of my report is two columns. The report prints beautifully from access. User wants to attach the report to an email. I tried to publish it with MS Word and it...

If you are looking at your data in datasheet view, the memo filed will be displayed as one long text field. If your column isn't wide enough to see the whole field, you will only see part of it. Click on your data in that field and hit the End key and it should take you to the end of your...

I am not sure about this but I don't think you can format a memo. Ctrl Enter will allow you to add a carriage return but I think that's about all you can do.

I have tried this but it doesn't work.

I have created a form to display when I open my database. I don't like switchboard. I have put command buttons on the form to take me to the programs that I want to open. When I return to this form I want it to be maximized. When I return from some forms it stays maximized, but there are a...