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

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

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

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

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

Hi, In my database im using several union queries as they turn out to be very useful. However, whenever I have a calculation that involves one of the union queries, things happen at a very slow pace. Is there a way to speed it up a bit? Thank you Stacey

Hi, I have a form based on a query. In this query I sorted the columns year and month in a chronological order. However, on the form this does not appear that way on the form. How can I enforce this? Thank you Stacey

Hi, Im trying to import a spreadsheet from Excel. I use the wizard and I get the sheet imported. The only problem is that I get additional blank fields in my table in Access. How can I make sure that this does not happen? I want to keep on importing into the same table, so these useless empty...

I have the following table: YieldID |ProductID | Year | Month| Yield I want to make sure that it is not possible to insert the same date (so, year and month together) twice for each productID. But at the other hand, it should be possible to insert the same date but then for different...

Hi everybody, There is a chance that I might be overlooking a simple way to solve this, so any suggestions I would appreciate. I'm working on a database and since it's my first database, I did not follow the first design and afterwards put your information in. This is the situation: I...

Hi, Im copying information from Excel to Acces. As I enter the information in fields in Access, this goes just fine. The problem is that sometimes I have to change the information I put in. So for example I first copied 10 record(cells), but now I discover that I have 20 records/cells. But...

I accidently deleted the swithboard from the "forms"-area. I know it is still there, coz when I got to Database utilities|Switchboard Manager I can still see it. How can I get it back in the "forms area" Thank u.. Stacey

HI, I have an input form on which I have a combobox. The user can choose from the list of products. However, I want to use this input in a code and I need the productid to work with in the code. How can I arrange it that when the user selects, they can see the name of the product and the id...

Hi, I have a query in which I have rates a period of time for several companies. However, these rates can be in different currencies depending on the company. So, I created a a couple ( the number of queries depends on the amount of different currencies) of queries to convert all the rates in...

Hello.. In one of my tables I have a field with the following characteristics: Listbox row source: SELECT Category.CategoryID, Category.Category FROM Category ORDER BY Category.CategoryID; row source type: table/query bound column:2 column count: 2 This gives the user the opportunity to see...