Search results for query: *

Hi, i have a Db with DBPix for inserting and viewing images. The code for inserting an image is: strInputFileName = ahtCommonFileOpenSave(ahtOFN_FILEMUSTEXIST, _ "", strFilter, , ".jpg", "", "Imagen para '" & Me.link & "':", hwnd, True) [...]...

Hi, i need to avoid a problem in Access 2003 without SP1 installed. I would need then to know if the PC in which DB is opened has or not SP 1 installed. I know the Access version can be known from code, is also possible to know which SP is installed? Thanks for any help given.

Hi, i have a form with a continuous subform based on a sowing calendar table which has 6 fields: FromDay, FromMonth, ToDay and ToMonth, ExactDay, ExactMonth (that is, the sowing can be an exact day or in a short period of time). In the subform I want to represent where is the sowing moment into...

Hi, i have a .mdb from Access 2000 and i need it works in Access 2002 (also in the rest of Access versions). In the code the line DoCmd.OutputTo acOutputReport, "report1", acFormatSNP, CurrentProject.Path & "\temp1.snp", False has no response. Can it be a references problem? It works...

Hi, i have a form with validation defined by code: the two table fields are not required and the validation is made by setting two respective boolean variables to True or False in the textbox_BeforeUpdate event, in this way: Private Sub term_BeforeUpdate(Cancel As Integer) If...

Hi, i have a form with a button for printing to the printer the content put in a report. If i cancel the printing configuration window, it opens the report in print preview, and is in forefront after closing the form. Can this behaviour be avoided? Thanks for any help given.

Hi, i have a DB made in Access 2000, and when i have opened it in Access 2007 (in Windows Vista) there's no forms in the form section, and no reports in the report one. I had opened it already in Access 2007 and Vista in another PC and no problem. I would be gratefull for any help given.

Hi, i have a report 'Glossary' and need to show the entries number in the page header of the report. It works putting a textfield called text1 in the first header with its control source property set to =Contar([mainField]) in english versions: =Count(.. and in the textfield text2...

Hi, i have a DB from Access 2000 spanish version, and some texboxes in forms and reports have expressions made with the expression builder, such as: - Contar(*) instead of Count(*) - Mayús$(Izq$([field])) instead of Shift$(Left$([field]) and others. Will these expressions give an error if the...

Hi, i have a DB from Access 2000. The form that loads at starting hides the predefined toolbars, but when i want to show a report i use: DoCmd.ShowToolbar "Toolbar1", acToolbarYes That in Access 2007 makes nothing. Is it because the 'Ribbon' toolbar must be also shown? Is there any way of...

Hi, i have a DB with two smilar forms, one is editable and the other isn't. The forms have a secondary form, Secundario70, with photographs. What i want is when changing between forms through a button in each o them, both main and secondary forms show the record that showed the original form...

Hi, i have a .mdb from Access 2000. In Access 2007 there is an advertisement on the opening that says Security warning: part of the database content has been disabled. And there's an options button for enabling that content, but you must enable it each time you open the DB. Is there a way of...

Hi, i have the code: Dim rst As Object 'ADODB.Recordset Set rst = CreateObject("ADODB.Recordset") rst.Open strQuery, CurrentProject.Connection, _ adOpenStatic, , adCmdUnknown For avoiding errors the adXXX constants must be replaced by its true value, 3 for adOpenStatic, but which for...

Hi, i need to make compatible my Access database with any version of Access, and any version of the .dll files used in the database (i think that if that is accomplished the database will be compatible with any Windows Operative System). How to make the late bindings for that purpose? Thanks...

Hi, i have a form with records that can be filled out or not, and can be filtered either if they are filled out or not. I have a report for printing all records with data, but i need also a report for printing the records with data only between the filtered ones. Is there any way of taking the...

Hi, i have a report with a subreport that has a group which onFormat event forces new page in vb if this group has data. But in the main report this new page isn't counted and appears one page less than the total they are. It works if i stablish the property Force New Page to Before the section...

Hi, in the page header of a report with 3 levels of child subreports there's a textbox with its Control source property set to =[Pages], with another set to =[Page], so the result is Page N of M. This report can print a preselected number of records. When the number of records fills about 30...

Hi, for many records i have a field in a table with the text [...]. I want to obtain in a query only the records that have this text, so in the design view of the query, in the field desired i include as criteria: Like '*' & '[' & '*' But the query returns no records, the character [ is not...

Hi, in a form with editable records i have an image for changing to another similar form but with different features like uneditable records. For that i have the code: Dim rsttt as Variant Set rsttt = Me.recordSet DoCmd.OpenForm "frmUneditable"...

Hi, in the code Dim cn as ADODB.Connection strQuery = "UPDATE tblTaxonomia INNER JOIN tblCalendario ON tblTaxonomia.Id = tblCalendario.idEspecie SET tblCalendario.visible= No WHERE (" & condWhereNotLike & ");" Set cn = CurrentProject.Connection...