Search results for query: *

Hi Using northwind as an example, how would I build a query to return Customers with a related contact named Jane, AND and a related contact named John? ie, I only want to return customers that have both a Jane and a John contact related to them. I tried using AND but it returns no records...

Hi, I develop stock control databases in Access for around 12 customers. A recent Microsoft update has caused a problem for form with ActiveX ListView controls in them. When any event associated with the list fires, an error occurs. Most people got this update on 15th August. It was an update...

Hi I want to resize some columns in a listBox in code. The form is set to sizable and the listBox anchor settings are such that the listbox grows with the form. There are three columns, two of which I want to remain as fixed widths and one should grow when the listbox does. So the simple...

Hi, I've been scathing my head because a function that returns a Double has been giving me a strange result. I have realised it's VBA and not my function which is at fault. Can someone tell me why when you type... ?CDbl(110.4) - CDbl(110) into the intermediate window the result is...

Hi, When I maximise a report in Access 2007 the restore and minimise buttons disappear. In previous versions these controls used to jump to just under the main Access window's min/max/restore controls (which confused users here but were at least present) Now when I maximise the report, there...

Hi Is it possible to set which field a report is grouped on in the report module code? I have a report generator form which the user selects various filters to view a report of Customers. I want to be able to set the grouping of the report based on the users filter selection. In other words...

Hi, I want to return sales figures for all companies or companies outside of the UK based on the value of a checkbox in a form. I cannot get the IIF statement in the criteria row of the query to work… This is the code string I entered…...

Hi, Can someone point me in the right direction here... I have written many Access applications and need to stop the end user simply copying the files and using the databases at another company. I need some kind of Licensing system but I'm not sure where to start. ??? I solved this with a...

Hi, I have a table containing part entries for a part. Each part entry has a percentage and I want to issue a warning when the sum of percentages for a part exceeds 100. The data type for the percentage field is Double. The problem is that I have entered 2 parts and several part entries for...

Hi, Can someone help me with some SQL I have a form with a listbox showing parts in a database. I have several combo boxes allowing the user to select various criteria to drill down to the part he wants. I have two tables (tPart and tPartDesc) tPart holds details of a part in the database...

Hi, I need to show some information at the very bottom of the last page on a report... If you want something on a report to appear at the bottom of the page you have to use the page footer because using the report footer just places it at the end of the last detail on the report which could be...

Hi, I have an access 2003 app with many forms displaying data in listboxes. There are several places where saving a record in one form needs to refresh the lists in other open forms. I currently do this by calling a public sub which takes the form and listbox name then calls the listbox's...

Hi, I have an access 2003 form with a ListView Control (MSComctlLib.ListViewCtrl.2) I can trap the user selecting a row in the list using the click event. I am trying to trap when a user uses the arrow up and down keys which change the selected item in the list. I have tried afterUpdate and...

Hi, I have a listview control in an Access 2003 form. When the list is populated from code, the SelectedItem is always the first item in the list. How can I deselect the listview so no items are selected. I have tried lstView.SelectedItems.Clear which is the .net way but in access an error...

Hi I have a windows form showing a customer enquiry. There is a DGV showing each entry for this enquiry. When the user deletes an entry, I need to loop through each record in the entry table and renumber the "itemNumber" field so they remain consecutive. The item number field is not displayed...

Hi, I am writting a windows forms application which has many forms. Is there a way in VS 2005 to debug a specific form without having to start at the startup form and drill down through the program to find the form I want to test?

Hi, I am new to Flash 8 and am developing flash slide presentation. I have used behaviors to give fade in/out effects. What I need is to have a 5 second delay then move to the next slide. I don't want any user interaction, just an automatic slide show. Is there a way to do this without a...

Hi, I have some bound textboxes and checkboxes on a tab control on a form. When I first open the form, the controls on any tab pages not showing cannot be refered to. When I click the page they are on, everything is fine. Also, if I click the page they are on then go to another page, I can...

Hi I am designing an RDLC report in vb.net 2005. I need to do a calculation using the current VAT rate which is defined in my.settings of the application (so the user can change it when necessary). How can I refer to this setting value from a report?

Hi, I have a DGV which when double clicked opens the selected record. The problem is that the double click event fires when you double click the column divider to auto size it. I need to separate the DGV double click event from the Column divider double click event so the user can auto size...