Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. BMKanun

    check if there is record in subform to enable edit

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

    Extracting date from string field

    Thanks guys, it is doing the job! BMK
  3. BMKanun

    Extracting date from string field

    @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...
  4. BMKanun

    Extracting date from string field

    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,
  5. BMKanun

    Extracting date from string field

    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,
  6. BMKanun

    Filter through combo box selection, how to select "All"

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

    Filter through combo box selection, how to select "All"

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

    Filter through combo box selection, how to select "All"

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

    Suming Table and crosstab query

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

    Suming Table and crosstab query

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

    Suming Table and crosstab query

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

    Details and more details in a report

    Thanks, that will do the job. B
  13. BMKanun

    Details and more details in a report

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

    checking password in a table

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

    checking password in a table

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

    checking password in a table

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

    Check if data is included at least once in a row

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

    Check if data is included at least once in a row

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

    Check if data is included at least once in a row

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

    Check if data is included at least once in a row

    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

Part and Inventory Search

Back
Top