Search results

Nicolette, I think most of the people who know some of the answers by now, have got there by fighting those same fights. We have figured out that Access is great, and it's worth the fights. :) So it is always gratifying to see others who are keen to learn.

Yes, g'day Chris... nice to see you. Hope all going well with you.

Yay!! I am very happy to know that we finally got there, Nicolette! By the way, not so silly of you... I think it is a common mistake. Silly of me and the others here not to think of it sooner! ;) For the record, I use the naming convention of always naming a subform the same as the name of...

Nicolette, That means one of three things: - frmCreateInvoiceSUB is not the correct name of the subform control (Note: this refers to the name of the subform control on the main form, not the name of the form that populates the subform - they are not necessarily the same.) - OrderSubtotal is...

Another place where I often use a textbox to mimic a label is on reports where you want Can Shrink to work in the case of the attached data control having no data, use a "label" with Control Source: =IIf(IsNull([MyDataField]),Null,"My label text")

Riverburn, Yes, subforms are the "stock standard" way to approach the management of data related one-to-many in Access.

Riverburn, Well, I am having difficulty understanding what you have there now. Which field(s) are these boxAssignment_x comboboxes bound to? I had begun to suspect that your problem was related to a poorly normalised data schema. But now I am not so sure. But if you have it set up...

Awesome, Bill. Sweet when you get stuff to work how you want, isn't it?

Riverburn, Can I go back a step for a moment? Am I correct in my interpretation here, that you have multiple fields in your table, Assignment1, Assignment2, Assignement3, etc, to allow for the multiple assignments for each employee? If so, is your database design set in concrete, or can...

James and vbaInet, Yes, this article is talking about managing this stuff in code. Nicolette's scenario concerns a Control Source expression - nothing to do with code, and a completely different kettle of fish.

Nicolette, I think Bob has made a typo in his reply to you. And I think your expression is also incorrect. I am not sure how the expression builder is handling this. But if this is the name of your subform: frmCreateInvoiceSUB ... and this is the name of the control on the subform that you...

Stemac, If I understand you correctly, then the advice about DCount is good. If you are getting a compile error, it would help others to help you if you could show us what you tried. What I imagined was something along these lines... If DCount("*","NameOfYOurTable","POST_CODE = '" &...

Bill, Further to Galaxiom's advice, I can also suggest that you can use Conditional Formatting to conditionally toggle the Enabled property of the "textbox masquerading as a command button", which is probably a simpler approach.

Djwasim, As far as I know, this is not possible. You either need to make the size of the button to accommodate the size of the image, or you need to use an image editing utility to create a different sized version of your image. The exception here would be if you can use a properly...

Chaos, If I understand you correctly, you can make a couple of calculated columns in your query, like this... Debit: IIf([YourAmountField]<0,Abs([YourAmountField]),Null) Credit: IIf([YourAmountField]>=0,[YourAmountField],Null)

Andy, Access's built-in Help is excellent. If you're serious, a good Access book or two is an excellent idea. A good general purpose one is "Building Access Applications" by John Viescas. If you will be using Access 2010, you might wait a couple of months, as there are some great new...

Rinie, If the value is to be repeated in the same field for more than one record, then by definition it cannot be the table's Primary Key, as the purpose of the primary key is to uniquely identify each record. IDItem may be applicable as the Primary Key in the Items table, but not in the...

Andy, No, there is no such thing as "Access Professional". I think your informant was referring to the idea that Access is not included in all editions of Microsoft Office, but it is part of Office Professional. No, you can't compile an Access application into a an .EXE file. However, you...

Speakers, Do you have the AllowAdditions property of the frmTransactions form set to Yes?

Jyan, No, Attachment data type fields are not really for images, in the sense you are asking. They are for storing attached files (of any type), but this won't work well for the display of images. I recommend that you continue with the practice of using a text field to hold the path/file...