Databases
StackOverflow2013
Postsdbo
POAsterisk in Access dataset causing error
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POAsterisk in Access dataset causing error
    primarykey
    data
    text
    <p>I've never really done anything with Access before (though I have done a lot with MySQL and PHP), so this is sort of my first go. It's simple enough: two tables, tblShapes and tblExamples. They are linked by "JCH Shape" which is primary in tblShapes (it's text). I made a form with a combobox that can select a JCH Shape. I then requery the form so that a subform can be populated with the appropriate data.</p> <p>Some of my data, though, is differentiated only by asterisks. So, right now, the values for the column JCH Shape in the rows I have are:</p> <ul> <li>(g)CVC</li> <li>(g)C*V</li> <li>CV*CV</li> <li>CVCV</li> </ul> <p>I was fine until I added that last value, "CVCV". Now, whenever I click it, any time I try to select other data, the form requeries, but displays blank data until I close the form and reopen it, unless I select CVCV, in which case it displays its own data just fine, as if the form thinks everything else has lost its associated data.</p> <p>Asterisk is definitely the problem here, but it only is a problem when it distinguishes CV*CV and CVCV, or other forms where the only distinguishing character is * (it doesn't affect (g)CVC and (g)C*V, for example, but when I tried making (g)CV, the same problem occurred). I don't understand. I'm figuring something is going wrong when I call Requery, but I don't know enough about how Access works internally to know if it falsely interpretting * as a wildcard, or if I'm doing something wrong.</p> <p>I've linked to the file. I know it's messy, but it's my first attempt. Any help would be very much appreciated:</p> <p><a href="http://the-polyglot.net/uploads/other/SP-JCH-Words.accdb" rel="nofollow">http://the-polyglot.net/uploads/other/SP-JCH-Words.accdb</a></p> <p>Thanks!</p> <p>EDIT: Now in the version I uploaded, it appears to be doing it for every entry after the first one clicked. I don't understand at all. It was only doing it when I clicked CVCV 5 minutes ago and the only thing I did was closed and reopened Access.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCrazed
    1. USCrazed
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POAsterisk in Access dataset causing error
      1. This table or related slice is empty.
      1. VTUpMod
    1. COAsterix is the wildcard character in `MS Access`, not the usual % you may find with `MySQL` and others, if you could post the SQL statement which populates your forms we can take a closer look, however I suspect the way to do it is to wrap in double quotes e.g. **""CV*CV""** this will then treat it as a string value and not apply the wildcard.
      singulars
      1. POAsterisk in Access dataset causing error
      1. USMatt Donnan
    2. COThanks for the comment. I had the same thought process, but I think the query that is causing the problem is implicit: I don't actually have any SQL anywhere in the code. I think the problem is coming from Access' own implicit querying when I try to populate the form.
      singulars
      1. POAsterisk in Access dataset causing error
      1. USCrazed
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload