Search results

On one of my forms the ID jumps from 35 to 2534. it is Autonumber and the new values are s'pose to be increments? Does anybody know why this happens? Thank u Stacey

Hi, I have a form on which I have asubform. This form is based on a query. I would like the user to be able to add/and update information from excel to this form. When I try to copy from Excel and paste them or try to overwrite the eisting data, I get the following error: " You cannot add or...

I have the following problem, which I think might be quite easy for some of u..( hoping u can help.. :) I want to use the DStdevP function, DStdevP("myfield","myquery", myproduct=myquery.product and between enddate and begindate) However, in my database i distinguish between year and month...

Im gonna try it.. Im not sure whether it will work cause the checkboxes are seperate fromt the records im selecting. Do u think i could use the where condition when 'my ckbox' is in a different table? thanx Stacey

Hi, I have around 12 bounded checkboxes on one of my forms. By using these checkboxes, the user can indicate which statistics he would like to see in the ouput. (I have created a table to which I bound the 'answers' of these checkboxes. ) Im trying to create a module that does the following...

Thanx.. I will try to implement it like that..

Hi, I want to be able to change the 'uncheck' and 'check' the show button in a queryfilter in VBA? Does anyone know the code/command for this? Thank you.. Stacey

Hi, I have my information broken down into single pages. Maybe I was a bit unclear. What I mean with headings are the 'nametags' of the pages. It seems to me that it is not possible to put them seperately on the main form, right? So, what I want is to have a 'tool' somewhere in which I can...

Hi, Was wondering whether its possible to control the appearance of pages... I have a main form on which I have about 7 pages. When the main form is in the FORM-view, the headings of the pages are 'hidden'. One has to scroll up in order to see them. As certain users of the database will be...

You are right... wasnt drastic at all.. Its working okay again.. Thank you.. Stacey

Sorry... I just tried the compact and repair... Still nothing.. It does sound drastic to me.. I have to create another mdb.. But that would imply that I have to create all tables and queries again, right? or not? Could u indicate the right steps to do this correctly? Thanx..

Sounds kinda drastic... Shouldn't I leave that as last resort? What will happen if I compact and repair it?

I went through all the sub procedures as you said and checked for valid pc code, but still nothing. The thing is, I can still see the form that is giving me this problem among the Access Class Objects in the VBA view. There is no code in it, but I cant delete it either. When I click on it, I get...

I added another table and connected ( put a join line) to the already existing table from which I take the information for the crosstab. Should I change this? Stacey

No, it does not compile. I get the message about the form being misspelled or not existing. After a few "OK"-clicks, i get the message Module not found. I wouldn't know where to put a break point. It does it with everything I click that has a VBA-stuff behind it. I tried finding where in the...

Hi, I keep getting a "Module not found"-error when I click anything on my Main form. It used to work just fine until I deleted a couple of other forms that I wasn't using anymore. Apparently, in VBA it still exists (How is this possible??!!) and VBA keep referring repeatedly to this particular...

Hi, Ive been through several of these threads, but I still cant figure this out. I have a crosstab query in which I would like to put a criteria. I understood that I have to use parameters for this. But, the restriction I would like to impose on my crosstab query is not directly,but indirectly...

Im not sure if Im running a query in VBA. Im using VBA to perform certain calculations. How do I implement the .execute method?

Thank you.. I will try it out later..

Hi, Im working on a database that has to be shared by 3 or 4 users. In on of the actions that the database performs, it has to delete records from a table first. When sharing the database, it always asks the users (using access viewer) whether 'they are sure that the want to delete the...