Search results for query: *

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 ?

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

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)

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

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

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

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

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

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

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.

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