Thanks.
Oddly, that's (the first way) what I was doing, but it wouldn't work. I deleted the table and started from scratch and it worked fine....
Bhujanga
Last Activity: Nov 12 '09, 09:14 PM
Joined: Aug 3 '06
Location:
-
Multple Key Fields
How do you define fields so that duplicates aren't allowed based on a combination of two or more fields, but it's ok to have duplicates in any one of the fields? So for example:
Permit Number is a field and Amendment Number is a field in the Amendment table. There can be no duplicates of the Permit Number in the Permits table - that's no problem.
But in the amendment table I can have amendment nos 1,2 and 3 for Permit... -
I changed the variable name to PathA and it did the trick. Thanks. Sorry it took me so long to reply. I've been out of the office for a while....Leave a comment:
-
FollowHyperlink not working with pdf file
There is a screen for printing various form in an application I have. Some of them integrate data into the forms, but a few are just there so the users can grab standard forms while they're in the screen. So I have been using command buttons that say what form it will open. The code that goes with the command button is as follows:
Dim Path As String
Path = DLookup("[Path]", "Region Data") & "\Common"... -
Thanks. I used your first suggestion. Much more straightforward than what I was trying to do. (I was trying to get DoCmd.RunComman d AcCmdRefresh to do it, and couldn't figure out how to point it to the Contract table from Event code from the other form.)Leave a comment:
-
Getting data to refresh automatically
I have a form for entering various contract information. On that form there are some fields that contain the total budget for the contract, which is a single field in the 'Contracts' table, which is the data source for the table. There is also a field for total invoices and the remaining unspent amount in the contract. The total invoices sum up the amounts from the "Invoices" table for all invoices with that Contract No.
I have... -
You were exactly correct. I must have never used this method before with a text field. Thanks!...Leave a comment:
-
DSum Syntax Woes
I have a field on a form that I'm trying to show the total of the invoices that have come in for the project. The ProjectID is field on the form which is in the forms primary table (ContractInfo). There is a child table called "Invoices" which is also has a ProjectID field that ties those records to the ContractInfo table, and of course it has a field for the InvoiceAmt. So in this ContractInfo form I have a text box and I'm using the following... -
That's what I needed. ThanksLeave a comment:
-
Testing for Null Values
I have a form where the user enters various fields of information. Some of these fields may be left blank until a point in time when the user is ready to issue a permit. At that time they will click a button that unleashes a sequence of events that ultimately results in the aforemntioned permit being issued. The first events is a data checking routine, to make sure that all the values are appropriate for this action. I'm able to test most things... -
Thanks. Using the 'Detail_Format' event was the key. I was actually able to get it to work with the following:
Me![imgPicture].Picture = Me![FileName]Leave a comment:
-
Photos in Deatil Section of Reports
I have a parent table - we'll call it SignOwners. It has various info about a bunch of sign owners.
I have a child table that contains information about each sign these people own. Among that information is a filename that contains a photo of the subject sign.
Now I want to put out a report that is organized by Owners and has a detail of each sign they own, including a photo of it.
So I have my parent "Owner"... -
Thanks, I'll check it out.Leave a comment:
-
I appreciate all your help on this. I still can't get the VB editor to accept that statement. It keeps wanting an equal sign somewhere. In any case I've had to abandon this particular detail for the time being in the interest of not letting the project fall behind. If I have time later I might revisit it. For now they're going to have to collate by hand. Thanks again.Leave a comment:
-
Ok, I created a new module and put the function code in there ver batim.
Then on my form, I created a button, and in the click event code I attempted to put the following code in:
CollateReports( 1, "Annual_Billing _CoverLetter", "AnnualBilling" )
It protests immediately, saying that it is expecting an '=' sign.
Am I missing a step somewhere?Leave a comment:
-
I must be doing something fundamentally wrong. I put the first part of the code ver batim at the top of what I believe is considered the "Module", i.e. the first lines of the code window for the form on which I'll put the command button.
Then I took the other line of code, replacing its report names with mine. VB doesn't want to accept this. It is expecting an = sign. So I haven't been succesful testing it. I fear my programming...Leave a comment:
-
Thanks for replying to my question. I studied the code and it appeared to me that the routine collates by actually alternating one page from one report and then one page from the other report. This won't work for my situation, because sometimes one of the reports will have multiple pages for one customer, and need each customers cover to appear before their potentially multi-page bill report. So I need to make the collation switch at customer break...Leave a comment:
-
Collating Report Output
I'm trying to print out billings with cover letters to about 800 customers. I can't figure out how to include the cover letter in the billing report, because each customer can have several pages of line items in the bill and there have to headings on each page. I don't want these headings to appear on the cover letter so I can't seem to include the cover letter as a 'customer header' which is what I thought I might be able to do. If I print the... -
Both are good things to know. I'll probably set the functionality of of the field's Enter Key behavior for this case.
Thanks.Leave a comment:
-
Carriage Returns in Memo Fields
Is there a way to set a memo field on a form so that the 'Enter' key will behave as a carriage return instead of leaving the field? I know the field type recognizes carriage returns if you feed them in programmaticall y, but I can't figure out how to get them in there just by typing.
Thanks.
No activity results to display
Leave a comment: