Search results

  1. H

    Adding new listposts

    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...
  2. H

    Solved Editing conflicts after splitting the database

    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...
  3. H

    Solved Unwanted records are created in a table when user changes forms

    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...
  4. H

    Solved Graph

    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...
  5. H

    Solved DCount

    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...
  6. H

    Solved Unwanted result when adding a calculated field

    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...
  7. H

    Solved DSum in datasource

    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...
  8. H

    Solved Missing records

    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...
  9. H

    Solved Import from Excel to Access - unable to overwrite

    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...
  10. H

    Solved Access - the most sustainable setup?

    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...
  11. H

    Solved No access to VBA file

    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...
  12. H

    Solved Filtered subform within a Mainform

    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...
  13. H

    Solved Update query gives different errors

    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...
  14. H

    Solved Possible to add additonal items in a combobox?

    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...
  15. H

    Solved Moving a form with a subform into a Navigationform

    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...
  16. H

    Solved Cascaded combobox in Navigation form

    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...
Top Bottom