Search results

Please help! How do you set a checkbox in Excel sheet to True from Access? Thanks.

I haven't done Access programming for so long and I forget even the most basic thing on how to open a recordset in vba. I need to open a table and select certain records. Are there 2 ways to do that? Which way is better? How do you write codes to create and open a recordset? I'm using Access...

Hi, I created an ms access app in office 2003 that has 11.0 object library. When I gave it to my client, he had only 9.0 object library. He couldn't run the app. Is there a way to update his object library to 11.0 without too much trouble on his side. Thanks.

I have 44 checkboxes, each has a textbox next to it. What I want is when the user selects a checkbox, the textbox next to it will be enabled. Also, when the user unselect a checkbox, the textbox next to it will be disabled and any value entered is cleared. Another way is whenever the user...

I have a report that display those who are >=57 years old and has their (Age + Years of Service) >= 75 for any chosen year or years. The names are grouped by Department. Now I need to display a little summary that tell me how many employees are gonna retired in each YEAR for each DEPARTMENT...

I unchecked the ALLOW FULL MENU in start up dialog (don't want the user go to design mode). All my forms have print option under File menu, but my report only have Close and Exit option under File menu. How can I get my report to print when I want to. I know custom menu would do it, but then...

I'm using Access 97. I have a login form in Access. After the user enter his username and password, the LOGIN command button will connect to an ODBC in Oracle server and let him view all the Reports that I made in Access. I don't know how to write the code for setting up the connection...

My graph has its x-axis crosses at y = 0. When the data is around 0 or <0, I either couldn't see the x-values or the whole x-axis is above all the data points. How can I make the x-axis to always be below all the data points? Thanks for any help in advance.

I have a three-column list box that displays the search results. Is there a way to highlight the first row in list box by default? Thanks for any help in advance.

I have 3 forms: frmFIN, frmCM, and frmCL. They are all the same except that they are based on different queries (qryFIN, qryCM, and qryCL). Therefore, I want to reuse frmFIN and set the correct query as its Record Source based on the Field value of another form where I have a command button...

I have a command button on a form that has 2 subforms. What I need it to do is to load frmData (but not visible)where its Item_Skey = subform1.Item_Skey, Item_State = mainform.Item_State, and Reading_Type = subform2.Reading_Type. Then unload frmData and show frmGraph (OR show Graph then unload...

I'm using MS Access 97. Please help me with coding. I think the code should do this: 'SQL1 = frmItem.Item_ID, frmItem_State.Item_Skey, frmItem_State.Item_State, ' and frmTrace_List.Reading_Type_Code (Item is the main form, Item_State is subform1, and Trace_List is subform2)...

I have a search form (including a main and 2 subforms). The search works fine, except that when an item is not found, the form still display data of the previous search. How do you clear out the forms when an item is not found? Thanks for any help in advance.

I have a main form and 2 subforms. The output would look like this, MAIN FORM Item_ID: 1875A SUBFORM1 Item_Skey Item_STate Work_Center 400000 1 CM 400000 4 TL SUBFORM2 Reading_Type Work_Center Table Column GA CM tblCM_Dtl Trace...

I have a Search macro that search for records in a form after the user enters an Item_ID. It was like this: Action: GoToControl Argument: Control Name: [Item_ID] Action: FindRecord Argument: Find What: =[txtFinder] The whole thing works find except that when the Item_ID is not in the...

I have a Search macro that search for records in a form after the user enters an Item_ID. It was like this: Action: GoToControl Argument: Control Name: [Item_ID] Action: FindRecord Argument: Find What: =[txtFinder] The whole thing works find except that when the Item_ID is not in the...

I used a line chart for a Trace graph. I need to include its Upper and Lower limit for it, but I don't know how. I'm desperate for help.

I have a graph that is based on a table. After I close that graph, I want all the data in that table is deleted. So the next time I select a new item and view the graph, this table will contain the new data of the new selected item. Does any know how to do this? Any help would be appreciated.

I have an unbound text box and a Find command. If the user enter the ItemID and click Find, I want the subform to display data for that item. Does anyone know how to do this? I don't want to use combo box because the tblItem is forever long. Thanks for any help in advance.

I have a form and a subform. After the user choose a name and a date (using calendar control)in the main form, he needs to click refresh command button before filling any data in the subform. I have a combo box in the subform, and its list won't change unless the user clicking refresh. What if...