Search results for query: *

When reading the subject you're reflex could be "this is spam" its a access question .. I have a table with a few spanish words. I wondering how to write typical spanish character like ñ on mañana ? 1. how to write (copy pazte is perhaps the worste solution). 2. spanish is a latin language, can...

I wrote some code to send email. If Outlook is proper installed on your PC : it works fine. However, what should you write if you use the light free version Outlook Express. Can you refer to this ? now I use Set OL = CreateObject("outlook.application") it activate Outlook which is on my pc...

Chr(10) returns a linefeed character. Is there a reference list for the chr numbers ? what is the Chr. number for ... 1. Chr number for | 2. Chr number for a tab

Hola, I have a sql to feed my recordset. I need a parameter from a form. If I type the value literal eg 83 it works. The reference to the formfield works also. When I try to include the variable or the form reference in my WHERE clausule he said to few parameters. I thinks its a syntax...

If I try to run my code I got the error "types are not matching" Set rst = CurrentDb.OpenRecordset(strSQL) Has this to do with the references ? If yes, which one should you select out of the large library. I don't see why access is annoying the user with what should be basic functionalities as...

Hola, I get the index value form the selected item form my listbox. eg 9. I should get the literal value of the second column and the literal value of th fourth column which is not visible (with 0 cm). This is not working. Dim strFileName As String Dim frm As Form Set frm =...

Hola, I should get the year as a parameter from the fields year that I select as a value from a dropdown box. However on testing first from a simple textbox the query said this is to complex to calculate year hardcoded works Between DateSerial(2008-1;3;1) And DateSerial(2008;2+1;0) trying...

I know you have a limited number of VB Constants like vbBlue. How can I find a way or list to find the corresponding number for a certain color. eg. I look for light gray.

I know you have a limited number of VB Constants like vbBlue.How can I find a method or list to find the corresponding number for a certain color. eg. I look for light gray.

Hola, My workbook gets his result from the recordset (from the query) I need my columntitles. The names of my queryheadings are changeable (it is a crosstab which show the months and these are not fixed in this case). Can I retrieve the column heads along my recordset ? Below is not working...

Hola, It seems that you can't use OpenQueryDef in Access2000. I need a query to feed my recordset and I can not hardcode this as an SQL statement in my sub. How to feed my recordset with a query as datasource ? Set qry = dbs.OpenQueryDef(strQueryName) Set rst = qry.OpenRecordset()

Hola, I have a simple "dim dbs as Database" Dim dbs As Database this produce the error "this ia a user defined type not ok". Is this depending on the version of access. I tried also DAO.database. I use access version 2000

Hola, Many languages or software is related to the development of websites, javascript, php, css ... If you think they stop inventing new things then you got ... a new one. javascript = client browser actions. php = server side scripting language. css = presentation of your webpages. Where...

Hallo, I activate a maketableqeury with Docmd.OpenQuery While running you see automatically the progress bar on your status bar. However to make it even more user friendly I need to know when the maketable action is complterly finished(then I can set a textbox background value to vgGreen for...

I have done it ones, but looking now again how to do this. From in your code how can you execute a make table query. It is something with a .execute. I know how you can execute an sql.

Hola, I create files from access to excel. However when the file already exist, he may overwrite it without asking. I wan't to avoid the anoying ask "the file exist, may I overwrite it". Is a docmd.setwarning false enough to fix this ?

I have an few variables strPath and strDir that should be accessed by more then one sub. I thougt I have read something that you can place them above your module or in a class so the are declared ones and accessed by many. Public Dim strDate As String strDate = Format(date, "yyyymmdd") How do...

I have a dummy question. I have a sub in a module and I need the value of a Textbox. However how should I do this correct ? strPath = Forms!Main.txtPath.Value not ok strPath = Forms!Main!txtPath.Value not ok He sais Main does not exist, in the form tab he is listed and in the properties I can't...

My code has a sql statement and it writes data to excel. the first field writes nothing to excel. He should do this because my recordset loops through every field of the query, somethimss he has to write data, somethimes not. My Excel is a template and in the field where he write the texte1 he...

I do an export from access to excel and I do some formatting on the data in excel. It works. I wonder, one field in the excel sheet should be a listbox (with a fixed content). Has somenone an idea on how to write this (example code).