Search results

I did not write de .mdb myself. It is in principal not a complicated Database. De database starts up with a switchboard. I checked the VBA modules, but there is nothing strange with it. I do not understand why on one system it works fine and on another system it does not, that is why I think it...

I created an access runtime from a access .mdb database. I installed this on my laptop and it worked fine. However it is intended for my collegue, I installed it on his desktop computer. Problem is it did not work here...! Both laptop and desktop run Windows XP and I uninstalled the Office...

Sorry, did everything you say, but it will not show the content of my PDF file. If I try to do a new (in stead of use file), it tells me that a OLE sourceprogram is possibly not registered. Install OLE sourceprogram again to register the sourceprogram. But I have no clou what to install here...

Hi, I already tried that, but it only shows a white box with the PDF icon in it. But it does not show the PDF file itself. It also does not give a message that something is wrong. If I look in properties of the object I do not see where the path to the file is. Please give some more help...

I want to show a PDF file on a report like it is possible with .JPG file. So in stead of using .jpg files we want to use .pdf files. I tried some OLE objects but could not make it work. My question is, is it possible to do and if so, how? Thanks in advance, Dirk

I have table with information fields which belongs to images stored on the network. So in my table I also have a field with the path to each image. At this moment we display every record in single modus, but if you look for a specified image, it is hard to search. Now I want to display the...

I have created a listbox with customer data. This listbox I filter with a textbox for each column. In the customer name fields we have names like 't Gouwe or "De Hoek". I can filter on a lot of characters but not on the ' and the ". I think that this has to do with the functionality of these...

I am using a listbox to get a nice overview of my data. The listbox is populated by a qeury. One of the columns holds currency values. Now I need to have this column aligned right. How can I do this? Searching on the Internet it looks like there is no easy way to do this. So I hope that somebody...

Thanks, it was as easy as I expected. But in the Help of A2003 I could not find Zoom in relation to RunCommand. But it works fine. Thanks, Dirk

Normally I open reports at Maximise View, with DoCmd.Maximise in the Open event of the report. Now I get request to open the report at a larger view. I am looking for some time now but can not find out how to set the view option to 150%. There are some commands like snapZoomToFit, but there is...

Hi Dan, Sorry for the late reply. Thanks, it works fine. Dirk

I would like to control the output on a report by the form. I would like to highlight an report item (through put a border around a lable) when an checkbox is checked on the form the report is called from. Problem I encouter is that I can not change format properties of report items as with...

Listview and Checkbox. I am a bit further but not there yet. The IIF command does not work, because I am using SQL server for the data. Looking on the Internet I need to use a CASE expression, however I can nog get this in without error messages. I try to apply this in the Query screen of...

Listview and Checkbox. Thanks for your reply. I understand what your solution does, however I do not know where I have to put it in this line. Please tell mee where to put in this line. Thanks, Dirk

I have a field in my table which is a bit field (True/False), I set the view option to checkbox, this is shown in my table. I use this table to make a query and also here I see the checkbox. Now I am populating a listbox with this query. This field is not shown as a checkbox but I get the text...

I have solved the problem. Dirk

On a report I want to add a value through VBA. However Access does not allow me to add a value to an object. Mine report is based on a table, however I need some information from another table, so I want to use a SELECT statement to get this information and then add the value to a textbox on the...

I use this Sub to fill a listbox. But only those records must be in, which are not chosen already (present in the DocKeuze recordset). I thought that this was a nice solution. The problem is that the Dbase is SQL Server, and this Dbase does not know the NOT IN command, otherwise I could do it...

Thanks for your anwers, however does not work either. It seems that if this recordset has one record the EOF is true. However if the recordset has two or more records, the loop runs, however the first record is not checked in my equation, only from record two and further is visible. Another...

I am opening a recordset and want to run through the records to check for a specific value. Problem is I open the recordset (use ADO), Move to the first record (display the record to see if there is something in it) then go into the loop with DO UNTIL rst.EOF..., however this loop is not ran...