Search results

Hi, How do i create a dynamic query to query a crosstab query. I want my query to look like the one here: http://www.access-programmers.co.uk/forums/showthread.php?t=188663

Hi, I would like to close the page with all its frames by clicking a button in one of the frames and redirect me to another html page. How can i do this. Thanx. joseph

Hi Simon, Thank you, I will try your solution. How about your second option, do you view them in a treeview? I actually store the image location on the main form and use: GetPictureDir = Forms![Menu]![Image Directory] joseph

Hi, I found a sample of a database that stores images in a sub folder located within the same directory as the mdb project file. The code is as follows: 'setup new file name and appropriate DB subfolder relativePath = "\Persons_Images\" dbPath =...

Then we shall shift the post. Thanx. joseph

Hi Brighton, Thanx alot. It worked. joseph

Hi, How can i add a number of years (eg. 55) to the date of birth (eg. 28/08/1973) so that i can end up with a new year (eg. 28/08/2028) in another field? I am attempting to calculate the date of retirement. Regards. joseph

Hi Beetle, Thanxs alot. I have attached a copy. My intention is to link a subform whose record source will be based on the crosstab quiry and link it to the form Form1. I will appreciate your advise. Regards. joseph

I appreciate your response and advice. Could you kindly have a look at my table structures and relashionship and advise further. Thank you. joseph

I am creating a personnel database. The personnel are often transferred from one office to another in different divisions around the country. In the personnel details form, I have a subform with two cascaded combo boxes that for selecting Divisions and office of transfer, respectively. This...

Hi Gemmar, I tried in the on current event, but the second form did not open: DoCmd.OpenForm "F_Wanted_Persons_Images"

Hi, I have the OpenForm command in the main form that automatically opens second form when opened. However, the second form appears to open before the main form opens. I also tried to use the On time event but the flickering on the second form at a timer interval of 1000 is disturbing. How...

Hi Brighton, It worked! Thanx alot. Stay well

Hi, Please, how can I use the filteron property on a list box? I want to filter a listbox named "lstPersons" in a form "F_Wanted_Menu" based on what is typed in in a textbox on the same form. Initially, this worked well with a continuous form, which I have decided to replace with a list box...

I would like to have a textbox where I type the name of the image and locate that image in the browser control. Thanx Jdraw

Hi, Does anyone know where I can get a very simple basic image viewer with option or facility to enter descriptions of the images. Something similar to the standard windows image viewer. I will appreciate. joseph

Hi all, I am trying to adopt the web browser control here http://www.access-programmers.co.uk/forums/showthread.php?t=186183&highlight=multiple+images+in+form into my application. I am just wondering if there could be a way to filter images displayed in the control on the form. I will...

Thank you jonathan.

There was a mismatch error again

You are right JANR. The text value is the second column of my cboVenue. Control source: CountryID Row Source: SELECT [T_Countries].[CountryID], [T_Countries].[Country] FROM T_Countries; Private Sub Form_BeforeInsert(Cancel As Integer) Dim strWhere As String strWhere = "[Programme Name] =...