thanks for your reply.
I can get the value in the main form unbound field.
but i dunno how to store that value in to a bound field in a table...
for example,
i used the suggestion you gave me and i created an unbound field MainTotal
it works like a charm.
now, i wanted to assign the value in MainTotal unbound field into a field, TOTAL, in the main table.
...
kathnicole
Last Activity: Feb 15 '08, 03:47 AM
Joined: Mar 8 '07
Location:
-
How to assign value of unbound field to a bound field in a form?
Hi,
I am using MS Access 2007/Vista
I have a field, ProductCost in the subform. i need to find the total of ProductCost and assign it to a field, Total, in the Main Form .
I read an article about how to find Sum from a subform field.
based on that, i stored the total value in an unbound field.
i dont know how to assign the value from the unbound field to a bound field , Total, in... -
i used DLOOKUP function to get the value of the stock from the table but i dunno how to replace it with the new value.Leave a comment:
-
how to update a value of the field in a talbe through VBA?
Hi i have a table called tblStock consisting of Avaialble Stock for our company.
i need to update the Stocks whenever we receive new goods.
I have another table called tblStockInfo about received Stock Info and a form frmStockInfo for the same.
When new stocks comes in, the user enters the details like Stock Name, Quantity, Price etc.
what i wanted here is , as the user enters the new stock information... -
Hi,
Am still waiting for a response from someone.
chuz,
Kathy...Leave a comment:
-
thanks MC...
alas, i got it right..
thanks for being so hepful...
chuz,
Kathy...Leave a comment:
-
guys,
i do understand wat u r trying 2 say...
the format only works for a new table. say if i have a table with no records, and if i format the date field as dd/mm/yyy, it works good.
but i have 100 records in the table (import from another database) and if i format the date, it doesnt works. it still remains as mm/dd/yyyy.
i feel sorry if this reply frustrates anyone.
...Leave a comment:
-
Sorry for not mentioning this...
this is about Access mdb...
The Quote Database is in Ms Access 2007 and other mdb's are in 2003 format
chuz...Leave a comment:
-
add new records to another database?
Hi All,
I have a database called "Quote" and another database called "XJob", "YJOB" and "ZJOB".
In QUOTE database, i have two tables "CustomerIn fo" and "Quote"
In XJOB database, i have similar tables "Customer" and "XJob"
In YJOB database, i have similar tables "Customer" and "YJob"
... -
mccarthy, i've selected the short date for my date field.
in access 2003 , it will be like, short date (dd/mm/yyyy)
but in access 2007, it is like short date (mm/dd/yyyy)
as i am using ms access 2007, i do not know how to change the format like in access 2003?
could you please explain me how to do this??
regards,
kathy...Leave a comment:
-
Hi,
I have selected the Short Date but the problem persist with the default settings.
the Short Date in ms access 2007 is mm/dd/yyyy format unlike in ms access 2003. i wanted that to be changed to dd/mm/yyyy
that is were i am getting the problem.
I do not know how to change the format!!!
thanks,
Kathy...Leave a comment:
-
Format Date in Access 2007?
hi there,
I have a field called DateEnacted (data type :date/time)
could anyone tell me how can i change the format to dd/mm/yyyy , when i enter values in the table, instead of mm/dd/yyyy?
thanks,
Kathy -
how to Update Stocks when used?
Hi All,
I am asked to build a database for a Printing Company that would prepare a Job quote for the Customers and review the stocks available to carry out the Job.
Stock Information performs the following:
1. Enter stocks information
2. update Stocks. say, when Eyelets stock is 20 and if we get another 5 eyelets today, then it should update the total eyelets to 20
3. Inform user when stocks runs... -
how to mail a report as an attachment in outlook?
I have a report called rptQuote created based on parameter query.
and i was not sure how to email the current report in outlook.
can anyone help me in this regard?
thanks,
Kathy -
I must try this out as well....Leave a comment:
-
Thanks guys.
it solves my problem.
regards,
Kathy...Leave a comment:
-
May be ontherun should use scheduling software to save the mdb file in the respective folder.Leave a comment:
-
How to get the DAY value from DATE
Hi there,
Could anyone please tell me how to get the Day (i mean DD from DD/MM/YYYY)
from the Date field.
I have a created a database for a Loan company. if the Loan Start Date is 20/01/2007, then the due date to pay the interest will be 20th of every month.
as of now, i have a field called Due Day where i manually enter the day for each loan information.
and i have a parameter query... -
Hi,
Use the Form wizard to create a form.
Click Form
Select "Create form using Form Wizard"
Follow the promts.
it is as simple as that.
chuz,
Kathy...Leave a comment:
-
hi damon,
thanks a lot for your reply. that gives me an idea of what i should head on with.
regarding the last one, Job Scheduler:
currently in our company we have got 5 different printing machines . depends on the job requirements, each job must go to specific machine with the allocated time.
i need something to inform the user (Scheduler !!!???) about the jobs that are in pipeline for printing....Leave a comment:
No activity results to display
Leave a comment: