Search results for query: *

Hi there, My autonumber is not used as a foreign key in another table. I followed your suggestion and it does not work. It appears that autonumber is assigned randomly and not based on an order. Any suggestions? Thanks.

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

I meant relinking. You did not read my entire thread. Selecting All and CheckMarking "Alwasy Prompt for a new Location" does not work. I would appreicate an answer who has the same problem. Thanks.

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

are you saying that an Operator table should be linked to my main form table. If so how, a one to many relationship or what?

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

i have windows xp does anyone know how to permanetly change the bar's colors for two data value (Open, Closed) from default to a choice color

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, I do not know what is wrong with this "where clause" Private Sub cmdEWOByProcessStep_Click() On Error GoTo Err_cmdEWOByProcessStep_Click Dim stDocName As String stDocName = "rptEWOReport" DoCmd.OpenReport stDocName, acPreview, , (((tblEWO.ProcessStep) =...

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.

Thanks.

Hi there, I don't want to open the report. I want to print it automatically. I don't want to open the report and then click on File -> Print. I want to have the same function as the Print Report of Visual Basic. You click on the button and then it will automatically print the report without...

Hi there, Thank you very much for your answer. However, you fogot to answer my last question. How do you print all reports at once. I have created indiviual buttons for each report and when I click on each one. It will print the report automatically. 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...