When I add data to a new record in a form (tblOffer) I use a combox (tblContact) to choice contact to each record. It happens when I choice contact that the name doesn’t exist. In order to add a new contact I need today to leave the form and go to another form in order to add this new contact...
Access gives you constantly new challanges.... :rolleyes: :confused:
After I splitted the database in order to open up for additional users I get a message 'Write conflict', or 'Record has been changed by another user'.
The thing is that I know for sure that no other 'user' has been doing...
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...
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,
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...
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...
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...
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...
Hi,
I'm about to import a spreadsheet from Excel into Access. The table in Access is empty (no records) due to that I've deleted all records. The table had some records previously.
I've exported the table structure, filled it with info and then tried to import it back to Excel. Now I get a...
Hi there,
I need some advice. What is the best way to work on a daily base with Access and how should I set up the structure?
My idea is as follows:
Split the database with all tables (amount of data is not so big) in one back-end file and then have two front-end versions. One non-editable...
Hi,
Access can be patience testing I must say. :rolleyes: Especially when I can't think of something that I've done differently compared to before.
When I'm running a front end I now suddenly get a message that the VBA file could not be accessed. The network connection may have been...
Hi,
I've a subform which is based on a query. The query is based on different tables, and one field is [Initials].
The query and the subform is working perfect when I run it "stand alone".
Now, I want to put this subform in a new form, a mainform, which contains a combobox. I use this control to...
Hi,
I use the query tool to create SQL strings that I then add in a VBA module.
I've created the one below, and I get different errors. Does anyone see some odd things? I've tried out different soultions now for an hour....
The mistake is somewhere in the two last lines, that for sure :rolleyes...
Hi,
I've a combobox, linked/bounded to a table, where I choose a town. I would like to have the possibility to, when needed, add a new town, that doesn't exist in the table and then next time this new town should be present in the table of choice. This must be possible to do with some nive VBA...
Hi,
I've a main form with a combobox and a subform. The subform is based on a query.
The input from the combobox filters the outcome of the subform, via the AfterUpdate event:
With [Forms]![frmKundstatistik]![subfrmAnbudPerKund].Form
.Filter = "[KundID] = " & Me.cboValdKund...
Hi,
I'm a newbie re MS Access so my track record is not so long. But I've some track record regarding SQL and VBA code.
I've managed to succeed with getting cascaded comboxes to work in ordinary forms. But when I add these forms to a Navigation form with both horizontal and vertical tabs I...