Hi,
I have encountered error in opening my access DB,
Please find attached image of error window while i am opening the DB.
I am in trouble, Please advise.
--
Best Regards,
Preju
[Non-text portions of this message have been removed]
Mudah-mudahan dengan keberkahan bulan ramadhan ini , Bang Haer cepat sembuh dan bisa memandu Milis ini lagi.
| Sudarsono Suhenk <jkssbma@live.com> Sent by: belajar-access@yahoogroups.com 08/01/2011 09:38 AM | To: belajar-access yahoo.com <belajar-access@yahoogroups.com> cc: Subject: RE: [belajar-access] Bang Haer sakit. |
Semoga cepat sembuah dan dapat menjalankan ibadah puasa dengan sempurna.
| Mudah-mudahan Allah segera memberikan kesembuhan kepada Bang Haer. amin..... Salam, |
| Amin... Amin... Amin... --- On Mon, 1/8/11, Budhi Prasetyo <budhi.prasetyo@gmail.com> wrote:
|
Terimakasih atas sarannya Bpk Sudarsono,namun ketika saya ganti rumusnya,angka "0" nya hilang,cell menjadi blank (data kembali ke kondisi semula)
Terima Kasih
Sent from my BlackBerry® smartphone from Sinyal Bagus XL, Nyambung Teruuusss...!
You're welcome, Crystal.
Looks like I fat-fingered another post. <g>
#1 should have read "Access seems to know how to size a form PROPERLY when you
do that."
#2 should have read "THEN save it."
Regards,
Bill
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Crystal
Sent: Sunday, July 31, 2011 12:12 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Re: my popup sometime opens in that stupid black
minimized rectangle
hi Bill,
thanks! ... definitely going into the archives ...
Warm Regards,
Crystal
*
(: have an awesome day :)
*
--- On Sun, 7/31/11, Bill Mosca wrote:
> Terence
>
>
>
> This is what I do to prevent a form from sizing itself
> weirdly:
>
> 1. I always design in maximized
> size. Access seems to know how to size a
> form property when you do that.
>
> 2. If a form opens with the wrong
> size I go to (Acc2003) menu>window>size to
> fit form;(Acc2010) Home>window>size to fit form. Ten
> save it.
>
> To make things even easier, I develop with a macro named
> AutoKeys. There is an
> old one in our files section. With it, all I do is press
> Ctrl+B. It does all the
> work in one motion.
>
>
>
> Regards,
> Bill Mosca,
> Founder, MS_Access_Professionals
> That'll do IT <http://thatlldoit.com> http://thatlldoit.com
> MS Access MVP
> <http://mvp.support.microsoft.com/profile/Bill.Mosca>
> http://mvp.support.microsoft.com/profile/Bill.Mosca
>
>
>
> From: Terence
>
> Well I just went through opening them all up, there are 12
> I think, I re sized
> them all, and save them properly. Close the DB, then went
> for coffee. I came
> back and they all worked but one. So I re sized it. I will
> drink more coffee and
> try again. I think the pattern has something to do with the
> US Congress raising
> the debt ceiling.
>
> :)
>
> I just wished I had a bit more certainty and confidence
> that these windows will
> act as I want them to. This application is being used for a
> Geriatric Physical
> Therapy clicnic, and some of these forms will be used on
> Tablets. I prefer NOT
> having DOCS throw the tablets at patients :)
>
> --- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com> ,
> "buffalome90210"
> <buffalome90210@...> wrote:
> >
> > TY Crystal, my mehtod of open is the standard stuff, I
> am using a Macro
> > OpenForm History 3 Meter Walk Test Fast, Form, , , ,
> Normal
> >
> > as far as the properties for the form named
> > "History 3 Meter Walk Test Fast"
> > I have tried about everything, It's NOT MODAL, and it
> is popup.
> >
> > Default view is split with datasheet at bottom
> > Control Box - yes
> > Scroll bars Yes
> > MIN MAX - NONE
> > Close Button - Yes
> > No Navigation Buttons
> > Border style = Sizable
> > Auto center - No
> > Auto resize - yes
> > Fit to screen - yes
> >
> > These are my current settings......The odd thing is ,
> it does not always
> resort to that weird rectangle thingy.
> >
> > And I am unable to predict it, or determine a
> pattern.
> >
> > My pie in the sky solution wouold be to find the
> property that says:
> >
> > Weird Rectangle Thingy = NO
> >
> > Anything obvious ?
> >
> >
> >
> >
> >
> >
> >
> > --- Crystal <strive4peace> wrote:
> > >
> > > Terence... sorry I spelled your name wrong! I
> fixed it ... so no evidence
> but the original post ;) ~Crystal
> > >
> > > --- On Sat, 7/30/11, Crystal wrote:
> > >
> > > > hi Terence,
> > > >
> > > > sorry you are frustrated ... maybe it is
> time to take a
> > > > break -- sometime that is better than
> working so you can get
> > > > your mind fresh again. I need a break
> too ... maybe I
> > > > will go singing tonight ;)
> > > >
> > > > > "ridiculous rectangle"
> > > >
> > > > are you referring to dialog view which make
> a form appear
> > > > as a popup? Please post the procedure
> that opens your
> > > > form so we can see your parameters to
> DoCmd.OpenForm
> > > >
> > > > also, check the following FORM properties:
> > > >
> > > > Default View
> > > > Popup
> > > > Modal
> > > >
> > > > Warm Regards,
> > > > Crystal
> > > >
> > > > *
> > > > (: have an awesome day :)
> > > > *
> > > >
> > > >
> > > > --- On Sat, 7/30/11, Terence wrote:
> > > >
> > > > > Frustrated.
> > > > >
> > > > > I have a popup form with a button. The
> button uses a
> > > > macro
> > > > > to open another popup from. The macro
> uses "normal". I
> > > > have
> > > > > tried a plethora of options on the
> format of this
> > > > form,. yet
> > > > > time after time this stupid form open
> up in that ugly
> > > > > ridiculous rectangle, that confounds
> most people of
> > > > the
> > > > > world on what the hell to do with it.
> > > > >
> > > > > FRUSTRATED~!!!!!!!!!!!!!!!!!!!
> > > > >
> > > > > I want an option, a WAY, so this form
> can NEVER get to
> > > > that
> > > > > state !
> > > > >
> > > > > Terence
> > > > > sorry for my pontifical rhetoric.
> > > > >
> > > >
> > >
> >
>
[Non-text portions of this message have been removed]
Mas, rencananya mau berangkat kapan ?
regards,
Tio
| murid belajar access <murid.belajaraccess@yahoo.co.id> Sent by: belajar-access@yahoogroups.com 08/01/2011 09:14 AM | To: "belajar-access@yahoogroups.com" <belajar-access@yahoogroups.com> cc: Subject: [belajar-access] Bang Haer sakit. |
Dear rekan2 sekalian. Sebelumnya saya mengucapkan selamat menjalankan ibadah puasa. Semoga riyadhah kita diterima Allah SWT.
Sayang sekali abang kita bang Haer tidak bisa ikut puasa karena saat ini sedang terbaring sakit di RS Meilia karena diare berat, tekanan darah drop
Ada yang mau jenguk?
Edy Wiyono
Tambahkan saja satu text box lagi dengan rumus : IsError([TOTAL];0;[Jumlah]).
regards,
Tio
| "muh. yudhy guztaman" <eat_freshthings@yahoo.com> Sent by: belajar-access@yahoogroups.com 08/01/2011 07:41 AM | To: "belajar-access@yahoogroups.com" <belajar-access@yahoogroups.com> cc: Subject: [belajar-access] Penggunaan Iif Builder [1 Attachment] |
Selamat pagi rekan-rekan
Saya memiliki permasalahan terkait penggunaan Iif , adapun permasalahan yang saya jumpai sebagai berikut:
1. saya memiliki data beupa tabel (terlampir)
2. saya ingin mengisi cell yang kosong dengan angka "0", rumus yang saya tulis sebagai berikut:
TOTAL: IIf([Jumlah]<>"";[Jumlah];0)
3. Cell yang kosong berhasil diisi angka "0", namun cell yang berisi angka menjadi "#Error"
Pertanyaan:
Bagaimana penggunaan Iif sehingga cell yang berisi angka tidak menjadi "#Error"?
Terima kasih atas bantuan rekan-rekan
Regards
M Yudhy Guztaman
Mudah²an ALLAH segera memberi kesembuhan ke Bang Haer.
Aamiin...
Dear rekan2 sekalian. Sebelumnya saya mengucapkan selamat menjalankan ibadah puasa. Semoga riyadhah kita diterima Allah SWT.
Sayang sekali abang kita bang Haer tidak bisa ikut puasa karena saat ini sedang terbaring sakit di RS Meilia karena diare berat, tekanan darah drop
Ada yang mau jenguk?
Edy Wiyono
| Mudah-mudahan Allah segera memberikan kesembuhan kepada Bang Haer. amin..... Salam,
|
| Mudah-mudahan Allah segera memberikan kesembuhan kepada Bang Haer. amin..... Salam, Peta Industri dan Wisata Cilegon
komersilkan blog atau website anda dengan bergabung di sini atau di sini
--- On Mon, 1/8/11, murid belajar access <murid.belajaraccess@yahoo.co.id> wrote:
|
