Search results

Just curious to know. When I run certain query from A SQL Table in Access, the result is what looks like japanese characters. Anyone encountered this? Is this an error(it has to be, right)? This is an an email field

Synopsis There are Four tables in this situation: (And the fields) Purchase Order Header PO # Worksheet Purchase Order Detail Worksheet Item QTY Item Master Item REquested PO CHange PO # Item New QTY QTY PO Header and PO Detail...

okay, I think I'm in the right area. I'm not sure if this will require code or not. I have a form that allows the user to make changes to the Quantity of items on Orders. Simple enough, but I need the user to be able to add items to orders where there currently aren't any instances of that item...

This is great advice. And honestly, I hadn't even considered that the problem was with Excel, so this has me thinking in the right direction. I'll try both of the suggestions tomorrow when I reimport the spreadsheet. Thanks.

I have searched this forum but didn't find the answer, I hope I'm not the only one with this problem. I have two text fields in a table that are updated through an excel file import. In the excel file, both fields contain data that is mostly numeric, but there are always about a quarter that...

Success! Thanks for all of your help! I guess we didn't install all of the appropriate libraries when we movede to '03.

Thanks a lot. Appreciate it

I need to insert the file path into a text field on a form. The user should be able to click on the field on the form and a dialog box appear that allows the user to selct the file. I have tried using Terry Kreft's code and inserting into a module, but it is not clear what the next step is to...

Great thanks, If you could paste it here, so I could see what you were doing, that would would be greatly appreciated. Thanks,

I'm new to VBA (actually know nothing about it) I have a subform that is based off of an updateable query that updates the Customs Master and Item Master tables. So far so good. I'm trying to make an audit table that gets written to upon change of the subform. I have unbound fields on the...

In the attachments of the email, I'm looking to send both an access report and a text file, for the text file, I can just insert the windows path. To attach the access report to the same email, how would I do this. I copied the code listed above and it works, but when I attach a "sendobject" it...

thanks, I have it pasted into the code. All I need now is Outlook objects library. How do I get it? It's not listed as an add-in in the menu.

thanks, automating outlook looks way over my head. what about this-- would it be possible to define an alternate email text, like email_text_2 and then reference that for the email body for the excel report recipients?

I currently have access set up to attach a generated excel report to an email and send. As a supplement to the report, I would like to attach a text file that explains in greater depth the report. I can't place this info in the body of the email becuase I only want it sent to those who receive...

Thanks. You're right. There must be a part of the equation that I'm not understanding from my boss, because everything I'm hearing is that one to ones are not essential. And if there isn't, I can work on a more beneficial project. If you don't mind, I have another rookie question. If I were to...

I completely agree with you except The tables need to be in different databases. Er, really they don't-I could just link to the table in the duty rate database. But, bottom line is that my boss says it has to be done. So, I have to break it apart and completely redo the forms so that it works...

Thanks guys-Here is how it works in my db. A new item comes in and the item information is enetered. Then, days later, the duty rate info on the item is posted. The Duty rate info is located in the child table and entered through a different form. The tables are related in a one to one...

thanks, There needs to be a "Cascade addition" button that adds new records from the parent to the child. It makes complete sense, but the answers I'm getting from the forum is that it doesn't automatically enter it. I'm finding a workaround whereby the form for the child table enters the new...

Thanks, got it now

thanks, what I really want to do is add records to the Child when a record is added to the parent. Is this possible or would i need to add the record on the form for the child table and have it add the appropriate data from the parent?