Search results

sorry, I am an idoit I will try again.

DB Link for waynes help Here is the new database with the new module. I am so sorry that I am such an idiot with this, I am great with most other Access objects. Thanks for your help.

Hi wayne, I have not got it to work yet, but I am pretty sure I have figured out the code. So I will work on it more. I just wanted to say thanks for your help. If I get stuck, I will be back. Thanks, d

thanks wayne, stay around I will give it a try, thanks again.

Hi Wayne, I tried the union query, but because there are fields in all the tables that don't match, you can't union query, or can you?

The following is the make up of my tables, thanks for any help First table: Header Record: 8 Fields Second table: Beneficiary Record: 53 fields Third table: Dependent Record: 25 fields Forth table: Coverage Record: 16 fields Fifth table: Participant Record: 13 fields Sixth table: Terminator...

Give me a couple of minutes and I will get you the details Thanks for answering!!

HI, I need big time help: I have several tables that need to be exported, fixed width, into ONE text file. The big problem is that each table has different specifications that must be used, so I can't query everything and send it out once. Big Question: Is there a way to combine the transfer...

Hi all, I have to export data from various access tables out as .dat files for importing into ADP Benefit Services system. I can get the records out table by table and then manually unite them in the .dat file, but that is not how they want the data. I need to get the records out of all...

Problem Solved! Thank you very much! Thanks to you guys, I have fixed the problem using the isnull. I also changed the join properties to include all from the tblInvoice, which got me the new customer then used the isnull to update the null field to 0. Thanks again! dakcg

? Would the Null work if the Customer name is in the Invoice table but not in the payment table? I am not sure I understand. dakcg

Hi, This is the second time I have come against this problem. I know how to make it work, but there has to be a more logical way: Simple Invoice database. Three table: Customer, Invoices, Payments. To create the Invoice report I: sum(Invoices) - sum(Payments) to find money owed. I do the...

Thanks I tried the first thing, and the screen showed up, only for a second, but still there. However, I like the second part, and I am going to give that a shot right away. Sorry for repeating myself, this is just driving me crazy! dakcg

Excel Text to Columns function Hi, I am not sure if you solved your problem, but I wanted you to know that Excel has a wizard that performs that function for you. First move the column to a new datasheet and highlight the whole column. Then click Data>Text to Columns. The wizard will guide...

Sorry about that How quickly we forget! I took a year off from Access, and I am finding that I have to relearn alot! Thanks for the reply! I looked through my old posts before sending this one, but I didn't see this question. Sorry again, I will try to pay more attention! Thanks again dakcg

Hi, Is there any way to turn off the Access Screen that is displayed when you open up an Access databasa? Thanks for any ideas DAKCG

Is there a way to open up Access database without the screen that says Access2000? Thanks DAKCG

reason for query Hi, The reason I am using an append query is because the client only offers one service to his customers, so I have saved the name of the service, plus the monthly charge in the Customer table. So, instead of having to create the invoices by hand one at a time, the database...

Sorry, I will try again Hi, I have created a couple of databases, but this is the first one that I am creating for the Runtime enviroment. The problem is, I am just learning to write code, and the only thing I know about error handling is that it is important! During testing of the runtime...

What? I am sorry, but that made no sense at all! Could you expand?