Randomblink
The Irreverent Reverend
- Local time
- Today, 07:45
- Joined
- Jul 23, 2001
- Messages
- 279
Alright...
I have been working with Access for about 8-10 years now...
I am very competent with designing forms and working with VB(A)...
But I cannot for the life of me understand something...
I just built a form, fresh, and no matter what I did... If I went into VIEW mode for it, I got a blank window... No fields... Just a background and the control buttons (min, max, close). I couldn't for the life of me understand what the problem was. The forms' recordsource was to a table with around 4 or 5 records... The form was set to ALLOWADDITIONS... everything was as it should be...
I didn't do any fancy coding for this form...
I didn't do any fancy sql for this form...
So I went to this board (the ONLY place to go for Access Questions) and looked up "Blank Form"... There were of course the HUNDREDS of answers posted about ALLOW ADDITIONS setting to be switched to no... Then there were a couple others about other minor settings...
Nothing I did made the form work...
I changed ALLOW ADDITIONS... I changed the Recordsource to a QUERY built off the table... (basically just a copy). I went to the table and checked and changed the settings... I did EVERYTHING...
Then I ran across a post that made me laugh... The 'idiot' recommended to a BLANK FORM user to copy-and-paste the broken form to a new form... Whatever?!
Ok... After a couple of hours of tweaking settings... I finally created a blank form and copied-and-pasted the broken form into the new form AND IT WORKED!!!!
That 'idiot' was NOT an idiot... Apparently ACCESS was the idiot... Can anyone tell me what happened? I cannot understand what the freak happened with this form... I blew like 2-3 hours on a problem that apparently wasn't anything I did wrong... It was a weird glitch...??? ARGH! Curious...
I have been working with Access for about 8-10 years now...
I am very competent with designing forms and working with VB(A)...
But I cannot for the life of me understand something...
I just built a form, fresh, and no matter what I did... If I went into VIEW mode for it, I got a blank window... No fields... Just a background and the control buttons (min, max, close). I couldn't for the life of me understand what the problem was. The forms' recordsource was to a table with around 4 or 5 records... The form was set to ALLOWADDITIONS... everything was as it should be...
I didn't do any fancy coding for this form...
I didn't do any fancy sql for this form...
So I went to this board (the ONLY place to go for Access Questions) and looked up "Blank Form"... There were of course the HUNDREDS of answers posted about ALLOW ADDITIONS setting to be switched to no... Then there were a couple others about other minor settings...
Nothing I did made the form work...
I changed ALLOW ADDITIONS... I changed the Recordsource to a QUERY built off the table... (basically just a copy). I went to the table and checked and changed the settings... I did EVERYTHING...
Then I ran across a post that made me laugh... The 'idiot' recommended to a BLANK FORM user to copy-and-paste the broken form to a new form... Whatever?!
Ok... After a couple of hours of tweaking settings... I finally created a blank form and copied-and-pasted the broken form into the new form AND IT WORKED!!!!
That 'idiot' was NOT an idiot... Apparently ACCESS was the idiot... Can anyone tell me what happened? I cannot understand what the freak happened with this form... I blew like 2-3 hours on a problem that apparently wasn't anything I did wrong... It was a weird glitch...??? ARGH! Curious...