Search results

I attached a simple version of my problem in MS Access 2003 format. If you open the 'Test' form you will see 2 controls. One is the 'Groups' subform and the other is a Combo box that looks up the group name. They are not connected. If I look in the combo box I see x number of entries. If I then...

Thanks but I had already tried that. Does not work. I will keep trying. Sam

I have a form with an unbound combo box that uses a query to look up values in a table. On the same form I have the same table as a subform. When I initially open the form and add a new entry to the subform it does show in the combo box. But if I open the combo box first to look at the list...

In most cases you would create a table for any information that will repeat in records. Catergories and sub-categories are examples. Sam

I am not sure what you are trying to accomplish with your code, but if you create a standard Access report in preview mode you can then choose File\Save As and then choose Excel as a file type, give it a name and it will save in Excel format. Sam

What do you mean "List Style"? In any case, if you have designed a form that displays the data the way you like then go to tools\startup and you can choose any form to start when the database starts. Sam

Could you tell me the reason you need to search the previous row? I ask because depending on what it is you are trying to do there may be a better way. In any case I do not have the answer to the question as you lay it out. Sam

Bring in all your fields into a query and then in a new query column type the following: Test:IIf(Val(EmployeeID)=searchID,"Same","Different") Hope this works for you. Sam

If you are asking if it is possible to add in the rest of your expression, I do not see why not. Are you saying you tried it and it did not work? Sam

Yes, the default value is for new records only. It does no affect old records. Sam

You said: One last question. The final 2 steps I took in calculating the Retail Price was SUM(ROUNDUP([RETAIL PRICE],-0.1)-0.05). I did not understand the question?

I aploogize. When I went in to try it I remebered that it is not that simple. You must click on the sum symbol on the top menu (looks like a "M" on its side). A new row called the Total row will appear. Type in the same expression in the MyCalc: I mentioned earlier and then click on the Totals...

I can not say what may be the problem but I can suggest a way of preventing changes assuming they are accidental. Remove the Autonumber and key if you have one in the table. Then make the 'Service Year', 'Service Name' and 'Service' all KEY fields. This is a unique key for your records and...

What I mean by linked fields is that usually you would (as an example) have a seperate table for your seasons linked to the main form with a seasonID. Normally you would not store the text of each season in the main table.

How many of these fields are linked? And do you know if the actual tables are changed or is it possible you just see it that way through the form. If possible, upload a stripped down version of your db so we can have a look. Sam

Neil is correct and the reasons are many but an example might be in order. Let us say for whatever reason we have two tables. On table is 'Doctors from hospital A and the other is a table of Doctors from hospital B. Someone may ask the programmer for a list of all the doctors from the 2...

The first question is why are you storing numbers in a Memo field?.. And if there is no good reason you might want to go into the tables and change its field type into 'number'. If there is a good reason you could do the following: Select sum (Val(amt1)+Val(amt2)) as tot from employee group by...

One other thing. You must get rid of the Autonumber. If you don't then all the key fields will never be unique. Sam

Just make all the fields you wish to include a 'key' field. Access will then prevent you from entering any data where any record has these fields the same as any other. Sam

Just a guess but it would seem to me that you have an automatic Macro running every time you open access. Look in the Module section or Macro section for code you do not recognize. Or, look under 'Tools\Startup' and see if anything is set to run when you open this. Sam