Search results

Hi, Is there a way to modify the function from the Roggers sample at http://www.rogersaccesslibrary.com/forum/topic84.html" in order to load images from the subfolder within the current project's location with the Applicant.CurrentProject.Path? I have an application with about one thousand...

Hi, See the attached sample of what I think you are looking for. I do not remember the author. There is a button on top of the form for you to browse to your photos location and after that all the images will load automatically in the Microsoft Web Browser control. I hope it helps. Stay well.

Thanx for the information. I will check them. Best regards. Joseph

Hi Ricyan, I tried your code and it works perfectly well. Thanx alot. Joseph

Hi, I am beginning to learn PHP and mySQL starting on a simple movies database. Data was loading okay from mySQL database in one of my PHP pages (select.php) with a SELECT statement until i included a few codes to query data through a form. What is happening now is that when I open this...

Hi, I am populating a table using combo boxes in a continuous form. The box box alone works fine without any issue of repeated data. But as you know obviously the combo box only populates data in a single column of the table, in which case mine is the LASTNAME; so now I am attempting to...

Hi again John, I tried your code. It does work but returns the image to its actual original size, not the preview size in the image control on form, which i want. Joseph

Hi John, I will try it. Thank you. Joseph

Hi, I am building a database for a local museum in Lusaka to manage art works images, following the idea by Lebans which allows one to zoomin and zoomout an image. ZoomIn: Dim intWidth As Integer Dim intHeight As Integer With Me![imageframe1] intWidth = .Width intHeight = .Height...

In than the attachment in my first post is a pivot chart. Although it showed me data per year i could not figure out how to group by quarter per year. Which is why i was tempted to go a different way. I hope somebody will have a good look and advise further. Thanx. Joseph

Hi, As a follow-up to my previously un-answered question, I have made some attempts but got stack along the way in the attached copy of my application. 1. There is a problem when I include a year field (calculated on the fly from the Incident_Date) in a query, because the year is also...

Hi Eugin, I got this in the immediate window: WHERE ([Incident_Date] Between #01/06/2012# AND #02/06/2012#) AND [TypeID] Like 2 AND [PurposeID] Like 4 I think your code is working. I will try to populate my database with more data and try to run as many queries and possible to be sure enough...

Hi, I have never created a chart report before. Now, I need to create a bar chart that will show the following information: 1. Number of "TYPE" recorded per quarter of each year (TYPE can be either "HUMAN TRAFFICKING" or "PEOPLE SMUGGLING") 2. A combo box for selecting a year to...

Hi, I have the following function which works well except when I want to run a search using date range and any other criteria on another text/listbox or combo box. This is work i get in the immediate window (Where Status, TypeID, PurposeID are the other criterias used with the date range.)...

Thank you. On debug, the immediate window return the following response: If i run query with only the value list (Active, Completed), I get correct results. But if I run query on the other two criteria (Type) , (Purpose), nothing is returned. The numbers 2 and 5 returned in the immediate window...

Hi, I am having a tough time figuring out what is wrong with my project on running queries with the SQL statements. The function is imported into my project from somewhere, modified a bit and now looks like this: Private Function BuildFilter() As Variant Dim varWhere As Variant Dim strField...

Thank you Bob once again for your unreserved help. Stay well. Joseph

Hi, I am trying to obtain totals from two columns in the list box into text boxes on the main form, but my third argument is not working as expected. The source of one of the tex boxes is: =DSum("Airtickets","T_Training_Participants.ProgrammeID=Me.lstParticipants")I want to sum only amounts...

Thanx Bob. Stay well. Joseph

Hi, How can I sum the amounts in the list box column and show the total on the main form? I will appreciate your help. Joseph