Search results

Hi all, I am developing an application for someone at the office and i have a question. Is it possible to do something so that person will not work directly in .mdb file? Does someone know from where i can download an access xp (2002) runtime for users that does not have access installed...

Hello, I made a database application and i need some help: in the application i use a script that modifies word documents by opening ms word application, but some customers don't want to install ms word. I'm asking if someone knows tto exist some kind of word runtime that i can modify word...

*Can anyone tell me if or how to reffer to the options from Tools-->Startup in VBA code? I`m asking that because i want to open a database in different ways taking in account the logged user. *And another question: in access 2000 is possible to make .mde files? Because the option is dissabled...

Hello, I have a make table query and at some field on criteria "[Forms]![Gest vz]![Det1]![Cod furnizor].[Column](1)" i have the following error:undefined function '[Forms]![Gest vz]![Det1]![Cod furnizor].[Column](1)' in expression. Please help!!! :) Thanks!!!!!!!!

Hello can anyone help me with a code or application example of how to hide all db elements. I have a database and i want only a main form to appear for users and tables, code, etc to be hidden. Thanks!!

Hi all, I have a problem with the following piece of code: Private Sub cmdCautare_Click() Dim strSQL As String, strOrder As String, strWhere As String 'Select Case Me.cmbTipVersus 'Case 1 'If Me.cmbTipVersus = "" Then strSQL = "SELECT tblDosare.DosarID, tblDosare.DenumireDosar...

Hi, I have a search form and a form that display the result of the search based on the search criteria from the search form. The query works just fine and the search results are displayed well but the problem is the following: the query doesn't work with the new records inserted in those tables...

Hi, i have a problem with a form, i don't know how to make a reference to a form property. The code is the following: Private Sub cmdCautare_Click() Dim strSQL As String, strOrder As String, strWhere As String strSQL = "SELECT tblDosare.DosarID, tblDosare.DenumireDosar, tblDosare.CodDosar...

Hello, I have the following code and i don`t know what's wrong Private Sub cmdCautare_Click() Dim strSQL As String, strOrder As String, strWhere As String 'Dim dbNm As Database 'Dim qryDef As QueryDef 'Set dbNm = CurrentDb() strSQL = "SELECT...

Hi, Can anyone tell me what's wrong with this: DoCmd.RunSQL "INSERT INTO tblPersoaneJuridice (Denumire,Localitate,CodUnicInregistrare,NumarInregistrareRegComertului,Telefon,Fax) VALUES ('" & Forms!frmPrincipal!subfrmTipVersus!txtDenumire & "','" & Forms!frmPrincipal!subfrmTipVersus!txtLocalitate...

Hi Can anyone can help me with a search algorithm?.... I have a form with multiple controls (textboxes and comboboxes). In one combobox i have 3 values: legal entity, employee and and individual. Basing this values another subform appear for the search: for the person a search can be by its name...

Hi i have a problem with a variable value...I have 2 variables and i need them to take values from tables. Dim dosarid As Integer Dim cnp As String ……………………………………………………………………………………………… DoCmd.RunSQL "INSERT INTO tblDosare (DenumireDosar,CodDosar,DataDosar,Instanta) VALUES ('" &...

Hi, I have 2 forms: the first form is the search form (frmSearch) and the second form for search results (frmResult). In the search form i have 2 textboxes and 3 comboboxes. In a combobox if the user is chosing a value another subform appears on the form containig another search criteria (some...

Hi, I have a problem with a variable value. I have 2 tables calles FIles and Persons and i want to create a relationship between them one-to-many (More files for the same person) because a file can have the same number of file but not the same date. So for this relationship i have created a...

Hi, I have a situation and i do not know how to handle it. I am developing an application for a lawyer. In the data base i have the following tables: Files, the people table (that are involved in a lawsuit), and other tables. The problem is the following: in the people table, beside the primary...