I could add "01" instead of "1" if its conflicts at later on, it was just an example or you can suggest any other way.
The main thing in what would be the method and procedure to capture, when sub account is selected to add increment value to its number rather than columns max value, for that i...
Hi everyone,
I am posting the db and function here for new account and sub account functions which need to be rectified as it was created for single stage account and now i need multi sub accounts which can led the new account number up to 10 digits maximum more than that is not allowed as i...
Hi everyone, I am recalling the post because I face some difficulties in above function.
As you can see in above posts we are trying to figure out the sub account value with Dmax function, which is working fine but not perfectly as I want to be it has some issues which i will be highlighting in...
The form is open from the post one, i dont have that issue.
The issue is form open with record that i have exchange date and currency same as subform fields selection which i am doing the event on it, so that no new record will be created when exchange form opens.
if subform mentioned currency...
Sorry i forgot to add exchange rate table....its there now.
I will definitely see the indentation of code to make it easy to understand, as far as i know it help reading the code but its an optional stuff.
Ok, now in final try.
in below code i have changed several stuff all variables are there now the problem is shifted to different portion of code no more docmd may be after i solve that one but, presently its with dlookup which is showing two errors invalid use of null after i add NZ to date...
Thanks everyone for your posts, now its 26 posts in one thread and still the problem is same anyways, i have to solve this by myself.
I put option explicit at top of code module window and not at the event of button hence, you are not able to see it here.
I am sorry if its count as attitude.
here is full code.
Private Sub ExchangeRate_BeforeUpdate(Cancel As Integer)
Dim ERate As Integer
Dim VBAnsw As String
Dim sArgs As String
sArgs = Me.Currency & ";" & Me.TransactionDate
ERate = Nz(DLookup("[Rate]", "tblExchangeRates", "[Currency] = '" &...
form is open without where clause i have posted the working code before, the problem in where clause since i try to add its giving error.
Full code is mentioned above "essaytee" please check first before firing up :mad:.
I am unable to get it right, sArgs should be include or not?
DoCmd.OpenForm "frmRecordExhRates", , , TransactionDate = #" & Exhdate "#", Currency = '" & Currency "'", sArgs
There is no question on giving up or keeping aside, I could run a append and update queries but in order to avoid bunch of queries in my project I decided to go with sql, every achievement need time and patience if I where struct like an ice from the beginning then probably it was better to give...
Thank you very much for all your comments and suggestions.
each button has its rule to play DELETE,EDIT,VOID etc and all these are required to give user options in database.
I have to complete this code by any mean, sql2vba is not that much effective in sql this work fine for list box events...
I can understand you guys are professionals and can tell anything you like if its not presented correctly or missed something, but every effort need time to get mature not immediately once its initiated, also please note i don't pressurize anyone to do my work.
Below is my try to make as you...
Yes it will update all rate for the those transactions which is using this rate before or assigned to this rate it will be a big change, however if i dont want to pass the value through arg then i would need to open the exchange rate for to a specific record where currency and transactions date...
Hi Everyone,
I am writing cmd button event for delete in my data entry form before deleting the records i am storing the information in delete table and updating it with delete date in order to do that i have divided the sql in three portions (INSERT INTO, DELETE, UPDATE).
Please review the...
I think you did not understand what i want here, i dont want sql to update or insert into this information user have to do it manually, i just want to give him time to think what he is doing and what are the implications for the action while he update the rate manually on exchange rate form...
Args are identifying what date and what currency i am looking for, while opening exchange rate form, so that i dont need to put it manually.
Secondly my query is that if exchange rate is already there in a exchange rate table for selected date and currency then the field of rate on exchange...