Search results

Good afternoon, I am currently working on a project in access 2010 and I am having a search for record dilemma. I have a main form that has a subform in it under a tab control. I place a search box at the top of the form so that user could select either the ID, the internal case number...

Good morning any and everyone, I am in need of some very detailed/step by step assistance and fixing my append/update query. To start I know it is a shame on me moment for using a multi-valued fields because it is a known problem child, but it was a mjor request by my co-workers in the review...

Good morning, I am trying to create a macro to search for selected quarters and entered years. I have a form that asked for quarters and years, in the section quarters there is a combo box that list Q1, Q2, Q3, and Q4 in which the users have to select from. And then there is a textbox that...

Good morning, I am currently working on a project that is almost complete, but my only problem is that I am clueless as to how I can get a text box in my report to hide base on if a text box in my form is hidden. Meaning that whenever this particular text box in my form is hidden then the text...

Good afternoon everyone, I have hopefully really simple and quick question, is it possible to create a query that will delete the fields within a table? Thanks,

Good afternoon, I using access 2010 and I am trying to code (VBA) one of my combo box to auto select if another combo box consist of multiple selections. So for example I have a multi select combo box that has a list of departments and based on what the user selects I want the other combo box...

Good afternoon, I am using Access 2010 and I have a quick question and hopefully an easy solution for coding a dropdown selection. I currently have a form that has a checkbox and a dropdown selection. I am trying to code for the checkbox, anytime any of the selection where if it is one or all...

Good afternoon, I have a query that is counting perfectly like I want, but I need to sum the overall total of that count. How do I sum a count in SQL? Thanks,

Good morning, I am working on a project that is requiring me to hide a subreport that happens to be chart graph, when the chart has no data and my problem is that I cannot seem to get the report to properly hide and show the label behind it when the data is not there. I am in need of a SQL...

Good morning, I am using Access 2010 and I am having a slight problem with one of my reports chart. I have a record source that is feeding the chart, but my problem is that when there is no data to read it is still "showing" data set which is actually a blank row. I figure if Iuse the Nz...

Good morning, I am really lost on how to solve this problem, I have a form that has four textboxes, date dropdown box and a date box. I am trying to get the form to do the following: Block user from writing in the textboxes if they have not selected a date in the date box. Get the datebox to...

Good afternoon, I have a report that displays maybe about 4 columns that read data and if a columns reads zero then I have a code where it will hide, but my problem is that I cannot get the columns to move over once the column that is zero is invisible. Can some please help with a VBA code...

Good afternoon everyone, I am currently using access 2010 and I have been wrecking my brain :banghead: to figure out how to display message in place of my charts when there is no data. Currently, whenever the chart has no data to display it just shows a white blank space. I would like to...

GM, any and everyone.....I am new to access 2010 and I am trying to write a required data macro. Meaning that based on a user selection of one field then the form will allow the user to contiune in filling out the form or a pop up message will block that user because they have selected the...

GM! My name is Deena and I am new to the MS Access community. I live in Chicago, Illinois and I cannot wait to see what all interesting tips and tricks everyone can show and tell me. Jut so you know I am currently using access 2010.;)