Search results for query: *

Hi there, I have an autonumber field that obviously is unique for each record. My records also have a date field. I would like to rearrange the AUTONUMBER field so that it correspond to my records that are in chronological order. I tried to delete autonumber field and reinsterting it in the...

Hi there, We have two copies of backend for our database. We would like to switch back and forth between two. Linked table manager does not allow linked tables to be update all one once. Also, I can not delete all linked tables at once? How come is like that? When that happens, I would have...

Hi there, I would like to create a combo box that can retrieve existing one field data and be able to add data to it. Let's say i have a combo box that stores the data in "Operator" control source. I like to create the combo box so that it starts empty. Operators can enter their name but when...

Hi there, I have created a autoform with a pivot chart as a subform and have put it on a report with some control on a report. According Microsoft, this how you should do it. Now, I would like to modify the autoform pivot chart for ie by changing the color of each category of data, instead of...

Hi there, I have the following the DCount Function: =DCount("[EWOID]","rptEWOReport","[EWOStatus] = 'Open'") I would like to count the number of records that have their EWOStatus=Open on that report. The function give me #error Thanks.

Hi there, I have created a pivot chart as a subform and have placed on a report along with some other controls. When you open the report the subform is not updated. What is the code to requery the form and the query behind it. Thanks.

Hi there, I know that an auto number is a number that can increment by one everytime a new record is added. Let's say we have 100 records numbered from one to hundred. When we delete record #50, the auto number 50 will also be deleted. So we have record 49, 51 and so on. It makes sense that...

Hi there, I would like to know how to display a picture that is a OLE linked object on the form and then later print on the report. If you are an expert in Access, then you just create a table with OLE OBJECT FIELD and then a form with that field only. Try for yourself. How come it only...

Hi there, Is it possible for one report to be based on several queries? Suppose that you want to use the same report but want to filter the records based on what button the user clicks on? Thanks.

Hi there, How do you print the picture that is saved as "OLE linked" on the report? I would appreciate help from someone who has done this? Thanks.

I have an OLE object. Unfortunately, the picture does not show up on the form after it is inserted. Only a snapshot of a video showsup. I need to have the picture printed on my report. How would I do that? I would really appreciate someone who has done this? I have been referred to some sites...

Hi there, I have a report with some memo boxes. I created the report very nicely with rectangles and lines so that it looks like my old excel form. Now, here is the problem. I have some memo boxes that can expand and when they do they will screw up the layout of the report. All the controls...

Hi there, I have created 3 reports for printing based on a multi-tabbed form. I would like to print for ie, the first report for only one record. I have created a button that will open the first report but how do I print only the current record and not the rest. Also, could anyone please...

Hi there, My first question: Is it possible to link my access form to an excel form (keeping in mind that access has combo boxes, check box, etc whereas excel does not have it). If so how please? If not possible, is it possible to create a report based on a multi-tabbed access form (it is...

Hi there, I don't understand why linking two combo boxes is so complicated. Here is my table called "tblDemo" PK Reason1 Reason2 Reason3 1 Soccer Goalie Lack of training 2 Soccer Goalie AB 3 Soccer Forward AC 4 FootballMidfielder AD 5 Football Midfielder AB 6 Football Defender AB 7 Baseball...

Hi there, I would like to implement three combo boxes that are linked together. You have a list of items for first combo box and the second combo box's list is based on the first combo box and the third combo box's list will be based on the second combo box. The only problem that I have is...

Hi there, How to export a pivot chart generated by a report to an excel file? Then, I would like to change the color of each individual bars in the graph. Thanks.

I have a report with a field called [product], I would like to know how many times a product changes from one to another. This is different from how many different products there are. Could someone be kind and provide a sample code? thanks alot

I have created a tab control with several pages in a form and whenever I open the form I don't see the pages because it is going to first text field control. How would I make sure that whenever the form is opened or a new record is created the vertical scroll bar is all the way to top so that I...

I have a report with a field called [product], I would like to know how many times a product changes from one to another. This is different from how many different products there are. Could someone be kind and provide a sample code? thanks alot