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!

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

Recent content by BMKanun

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

Part and Inventory Search

Back
Top