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!

Search results for query: *

  1. rluciano

    showing the number 3 as 003

    Hey Esquared, how about this. How about if I run code in this macro prior to using the newly generated Id, that will insert this new Id into the LastCLientNumber table. Will this resolve the issue of the current method only being useful to one user scenario ?
  2. rluciano

    showing the number 3 as 003

    Let me see if I understand, in your procedure, it looks like after you define the value of the @NewClientNumber variable, that you insert new client number into the LastClientNumner column, so if someone else would try to add a client, unless they did it nanosconds apart wouldn't cause a commit...
  3. rluciano

    showing the number 3 as 003

    the issue i reported in my first solution was because I forgot to add the +1 to the expression used in my conditions of the macro....(doh)
  4. rluciano

    showing the number 3 as 003

    Thanks for the info E. I used the two digit date format because thats how the client id's were formatted prior to me getting there. Granted it was a manual system(paper files, nothing in a pc except for rudimentary client lists in excel and word) and it would have been best to suggest that...
  5. rluciano

    showing the number 3 as 003

    I was able to solve this problem for the most part by using conditions in the macro. For Ex. Forms![NEW_CLIENT]![Total client]+1 Between 1 AND 9 Then [Forms]![NEW_CLIENT]![Supplier File Code]+''+Format(Date(),"yy")+''+Format(Date(),"mm")+''+'00000' & [Forms]![NEW_CLIENT]![Total Clients]+1...
  6. rluciano

    SP and forms

    If you run the wizard when you add the combo box to the form, the wizard will walk you through using the sproc as the recordset or control source for the combo box
  7. rluciano

    showing the number 3 as 003

    I created a macro that sets the value of a new CLIENT_ID based on certain values. Heres the expression [Forms]![NEW_CLIENT]![Supplier File Code]+''+Format(Date(),"yy")+''+Format(Date(),"mm")+''+'000' & [Forms]![NEW_CLIENT]![Total Clients]+1 I want the CLIENT_ID to follow this convention...
  8. rluciano

    Using DCount function in an unbound control (Acess ADP)

    Thanks for that Esquared, I saw your answer and as you know works perfectly.
  9. rluciano

    Using DCount function in an unbound control (Acess ADP)

    Here's the situation. I have the following Form Name: NEW_CLIENT Combo Box Name: Supplier List Unbound Control 1: Supplier No Unbound Control2: Total Clients When I select the supplier name from the list, a macro sets the value of Supplier No to the corresponding Id.(Supplier Id from the...
  10. rluciano

    Generate Daily Balance From Transaction Table

    I reread your original post and in doing the insert your view should show the current balance and current date for every account, not just for one account. querying the DAILY_BALANCES table ordered by account then date should give you the results you want.
  11. rluciano

    Generate Daily Balance From Transaction Table

    Hey databanker, Are you going to store this data in a table like DAILY_BALANCES or just run the query everyday to report on it? How about this, create a DAILY_BALANCES table with all the fields from the sproc. Use the query you wrote, make a view from it and insert the data into the...

Part and Inventory Search

Back
Top