I have a subform linked to a form. I have set the Order By property of the sub form to dteDate but when I load them up together the form refuses to order by dteDate. I have also tried setting the Order By property of the form with no success.
I have an autonumber field in the sub form. Could...
In my reports menu I need to print a report of all items in a combo box - The combo box reads:
SELECT tblName.szName FROM tblName UNION SELECT "(All)" FROM tblName;
This brings up "All" at the top of the combo box but the report has no data. Is my query the problem or do I need more code to...
When I delete a record I get one message box (The one I have programed in) and once I click ok another one pops up telling me that I am "about to delete a record, am I sure?" How do I get rid of the second one. Any help would be much appreciated.
In the form close event I need to determine if a form is loaded and it it is I need to update the combo box using requery. I have an Access database in front of me that has used the IsObjectLoaded method in the form close event but when I run it in my database Access gives me an error message...
Can somebody please tell me if they know how to change the search field of a combo box by using optoin buttons. For example: To enable a search combo box to search by project number and by project name
Set your limit to list property to No.
The relationships have duplicated becouse you have re-linked your tables. You need to delete these extra links (eg:TableName1, Tablename2) and just keep your original linked tables. If the link was not done correctly the first time round then re-link...
The back end of the databse resides on a server while the front ends are on the client pc`s. What code do I use to ensure the Front end sees the back end and where do I put the code