Search results

Although Chat will probably give better info now a days, here is some simple Word automation to import and export to Word. https://www.access-programmers.co.uk/forums/threads/get-data-from-word-table.320386/post-1853433

Again it may be fine the way you have it. By now we have a little better ID of what this is, but it was never explained how transactions, relate to UCAs, to budget. You would only need an intermediate table if there was a requirement to group transactions for a customer and that group of...

As Mark said you have to look at your business process. I do not know your business, but I would think that the answer is yes. You create a receipt something like TblReceipt -ReceiptNumber -ReceiptDate -ReceiptDescription -ClientID_FK (relates to tblDemoClients) Then you assign transactions...

No it is not correct. The client name combobox is bound and chooses a value from a combobox pulling in existing values. That makes no sense, even if this is not set to data entry. You could make it a text box as I did but it should not be editable since you are adding from the pop up instead.

See demo. You can search for existing clients and add transactions. Your table relationship is simply Clients to transaction, but no intermediate table. Normally you have something like a Receipt table. That has a ClientID and things like receipt date. Then inside the receipt are multiple...

Yes. However, are you suggesting that for a given client they can only have a single revenue receipt? If not you tables are not designed to allow one client to have more than one revenue receipt.

That is because the field is bound. When you open the form it is open to a new record. When you select a name it puts it in the clientname field which is a bound field. If you want to move to an existing client then that field should be unbound with code to find that client. But then you will...

To me the error is still strange. If I try to create and object that I cannot create I would expect this. I should get that error when I do this.

If you are using "new" (web based outlook) you have bigger problems than that.

Or try a decompile / recompile and see if then you can get it to compile. https://www.fmsinc.com/MicrosoftAccess/Performance/Decompile.asp

Not from what you are showing. If you defined a constant with the CONST keyword and then tried to reassign a value you would get that error, but that is not what you are doing. So I guess it is a bogus error message. Sometimes when things do not compile you can get weird errors. I would...

Also I am not sure if there ever was ever a bug. That thread has a work around because the OP caused the problem. @AHeyne points this out here...

I think there are some pros and cons for the different cases and the user might have to test. I have done on paint and got some wacky results when it repaints especially if the format is on the actual controls not a text box behind the controls. I have seen it when you start scrolling or click...

@isladogs, this should be updated on your site. It is no longer up to date since at least 2013. At a minimum after 2013 both the GUI and VBA could create 50 FCs. However, I think based on some reading it could have been in 2010 as well. At a time there was a bug and not a limit. You could...

I find it really hard to do this using parameters in the queries, and always find it easier to do this with sql strings in the code. Especially when you have more than 2 lists/combos. This way I can make a single procedure to filter and call that procedure from multiple events as needed...

I added to this demo so you can compare and contrast the other methods. Rich Text Conditional Formatting Detail OnPaint To make the new demos work I added a field lngColor to the categories table. When you select a color it saves both the rich text as well as just the color value. 1. By...

Are you concatenating with a "+" instead of a "&"? Please show the function, if not no one can guess at the cause.

https://www.access-programmers.co.uk/forums/threads/ms-access-custom-control-built-in-another-language.307414/post-1646046

I do not get this statement. Yes you would select all the controls and apply the rules. However this should take 5-10 minutes and be done. Not sure how you are doing CF, but clearly you are doing something wrong because this is a trivial thing to do in CF.

I would look at possible corruption and do a decompile recompile https://www.fmsinc.com/MicrosoftAccess/Performance/Decompile.asp