Search results

I want to flag a form IF a name field AND an address field (from two separate tables) both contain the same values that I currently am inputting on a previous record. Specifically, if a customer "X" files another claim for the same loss location, then I want to flag the form. What is the best...

Will archiving older data improve response time of a database? What is the best way to archive data knowing that older records will still be accessed twice a year?

I have a form with a field that uses a Value List to pick a person's name rather than a linked table of names. Now that the list has grown very long I want to use a table instead of the Value List but the form will not show the old records where the list was used. What do I need to do to use...

I am using Access to email reports as attachments but I am finding that field data is either getting dropped or becoming corrupted intermittently. Referential integrity is enforced between all of the tables. All of the primary keys are indexed while forbidding duplication. I'm not hearing any...

I am a total novice with MS Access (2007) coding and I am struggling with trying to come up with a way to enable an insurance adjuster to add multiple images to any record and to generate a report that includes however many images that are associated with a given record. Can anybody help me out...

I was given the following code to enable me to prefix my primary key with "ACS-" and to start the numbering at "1500" but now I'm discovering that I cannot advance beyond the record number "9999" (ie: "ACS-9999"). Any ideas why?Private Sub Form_BeforeInsert(Cancel As Integer) Dim stemp As...

I haven't written much vba code but I need to create an event that will select data from various defined ranges from an Excel spreadsheet and paste append that data into an Access table. Can anyone help me with this?

I am using a parameter query to obtain data within a date range using the "Between" operator. There may be an occasion where a user may not want to filter by date at all. Is there a way to override this by using: Like "*" & [] & "*" ...or by using a wildcard?

Is there a way to fill blank fields with default values while appending data to a table?

I've noticed lately that when I copy a parameter query using a right click of my mouse that it initiates the parameter prompt. I am not able to do anything unless I enter in values for the parameters. Compact and Repair is no help. Should I be concerned? Is there something I can do to stop...

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...

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...

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...

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...

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...

On a form, is there a way to make a default to a field that is from a table other than the record source's table? I am making an insurance claim form whose loss address is "typically", but not always, the address of the insured. The Field's record source is from a table called tblClaim, and the...

What kind of relationship do I need between a table created for "bills" and one for "fees", where there can be more than one fee per bill. In the "fee" table there is a "Fee Name" and a "Fee Charge"? On the "bill" form I use a combo box and I would like to be able to add to the "fee" table...

I have to impose a single monthly fee on a billing report for each month that transpires and capture this fee as a running total on this report, which will eventually span the course of years. Understanding that this rate is variable, what is the best way to accurately capture this information?