Search results

Hi! I have yet another problem with access. this time with the ListView control. when I try to disable it (listview.enabled = false), all the items disappear, except one... the first, and all my checkboxes disappear as well. when I re-enable it (listview.enabled = true), the listview decides...

Hi, as I stated in the subject, I would like to combine several reports into 1 report. I did a google groups search, however, but I couldn't find any good solution. The most popular was the subreport, but I can't do this, since the print order is extremely complicated and chaotic. Each page...

Hi I'm having troubles with the Format event. More specifically, one of the parameters: FormatCount. In the Access help, it says that FormatCount will supposedly return the number of times the section has been formatted. However, a section can be formatted 2 times, and the value of FormatCount...

well that's not new. Access crashes a lot. But I can't seem to find a workaround this time. First of all, here's my situation. I have a big 11x17" report with 7 subreports that are identical in it. The only difference between the 7 subreports are some of the properties. Now, when I want to...

Hi. I'd like to format some of my fields in thousand of dollars. For example, instead of displaying 1,000,000$, it would display 1,000$. In reports, I was doing a division by 1000 (control source= [field] /1000). Unfortunatly, I can't do this in read/write field on a form, and that's normal...

Hi, I am capable of sending parameters to my query with a global VBA function. However, the problem is that the comparison operator cannot be changed. Everytime the query is executed, the operator has to be changed (the selection is performed in a form). SELECT * From MyTable WHERE Column =...

Hi, I'm trying to merge 2 "transform" query into another one... instead of having three queries i'd have 1. I could have used a three query method, however in my current situation, it wont work because for every query I have to change the conditions and columns in the "where". sometimes a...

Hi, I'm having this annoying problem with Access. First off, I have a Query that works fine, no problems... until this morning. I was able to open the query and modify the data in it. But since this morning, it seems that I'm locked out. I have full permissions on the tables and the query...