Search results

I can happily help you implement the search form, but it would help if you could provide some more details first. At the moment it is impossible to tell what is causing the error. 1. What are you using to return the search results. Is it a listbox, continuous form, other? 2. What is the record...

Hi, There are lots of ways of displaying the data, but here are 2 examples: The first (and simplest) one is to scrap the combobox, and have the main form and subform linked by your employee ID (EmpID). This way the subform should be automatically populated without the need for any programming...

Hi, I do not have any experience of this but may have spotted the problem. You currently have the following setup: Level 1: Key:="Cat=" & CStr(rst!VendorID) Level 2: Key:="PracticeName=" & CStr(rst!AppID) Relative:="Cat=" & CStr(rst!VendorID) So the relative of level 2 is the same as the...

Hi, As this is something many people want to do there are lots of useful references on-line (including on this forum!). As a starting point you could do far worse than take a look at this link, from Allen Browne: http://allenbrowne.com/ser-62.html

Hi, It would help if you could give some more information about your underlying data. What is the record source for your main form and the subform. What are the fields that you want to display a) on your main form, and b) on the subform?

Hi, Rather than grouping by the "last name" you could group the report on the primary key, and just display the name on the form. You could then add a sort to order the report by the last name. I think the key is in your initial post - you are "grouping on the last name" and therefore all like...

Hi, Please note: code below is untested! The problem you are having is that you need to add the new value to the table that underlies your combobox. One possible solution is to use an append query to add the desired value into the table. Save this query as "qryAddNewValue" and replace the...

Does this do what you want? SELECT Table1.A, Table1.B, Table1.C, Table1.D, Table2.F, Table2.G FROM Table1 INNER JOIN Table2 ON (Table1.C = Table2.C) AND (Table1.D = Table2.D) AND (Table1.E = Table2.E)

Hi, There doesn't appear to be a problem with your code. What have you set for the "Limit to list" property? Make sure this is set to true, because the "Not in list" event will only fire when this is the case.

Hi, It is possible that the form has corrupted, despite copying the objects over into a new file. One possible solution is to copy all the objects from your existing form onto a new one, then add the option group and see if your form will now save. You will need to copy over any VBA code...

Hi, You will need to provide some more information before anyone can answer your question. Firstly can you give some details about the query for your combobox, if possible post the full SQL code.

Hi, What version of the ADO library are you using. Is this the same on both computers?

Hi, I need a little bit more information to answer your question fully. Would it be possible to post the full SQL code for your listbox? For now you have two tables linked by the AEC reference number. By default the link will only display records if a valid record exists in both tables, and...

I think you need the field and form control for the customer name the other way round. Try this: = DCount("*", "[T_SOHeader]", "[SODate]=#" & Format([Forms]![F_SOHeader]![SODate], "dd/mm/yyyy") & "# and [CustomerName]='" & [Forms]![F_SOHeader]![Customername] & "'") For both the customername...

Hi, You shouldn't need another listbox if I have understood correctly. Just add another field in your main student table called PrimaryLangID (type - number, long integer). Now modify the relationships for the database and link tblLanguage.LangID to tblStudents.PrimaryLangID. Now modify...

Hi, I have made some simple modifications to the export code which will prevent the application from displaying until the data has transferred. It should also execute faster as it is not updating the screen with each iteration. Do you have students with multiple languages, or only 1...

Hi, It is quite possible this is not working because the date format is being altered by the code. VBA expects the date to be in the format mm/dd/yyyy (the American date format). When handling dates in VBA you either need to convert to this format, or one that is non ambiguous (say...

Hi, You have to do the same with the code that is used when there are no records selected. Here is how the code should be changed: Else strFilter = "tblClasses.ClassID=''" End If What is the other listbox you need? You can use two listboxes to select records on the subform, but the...

Hi, There are two approaches to this. One is to store the image in the database as an OLE object. Others may say different, but I would advise against this as they can cause your database to bloat. In a worst case scenario a 50 kB image can take up 1 MB in an Access database, because access...

Hi, When you say "my IDs are text" are you referring to the primary key of the table? As a general design principle it is best to keep the primary key of the table as a autonumber field, that will uniquely identify each record. When you link to another table (say between students and...