Search results

Hi there, I have a Db forms. Main form and subform which has one to many relationship. Where users use to tract the daily expenditure. What I like to do is that to find by list in budgetcode combo box eg. RAB50, RAB51...RAB60 then show and SUM all the amountUSD in total if one code was used...

Hello there, I have other question to ask relates to my Financial database. I have a subform which contains fields Amount (numeric), Exchange Rate (Numeric), Budgetcode (Combo) and TotalUSD (Numeric). Sometimes users spense some money on same Budgetcode eg. RAB50 for 5 times, 2 times on RAB51...

Now I full understood. Thank you so much to you guy been doing a great job helping peaple all a round the world sorting out these db issues, guiding them on what they have been doing right to the direction. I really appreciate that. Cheers,

Thank you so much Boblason, That codes works calculation on a main form. I also have a other question please. On a subsform, I als like to have the calculation, by having the Advance field divided by the exchange rates (these two field are on the mainform) then appears result in subform...

Hi Boblarson, Can I use =Nz([field1],0) + Nz([field2],0) with devide in stead of plus? Cheers,

Hi there, I feel a bit disappointed on this forum. I posted few thread but no body response. Is there anybody there? Cheers,

Ooooop! Sorry. Here are attachments.

Dear there, I got a quick question on a Subform. Please see an attachment. What I would like to do is: 1. Whenever the option check = 1, the TotalStandingUSD2 becomes invisible if it equals 2 then the TotalExpenseUSD invisible and TotalStandingUSD2 becomes visible. I tried: If Me.Frame135=1...

Dear There, I have a simple database, there is a form subform inside the main form. At a moment, I have fields called USD and other currency in a main form where the USD field is for Total Advance in USD, which then has to be subtracted with the total expenses in subform and results in other...

Yes, it works Thank you so much in deep

Thank you so much for recommend. Now, I have other issue poped up it is that: When I add new record or scrolling records up and down. it does not seem that it automatically toggles either turning off or on the currency fields. I really don't have any idea to workaround, here I have posted a...

Dear there, Is there any way of using Option group check box to visible or invisible numerical fields please? I have 3 numerical fields which are: Kipcurrency, ExchangeRate, and USD. While having Kipcurrency field as a default defined in Option group. I have also 3 options in a option group...

Dear there, I just bougt a new laptop from thailand for office use, it was originally come with OS xp home pre-installed from computer shop. With this xp home, I have found from several forum reviews on web that does not have joinning to domain server function. So then I rang to the computer...

Please any advice What is the best solution to my situation, What should I define the field(s) in the table to admit those two data sets? Thank you

Hi The Doc Man, Thank you very for your help, Im very much appriciated for that. Unfortunately, Im really new to Access. I don't have any clue putting those into the action, could it be possible sending some short sample please?. Thanky you very much in advance With best regards,

Dear there, I have every recently finished most of the crucial parts. At the present, I just realize that one thing would bring me in major trouble. In the PK field, it was defined as DataType: Number, Format 00000, I also utilized the DMAX code for autoincrementing values. However, it seams...

Yes, this is what i am after. I really appriciate for your help Thank you so much With best regards,

Refresh Combolist in TabControl Dear there please help, I have problem with my Fixed Assets Database. I have a main form called Fixed Assets which involves 2 Tab Controls. One named Page1 and other named Page2. In Page2 Tab Control, there are 2 combo boxes one named Projects and BudgetCode...

Dear all there, Is there any way to select another textbox by click one of two options. I am working on a personal database. A option group has been created in order to identify whether staffs stay in their own resident or in a rented house. Now if I click at a default option it allows me to...

Dear all there, Please help. I would like to relationship two tables named dbo_ID and Villages (Refer to the attachment). Main purpose is that I would to link Villages to dbo_ID so that eventually I can have all relevant records in dbo_ID relate to X and Y geographical reference in Villages...