Search results

Hi everyone, I'm having a problem with a subform I have which shows payments for a particular supplier. These are automatically imported from the supplier, and sometimes (about 10%) they have the wrong classification (the field paymentType in my Payment table). Is there a way I can have a...

Has anyone got TOP syntax working in a DELETE query? I am trying to delete all records with the most recent date. The syntax works with SELECT eg SELECT TOP 1 Payments.DateOfPayment, Payments.* FROM Payments ORDER BY Payments.DateOfPayment; But doesn't port to DELETE. Clues?

In VBA, I am exporting to a template. My checking goes to the extent of checking if a file exists, and getting permission to overwrite: If Dir(sOutput) <> "" Then ' If output file already exists varConfirmOverwrite = MsgBox("The output file name already exists, would you like to overwrite...

Are there any templates? My database is a collection of various payments, and I would like to create a good summary report of them all, much like a profit/loss statement. I'm messing around with a report, creating basically the whole thing in the report header, since no detail is required and...

Hi all, my current problem is that I have a many-to-many relationship which returns odd numbers of duplicates when queried. Each payment has a unique payment ID, but there are duplicates of this payment ID. I could just get the top 1 payment ID, but that seems like a patch rather than a fix...

Here's a curveball. I have a subform detailing a person attached to a record. I want to attach another person to this record. Can a button add more space to the main form, and put in another of the same subform?

Has anyone else noticed that calculated text boxes don't draw immediately in 2007 reports? I have fairly simple calculations in my boxes, and they show as soon as I click on where they should be, but don't show automatically. Is there a workaround for this? It's just a little annoying thing...

Hi guys, I was trying to redesign my report to avoid having so many DSum calculations, so I have made a single crosstab query with the various sums I want. However, I obviously didn't research well enough into how this would link to my report. The crosstab query has 5 categories of payments...

Hi there, thanks for looking. I'm trying to create a crosstab query which gathers fields from two different queries. With one query it works fine, providing summaries of all payments for each advisor, by payment type: PARAMETERS [Forms]![Advisor Summary Request]![txtToDate] DateTime...

Is there a way to put an editable section into a report?? I have a financial summary which does a lot of automatic calculations and sums them, but there may be misc items the user wants to add to the total. Can this be added to the form, and the control source of the sum textbox? Something...

How can I set a default value in a report text box ? There doesn't seem to be an obvious option in the property sheet

Hi guys, I'm looking to track changes to a field in my Insurance database. Each Insurance advisor has a percentage of a total pool of investments. This is easy to show, with a field in my Advisor table. However, how can I look back into the past and see what the advisor's investment was 2...

Hi guys, just to confirm, I'd like an opinion on my methods. Each advisor has a number of payments made to him, and there are a number queries on these limiting to date, payment type etc, for that advisor. I'm trying to make a single report which presents summaries of each smaller query (total...

I'm sure this is a common problem, but I haven't found an answer yet. I'm trying to allow the users to edit a given record through a form. They enter an ID number (policy number) in a text box, which then populates all the other text boxes and the subform (payments for this policy). Any...

I have a table of payments which relate to policies in my database. When importing from my temporary table, the amount I input depends on what type of policy the payment is for. How can I express this in my Insert Query? I spent a while making a select case query but I don't think that works...

Hi guys I'm importing from a computer generated form which is limited to 20 characters per field, and matching these results to my current table, which often has more than 20 characters. How can I use wildcards to ensure that "Lifetime Christchurc" matches to "Lifetime Christchurch" in my...

Hey guys, I've had a wee search but I can't find code that seems to work in my situation. I'm trying to update my temp table with the Advisor ID from matching records in my advisor table. What's the problem with this? UPDATE [TempTable-SovImport] SET [TempTable-SovImport].AdvisorID = (SELECT...

How can I, in an update query, search for matches and update the foreign key? I have this so far, but it is yet to find anything. UPDATE [TempTable-SovImport] SET [TempTable-SovImport].AdvisorID = (SELECT AdvisorID FROM Advisors WHERE (([Advisors]![FirstName] = [TempTable-SovImport]...

Hey guys, can an if statement be used to parse/split a name in SQL? I'm assuming it would be quicker than VBA. Here's my current code: ' My major worry is that this could be a lot quicker if done in SQL, but that is very complex to design Do Until .EOF '...

Hi everyone, this is a great site and it has been very helpful, but I'm not sure I am tackling my problem the right way. I'd appreciate any insights. I have a database of insurance payments which is separated by object type(advisor, Policy, Payment, Customer etc). I import a .csv file into a...