Sorry guys.
I got that working...
i declared the field as Text .silly me...
only now i noticed it.
I changed it to number and its all working.. i would hav gone with autonumber but i want to get the max number through VBA
regards,
Catherine...
ontherun
Last Activity: Sep 5 '07, 04:17 AM
Joined: Mar 21 '07
Location:
-
DMax function Problem
Hi,
I have a form called Customer based on the table tblCustomer and
another form called Job based on the table Job
when the user enter the details for the Customer i have a button at the bottm of the form called EnterJob where it directs to the Job Form
I have included some code in EnterJob button so when the user clicks, it gets the value for Customer Name and Max value of the Job number and... -
I didnt include the word module in the code. however i saved the module as mod_SaveBackEnd and called the function under Form_Close() function.
but when i tried to close , it says permission denied.
then i tried 2 call the function under Quit Button Click.
but nothing happens and the my file was not saved in the folder i specified.
is there any other step am missing here???
need your assistance....Leave a comment:
-
Hi ,
i saved the as in the module and called from on_Close event..
but it doesnt do anything i mean, there is no mdb file saved in the directory i specified nor a error message.
the code was,
Privare Sub Form_Close()
SaveBackEnd - module
End Sub
MODULE:
Function SaveBackEnd()
Dim strSavePath, strSaveFile, strNowPath As...Leave a comment:
-
Hi J,
Thanks for your reply. I spoke to my Admin and i came to know they have not set up the server to have backups but he will do it some time soon. (strange..i dunno when!!)
but as of now what i am doing is, before leaving the office every night, i am keeping a copy of the db in my local machine.
I hope if the server is scheduled for backups, then i dont have to do this. I am just curious to know is...Leave a comment:
-
save MDB file through forms?
Hi All,
I know this might be a silly question to ask but i was just wondering,
is there a way to save a specific MDB file , which is accessed from the server,
in to the local machine in a specific folder.
It will be good if there is a way so that the user can create a backup of the database they use into the local machine before they close.
is there any way or any other similar operation... -
thanks Jim. that gives me a clear understanding of where i went wrong and what exactly i should do.
thanks a lot again..
i'll follow your steps as stated.
have a good weekend
regards,
Catherine...Leave a comment:
-
Hi there,
I checked in the tables and all mobile numbers starts with 0 as i entered for the first time. like
but when i open in forms, the same mobile numbers does not start with 0.
am totally confused...Leave a comment:
-
hi,
thanks for your reply.
I tried both the options but i have entered some records with my previous settings.
so some of the mobile no have been saved as 411111111 instead of 0411111111
now when i change the data type and save the table, i tried to change the values but it is not allowing me still.
what could be the reason?
waiting for your reply.
thanks,...Leave a comment:
-
Could not start number field with 0?
Hi,
I have a field to enter mobile number (10 digits) for customers and it starts with '0'
whenever i enter the number, it does not accept zero at the front.
if i enter: 0411111111, it will end up like-- 4111111111
how should i rectify this??
can anyone help in this regard,
thanks,
catherine -
Customer Table - Primary Key is Loan Number
Address Fields
Loan Table - Primary Key is Loan ID
Foreign Key is Loan Number.
Loan Amount, PreviousPaidLoa n,LoanPaidDate, LoanBalance.
Interest,Intere stPaidDate,Inte restPaidAmount, InterestBalance
the fields i want to be listed in a 2 seperate tablular...Leave a comment:
-
Thanks for your reply Rabbit.
I will let the users to make the changes in form before printing.
but i am still looking for an answer to include 2 tables in the same report.
the fields corresponding to both tables are from the same table tblLoan.
thanks again for your effort.
regards,
Catherine...Leave a comment:
-
I have a description field for each payment and i hav include the same in the report.
but they felt it will be better if there is any option so that they can edit ,if any, before taking a printed copy.
i have only two tables - Customer and Loan.
the Loan table has got both Loan Amount Information and also Interest Information.
My Statement must have following format:
...Leave a comment:
-
thanks for your reply Rabbit.
the actual statement comprises of 2 tables. First table shows details about the Loan Amount paid by the Customer. And the second table shows details about the Interest based on the Loan for each month.
the size of the table increase/decrease with respect to the information for each rows.
before taking the print out, the user want to change something in the description part...Leave a comment:
-
Finance Statement problem?
Hi all,
I am using MS Access 2002. i am building a database for a Finance Company
I have 2 tables - tblCustomer (personal Details and PK is LoanNumber)
tblLoan (PK is LoanID)
Relationship is 1-to-many.
With the information i have gained so far from TSDN forum, i could write some VBA code for my database. I close to finish building my database but i was stuck in doing... -
Hi,
Thanks for your reply
I did not use the On Timer event but i just used the following code on Form Load.
I get the Message to be displayed if the date is less then the current date but the ForeColor is still the same. For some reason, it is not happy with the code
Private Sub Form_Load()
If [Ins_NextDueDate] < Date Then
[Ins_NextDueDate].ForeColor...Leave a comment:
-
ontherun started a topic Change color of field depending on Date (was How to include OnTimer event?)in AccessChange color of field depending on Date (was How to include OnTimer event?)
Hi All,
I want to include some code for the OnTimer event in my Form "frmDueDateList "
But when i open the form in the design view and checked the properties menu,
i could not find the OnTimer event.
I want to change the color of the DueDate field to Red if it is less than the current Date. I thought it could be done under OnTimer event.
so i included the following code... -
thanks for your reply guys...
i have only 2 tables... tblCustomer and tblLoan with 1 to Many relationship
Loan Number (Autonumber and PK for tblCustomer) connects this two tables.
PrincipleAmount Paid and PrincipleAmount Balance are in tblLoan
i havnt used the Max() function in the query yet... will try this time...
i appreciate your help.
thanks a lot...Leave a comment:
-
How to include the last data in a report?
hi,
i have built a database for a Finance Company with tables such as "tblCustome r" (PK is CustomerID-Autonumber) and "tblLoan"(P K is LoanNumber).
the table tblLoan has information for each month comprises of interestPaid, InterestBalance , TotalArrears etc.
I have a report called "OrderStatement " based on parameter query to create a statement for a customer.
the query is such... -
Kepston and Puppy,
U guys rock... man, it solved the problem ..
thanks guys..thanks a lot...
take care
chuz,
KathyLeave a comment:
No activity results to display
Leave a comment: