Search results for query: *

Hello there, I am working on an application that uses some JetSQl queries in runtime. Now I am developing on my laptop (XP vista Home) when the live environment uses windows XP through a Citrix environment. The following queries does work on my laptop but does not work on the network. hSQL =...

Goodafternoon, I've got a table with 5 fields, lets say fields A,B,C,D,E. The table is filled from different sources (imports, VBA created info etc. etc.). After the fill (or during) I want that each combination of A and B occurs only one time. What is easiest? 1) Make a query with the...

goodmorning, I've got several columns in my listbox. Now I was wondering whether it was possible to have an alternative markup for the results in a specific column. Like another color or just underlining. So, i.e. columns 1,2,3 just plain en column 4 bold. The reason I want to do this is dat...

Hello there, I've got (again) a small and fairly simple question. In runtime it is possible in my form to enter ctrl+F. Can I disable this? No, a screen with Find/Replace appears. Note: I do have some key down events and I do not want them to be surpressed. reagards,

Hello there, I've got a small question and maybe you could help me. I am using a listbox to show the result of a query. By pressing some labels you can sort the query on the field you like. Problem: When I try to sort the field with links (field type = Hyperlink) the query does not sort the...

Hello guys, I am having trouble with the TransferSpreadsheet Method. I worked fine but for a reason unknown for me now I getting the following error message: Runtime error 3274 - External table is not in the expected format. The code that raises the error is: DoCmd.TransferSpreadsheet...

Hello over there, I am writing an Access application and, of course, during the process all kinds of errors occur. The problem is now that after an error has occured (and the system has entered break-mode) I want to stop the code and improve it. Now after pressing the 'STOP' button in the...

Hello, See the above known problem. I know why it occurs and how to prevent it manually. If you export a table from the database window and point out that the format should be "Excel 97-2002" then the whole memofield is copied to excel. No problems here. However, I want it do programmatically...

Hello there, I've build a query and I passed that query to a record set, like this: dim strSQL as string dim rs as DAO.Recordset strSQL = "SELECT ..... bla bla" set rs = currentdb.openrecordset(strSQL) I do some modifications in the record set (remove some records) and afterwards I want to...

Hello there, I've got a small and simple question about the database object in Microsoft Access. I am using the DAO objectmodel. The structure of procedures with data changes is as follows: set db = currrentDb set rs = db.openrecordset(tablename): rs.index = "PrimaryKey" .... .... rs.close...

Hello there, I've got a simple question. What is the most easiest way in VBA to check whether a certain workbook is open without opening the workbook? Any help appreciated. Regards,

Hello there, I've got a Access2003 database in which you can browse using a listbox. The listbox shows 5 items of a particular query. In this listbox one of the items is a link. This can be a link to the internet or some place on the network. Now I want to be the link clickable. And internet...

Goodmorning, I was working with a Access2003 database on a laptop. The database might have been open at the moment the battery was empty and the application might have been closed immediately. Any way, it was quit while the database was probably open. When I reopen the database the systems...

Goodmorning, I've got a small question and I am quite sure that you will be able to help me. I've got a listbox filled by a Query. Something like this: listTest.rowType = "Table/Query" listTest.rowsource = testSQL Q: What is the easiest way to get the whole listbox in a 2 dimensional array? I...

Goodmorning, I am trying to use a worksheetfunction in VBA to win some time. I want to use the MATCH function to retrieve the row in which a certain item is stored. In this case I don't have to loop through an array. Function finditem(dataItem) Dim row DD as variant rowDD =...

Hello there, I've installed the Microsoft Tool Remove Hidden Data. It is quite handy, here is the Link Question: After removing the hidden data the document opens read only. Is there a way to prevent this. I want the cleaned document opened normally. Any help appreciated. Thanks,

Hello there Office Specialist, As I know now (see previous posts of mine) that if Word opens a document that it always tries to open the original template of it. The search for the template can take a while so that opening the document goes not smoothly. For new documents to solution is not so...

Hello there (again), I am still struggling with the templates (see my previous post). During my extensive testing I noticed something rather strange. Let me explain. In my view there are basically two ways of opening a template: 1) Browsing your environment with your explorer and...

[This post was also posted in Microsoft Office] Hello there, I am trying to solve a problem with some Microsoft Word documents which are the result of the standard templates of the company . The problem in short is that whenever the documents are opened outside our environment it takes...

Hello there, I am trying to solve a problem with some Microsoft Word documents which are the result of the standard templates of the company . The problem in short is that whenever the documents are opened outside our environment it takes unacceptable long to do so. I was wondering whether...