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

Thanks guys, it is doing the job! BMK

@dhookom, thanks :-), this field was not intended to have that function. It was first contact info. Latter it was added as description field in subform, and now it makes me a lot of headache, with the data that is already filled in. Date field exists in the tblEvents, but some users didn't fill...

Hi Andy, thanks for your reply. Here is a simulation of the table: ID;Client;Event 1;Client1;press-conference 01.04.2015 2;Client2;20.03.2015, annyversary celebration 3;Client3;wedding party, 23.05.2015 at Palace Hotel The only thing that is constant is the date format: dd.mm.yyyy regards,

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,

Thanks PHV! You have made it! :-) The next logical step would by applying multiple filters! Should I combine all the conditions now? BMK

Hi again, This doesn't work, or I'm doing something wrong. When the All is selected (combo Value = null) means that criteria for the field is Null. But I don't need Null criteria since no records has an empty field. Instead of NULL as criteria, we need NO CRITERIA when we want to see all the...

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

Thanks dhookom! I finally made it, after I had trouble translating the code to the real tables and fields, but now I got what I needed. I have an tblExpences where Month row already exist, so I didn't needed the second code. In the firs one, I selected the Num value with the...

I'm afraid I can't get the result as you are saying. Can you please explain a bit more? My DefaultValue (un-named) already contains all the ID's of types as records and Months rows 01,02,...,12. All the values in the table are 0. The qryExpencesCrosstab contains data from the Expences table...

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

Thanks, that will do the job. B

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 everybody! @Randy700: thanks, I have applied your suggestions. @PHV: thanks to you, too, how foolish of me not to see .MoveNext is missing.:-)After adding the 2 lines everything worked as I expected. @theAceMan1: Thanks to you, also! Good to learn (I really need to learn a lot). In...

Hi Rendy, I thought to find out the record with the username same as the user selected in the form. If the string match?s: strUserR = strUserE then I want to set that particular text from rstRecord![Psw] to the strPassR. That was the idea. The table with data has only 3 records, (name...

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

Thanks a lot! I'll apply it in the database. thanks once again, and have a nice day!

Thanks once again, while working the things become more clear what is needed to be done for me too. It seems that there should be a another table where it will be defined which inspectors will check which products (according to speciality). Not all the products will be checked by all the...

Hi & thanks for your interest. It is an Access database table with the following structure: ID:DATE:TIME:INSPECTORCHECKED:PRODUCT: etc.. the numbers 1,3,5,7,9, represent the InspectorID checking particular product and is saved in the INSPECTORCHECKED field. Every inspection is recorded in one...

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