Search results

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...

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...

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...

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...

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...

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 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...

I managed to fill a combobox through code: cbo.AddItem rs.Fieds("field") Problem I have now is that I need to have 4 columns, the code above will only give requested field. If I use & sign it will add the fiels, however in the same column. How can assign fields to a specific column? Thanks...

I want to fill a combobox from a recordset. I building the required records in a recordset. Now I need to get the data in the combobox. I know the AddItem method, but do not know how to use this with a recordset. Dirk

I have problems with the line below in my Dbase: Set rst = CurrentDb.OpenRecordset("SELECT * FROM tbl_BA_Deb WHERE Debiteurennummer = " & Me.cboDebiteurennummer & " ORDER BY Debiteurennummer", dbOpenDynaset) Every time I open de combobox and select a customer, it comes with the error 91...

I have to make changes to an existing Dbase. Problem is that in this Dbase it is on one form possible to put text in a numerical field. I need to do this again, however it does not work, Access gives the message that Text will not go in a numerical field. I am talking about a combobox. What...