Search results

Hi, I've one annoying thing that happens every know and then. I've added a navigation form (An Access standard one) where I've included all forms in different category tabs. Some forms add new records in a table while others just update existing records with an additional data. It's when I move...

Thanks for answers. I'll get back a.s.a.p. 🙏

Hi, I would like to create a graph in Access as a Stacked Column one. X-axis: Year_Month (2020-04 e.g.) and Y-axis: a summary of 'actual' and 'forecast' revenue each month. Preferably different colours in the graph. I've today two different queries. One filtering out 'actual' (revenue that we've...

Hi, really strange. I thought my first code was fine. And it was a textbox as well. I erased the textbox and created a new one. And then all of a sudden it worked. Thanks all for your quick support! I appreciate it! 🙏 :)

I need to leave my PC for a couple of hours..

Thanks, good idea, but I still gives error... :-(

Hi, I try to summarize the number of records with a specific field value. I use the follwing vba code: me.txtNumberOf=DCount("StatusID","tblOffer","StatusID=1") I get error code 438; The object doesn't support the property or method. The anoying thing is that I've other similar DCount...

Hmm....I tried this before without any success....but thanks to you theDBguy I managed to figure it out. What to say? Thanks and the hat off! 🙏 :)

Hi, I’m trying to add a calculated field in a group by query and I don’t get the result I want. I’ve three tables: tblCustomer tblContact tblTender. I’ve the following two one-to-many relationships: tblCustomer (one) – tblContact (Many) tblContact (one) – tblTender (Many) I use the...

After some changes I made it work. My intention was not to use the VBA editor, but then I decided to do so. And here I needed to swap ';' to ','. I'm so grateful to all of you helping me out with all of my issues. Without your help, I fear I would have given up a long time ago. Thank you for...

Thanks! I'll try when I'm back at pc.

Hi, Sorry. Pls, let me try again. And pls let me also expand my desire. My intention is always to try myself first, but when error messages don't disappear it gets a little frustrated :rolleyes: Name of the table: tblTender (the domain) Name of the field to summarize: TotalSum Name of the...

Hi, I've entered the following in the rowsource for a textcontrol: And I get '#Name?' as a result. And I can't figure out why? I'm using a Swedish version of Access, and I need to use semi-colon... The intention is to summarize records in field 'TotalSum' in table 'tblTender' entered the...

@Pat Sorry for a very late reply. I've had some time off from my computer. And I do hope your surgery went well and that you're feeling better. As you see above I've one table (tblAnbudsledare = tblTenderPerson) with a one-to-many relationship with two different other tables. This is due to the...

Well, I'm Swedish so it's Swedish text you see :rolleyes: Yes, I do agree that the scheme looks a bit odd. I've two relationsships (one-to-many) established from tblAnbudsledare. Same persons can create records in both tables (tblAfärsmöjlighet and tblAnud). One person ID can create a record...

Thank you so much for your help! 🙏 🙏 And I'll most certainly be back with new 'problems' ahead :rolleyes:

Hi isladogs, Sorry for late response. Yes, indeed I considered your comment re outer joint. I checked the join properties and try to select an outer join, but then I got a message that (if I recall correct) I should edit the SQL string instead or something like this. Well, to be honest, I'm not...

Hi, Pls, see attached screenshot below. 1. This is the field I use a combobox to filter on. I don't have any empty fields in the tables. (Doubled checked) 2. tblAnbudsledare and its relationships to the other two tables is the problem. The query only picks the records when...

Hi, I've a query which I run with absolutely no filter. And I don't get all the records. Why? The query is data source to a subform in a form. It consists of fields from several tables, which all are connected with one-to-many relations. Does anyone have any idea why I don't get all records? I...

I managed after I've doubled checked field names and data types. Thanks all! 🙏