Recent content by smiler

Now the problem has gone from bad to worse. When I try to open the Access file, the login form cannot even come up. All i get is the same error message: Error in loading DLL. I manage to get to the code window and removed the code i added earlier but still the error persist. I hope you can help...

Hi friends, I have a small Access 2007 database application for storing record of patients at a small health center. I have been using it for sometime and wish to include a search functionality to it. After adding the new lines of code the application now behaves strangely when the search button...

Hi All, As part of an Access Database project I am working on right now, there is an urgent need for some of the data to be exported to excel. The data is already in Access tables and I already have select queries which brings up the data. Because the data from the queries will be analyzed with...

Hi all, I have a subreport which gets data from a select query in my database. And the main report for this subreport has a button which i want the user to click to print (output) to a printer connector to my PC. I have tried Access 2007 help menu but all i get is how to print by selecting print...

Hi Friends, I am having a problem with a Select query in Access 2007. In my database application in Access 2007, the select query is bound to a subform and I want the query to bring out records with the field in the WHERE clause equal to a module-level variable i have defined in VB code. eg...

Hi All, I am currently working on Access Database Management project and all the problem i am facing is how to read sample data from Excel files. The Data has already been entered into Excel sheets and if it is possible programmatically(write VB code) open the excel file and read the data from...

Yes, the program is intended to work on several computers with varying resolutions by the end users. i have been able to get my code to return the current screen resolution. Please can you tell me more about setting the width of the forms especially if i can set it by percentage like 15% so that...

Thank you for the reply. Yes, the other forms vary in both height and width. I presume it is difficult that way but if i could only get all the other forms to be positioned at the right edge of the menu buttons on the main form, then i will make do with it. I hope you understand what i mean...

Hi there, do you want to remove(delete) duplicate records or select distinct records based on the News field? For selecting distinct records, you can try a query like: SELECT DISTINCT TRIM(table_name.News) FROM table_name;where table_name is your table. As for distinguishing by date, you can...

Hi there, i'm new to this forum and this is my first post. I am currently working on an Access project which has a main form with dedicated buttons aligned to the left as in Ms Outlook. Based on the menu button(aligned left) clicked, a modal form will come up for the user(whiles the main form...