Search results

Lured by the promise of data entry automation, my client, a 3rd party freight forwarder, has made an investment that involves receiving Carrier invoices via EDI. With EDI, everything comes in as a flat file, with only the carrier's name assigned an industry wide identification number called the...

Yes, that is what I am expecting and I am told that the data will come from 7 - 8 different companies. The client I am working for has no IT department and the setup seems to have been very hastily conceived. What is the best way to integrate this with my database?

Thank you Atomic Shrimp, I will look into that. Something has got to work, I can't be the only one with a relational database that imports data via EDI.

Thanks for the tips, I can sure use all that I can get. So, I can import the .csv directly that's great that will save some steps, and I should have remember the update query, I should review that. Basically I have a form that thus far, we have been manually entering. The data we enter...

That sounds interesting. I will give that a try. Thanks a lot RuralGuy!

Another contractor built a database for my client and felt they needed to remove MS Outlook. As a result, emails initiated from my form now give users the following error, " Command or action "send object isn't available now". Any ideas on how to resolve this? Here is the event procedure...

We have a general invoice table that has a shipper ID and Consignee ID that are linked to tables with details regarding these two entities, such as name, address, etc... We also have a carrier's invoice billed to us that will be coming in via EDI and will have shipper and consignee names and...

Thanks for the advice Galxiom, sounds like a good strategy!

Thanks a lot Galaxiom. I need to learn more about input boxes for parameters queries and query parameters read from forms. Do you have any books or Websites that you would recommend?

I have tried that but I then receive the message, "Too few parameters. Expected 3." This is a Parameter Query which uses 3 parameters but in opening this query in Datasheet view I have already provided the parameters.

I am opening up a query, choosing Export, choosing Save as type: text files, checking the box for Save formatted, choosing Export All, and choosing Windows (default) as the encoding. Below is an example of the results, there is only one record in this example and I removed all but three columns...

I am trying to export data from a query as a .txt file with Windows Encoding but my output always includes dashes that separate each record. Our EDI clients insist that this intermittently causes problems with them. Is there a way to export the data from the query without the dashes? If so, how?

I have set up a form that E-mails a specific report but there is an intermittent problem that involves the disappearance of anything from a single field to the entire report's contents. When I run the report everything re-appears. Has anyone heard of anything like this? If so, do you have an...

It turns out that there was a problem with our Internet service. The upload speed from the server's site was 276 Mbps. We have DSL and it is usually around 730 Mbps. Our network guy's explanation was that I broke the Access application somehow with my programming. I insisted that our poor...

(How do I skip a line and create a new paragraph in this forum?)

The data sources for the combo boxes are loading with the form, Rich. David, I'm not sure if I follow you. I have copied both back-end and front-end to my local drive, linked them together, and it runs fine. This however was with all of the data.

Where did you move this to, Pat?

I have a form that loads impossibly slow. The display repaints as you go from field to field and there is even delays typing in characters into a field. In fact all of the forms have been loading slow, big and small. This has been getting progressively worse. Everyone connects via Windows...

Ha, ha, ha!!! You guys are good!!! Thanks a million!!!

I have a query where I am trying to count the number of claims issued against a specific insurance company. I have no problem until I impose a date range, then I end up with a listing of the number of claims against a company per date entered. Is there a way to define a date range and still get...