Recent content by b0gdan

Thank you. I was afraid of this...i am afraid of another thing...to migrate to .net but this is it...:) Thanks

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

Thanks it works without Column(1).

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

When you type student I.D. number use dlookup function to look in the students table for name and last name and you can see there that it works very simple. Check for Dlookup function is very simple.

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

Thanks but still doesn`t work and both stadiu an the other one are text type. I think & "AND" & (Stadiu)=... is correct because is text concatening to get in SQL " Select xx Where x=... And y=... ". I don`t know what the problem is, thanks for the answer.

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

Try this function If "AA" <> Right(Me.txtYourTextBox.Value, numberofcharacters). Example: If "AA" <> Right(Me.txtYourTextBox.Value, 3) Then etc.etc.etc............ Is also available with left instead of right

Try this: items = DLookup("[Datum]", "Entschuldigung", "[Datum]=#" & Month(10.10.2006) & "/" & Day(10.10.2006) & "/" & Year(10.10.2006) & "#" in dlookup you have: for text '"....."', for number only "...." and for date with ##

Hi When you will add records in the second table you will need to use Dlookup function to verify if there exist in the first table.Example: Dlookup("[newdata]","[table1]","[newdata='" & Me.txt.....&"'") See how Dlookup works!! And if your compound key contains lets say 2 elements you can use...

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