Search results for query: *

Hi, I have subform in main "Employees" form presenting Holidays (StartDate, NrDAys, Comment..) In the form (OnLoad) permitions AllowAdditions AllowDelitions AllowEdits are set on False. Particular operator (OperatorID) can do change with Commandbuttons event code setting them True, before...

Hi, I have a table for planing upcoming events. Some of my colleagues were entering date together with text in text field. There is no patern of the date possition. How can I extract (find) the date in the string field? regards,

Hi guys, When I make filtering of the records through combo box selection, everything is fine when there is a specific value of the combo related to the data in the table. When combo value is Null, the query selects nothing instead of everything (logical, isn't it?!). How to make this work, how...

Hi all, is it possible to sum table with structure ExpenceTypeID, 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12 (months)(all possible ExpenceTypeID listed and all values in fields =0) with Crosstab ExpenceTypeID, 01, 03, 04 (not all ExpenceType or months return value) the idea is to get...

Is it possible to get report like this: Invoice: (date, nr. client etc..) product (details) quantity price A 1 Ap B 1 Bp Set C 1 Cp ('Set...

Hi, I'm trying to make code for password check in Access2007. The user type and password are stored in table (id,name,psw)(Defined in other database) A form opens with 2 fields, Listbox User (to select username-type) and Textbox Password. On password enter modul runs. It stucks somewhere in the...

Hi, can someone suggest how to check if data from one row is included at least once in another row. e.g Control row: 1,3,5,7,9 Row 1: 1,3,5,3,7,9 OK! (doubling 3 is acceptable) Row 2: 1,3,5,3,7 NOT OK! (9 is missing!) Thanks, Bole