Search results

Hi, See example attached

The solution I gave will only return records where C, D and E are all present and match. If only one set of records has been populated then they will not be included. To return records where C, D and E have been filled out in one or other or both tables will require simulating a full outer...

Hi Paul, I think others are right to point out using an update query. You can still call the update in exactly the same way as opening a form, unless I have misunderstood. You have a table called Customers and I assume a field called something like InceptionDate. You can work out how many...

Hi, Apparently this can be caused by the settings for the Excel Jet engine. Open the registry editor (goto Run on the Start Menu and type "regedit.exe"). Locate the following registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel\ Find "TypeGuessRows" and change it's...

Hi, The error you have described appears when you do not have the same data type on each side of the join. For example you can't join a number and text together. I assumed given that fields C, D and E are foreign keys that they have one of these data types: - autonumber - number (long integer)...

Hi, It is difficult to diagnose the problem without a bit more information about how the form works. Try entering the following SQL into a new query. Does this return a number greater than zero? SELECT COUNT(*) FROM T_SOHeader WHERE SODate = #09/04/2012# AND [CustomerName] = 'ABC Project...

Hi, It is certainly possible to display an excel spreadsheet directly on an Access report using an unbound object frame. Have a look at this web page from the Microsoft Knowledge Base. It describes how to programatically link an object on a form, and uses a spreadsheet as the example. Although...

Hi, To display the results of your query on the form you will need to create a control (textbox, comobobox, checkbox etc) for each field in your query. Then you need to change the "Control Source" for each control by selecting the appropriate field name. From VBA you can get the value of the...

What is the error you are receiving when trying to update your table? The example I gave for updating the table uses DAO, perhaps ADO would be more successful. Also it might help if you could post a sample of the code where you are getting the error. Without a bit more information it is hard...

Hi, I understand. You can add another listbox to the form with each language option based on your languages table. As an example the selection criteria for your subform will now need to be something like this: (classID=2 OR classID=3 OR classID=6) AND (languageID=1 or languageID=2) The...

Hi, You can match using the Employee Name, but there is no need. By using text rather than a numerical index you will make the matching process slower. You're welcome for the help

If you use the results of the query as the bound recordset of your form, you can lay out the controls however you want.

Hi, You could create a new table in the database with the same field names, and an additional field for your autonumber ID. Then convert your existing query into an append query and associate each field in your query with the corresponding field in the table. The autonumber field will be...

Which fields are you looking to update, can you give me the table and the field names?

Hi, Firstly I would recommend you have a look at this tutorial, which explains the basics about update queries. http://www.databasedev.co.uk/update_query.html I'll have a look at your code and update this post in a minute with the code necessary to convert your existing SELECT query.

Is it possible that the customer name contains a single quotation mark? Unless it was escaped Access would interpret this as the end of the string and you would not get a match. Beyond that it is not obvious what is causing the problem. Could you try posting a small sample of the table...

Hi, My download corrupted - I have got it working. I've added a new form called frmSelectEmployee. Have a look and let me know if anything doesn't make sense! ;)

That would make sense. Glad you resolved the problem :)

Hi, Sorry, I forgot to say it needs to be in 2007 format - sadly I don't have Access 2010 yet :(

Hi, The example I gave will allow you to select an employee, and then return the results on the Hours subform that relate to that employee. It would be easy to further filter the results on the subform using a date. If you have a bound main form with results for one employee, and then display...