If I understand it, who are you kidding? Getting there - I think : )
Ok, so wheres the
Code:
[left]SELECT Alias,[Cheval] FROM Cheval WHERE HumanEyeIsNull([Cheval]);[/left]
Phille
Last Activity: Feb 12 '07, 07:09 AM
Joined: Jan 17 '07
Location:
-
Hmm
If I understand it, who are you kidding? Getting there - I think : )
Ok, so wheres the
Jokes aside. So you mean the only way to be sure to get all the data is by combining the ="" and IsNull? Sounds complicated. -
Hi again
Sorry for not giving a response erlier - my computer died on me.
Now I'm up and running again.
No it was pasted in the reply box. Try it yourself,copy a few columns from a table and paste them in, they look fine untill you submit it.
Anyways thanks for the help. But I'm getting really confused of how Access interprets the two commands, with criteria ="" I get those...Leave a comment:
-
Sorry about that, the table showed up fine when I was writing the post the post. What did go wrong?Leave a comment:
-
Code:SELECT Cheval.Alias, Cheval.Cheval FROM Cheval WHERE (((Cheval.Cheval)=""));
Code:[b]Query1[/b]ChevalAlias N05/Attrape N05/Porta Marzia N06/Fleur en Fleur N06/Palmeira N06/Porta Marzia N06/Tashkiyla
...Code:[b]Cheval[/b]ChevalAlias N05/Maria de la Luz N07/Fablimixa N07/Mahima N07/Morning Rose N07/Tashkiyla N06/Bayourida N06/Flora
Leave a comment:
-
Otherwise a simple append query that grabs the info directly from the control will do.Leave a comment:
-
Table cells not empty?
Hi
I have a table wich can posses empty fields, then I have a query that only show rows from the table when that specific field is blank (critweria ="" (also tried =Null)).
Ok! It works fine, untill the field gets a value (obviously) but when I empty the field again it dosen't reappear in the query.
Any ideas? Using XP with Access 2007 Trial
Thanks in advance -
Theres also an example access file on microsofts download page that does exactly this
http://www.microsoft.com/downloads/d...DisplayLang=en
Have a lookLeave a comment:
-
IT WORKS!!!
Thanks a million : )Leave a comment:
-
Thanks for the response but now it dosen't clear anything??
Any other suggestions?
ThanksLeave a comment:
-
Hi again
So! I haven't yet receved my book so mean while I'm still stuck knowing a little less than nothing about VBA programming.
Could there be anything done about the code giving an error when there are controlled objects on the form. For the moment I have a textbox that gets data depending of values from other controls. For example just ignoring those objects.
Thanks in advanceLeave a comment:
-
Yes I know everyone has been here, it was just the preassure valve that bursted.
You know the fealing? You think you know what you are doing but it just won't work, copy/pasting, reading helpfiles etc for hours.
This is called anger management : )Leave a comment:
-
Thanks allot
I used to be a computer administrator at a small firm but never had the need of programming, so I just let it be. Then one day someone came in and asked me if I knew anything about the "For Dummies" series of books (which I didn't), but I answerd "Oh them, they are for morrons".
Guess what! I just ordered 400 pages of "Programmin g Access 2007 For Dummies"
What...Leave a comment:
-
Thanks
But I can't get it to work it starts whining about the privet sub
...Code:Private Sub Command45_Click() 'ClearUnbound empties all controls on an unbound form. Public Sub ClearUnbound(frmMe As Form) Dim varCtrl As Variant For Each varCtrl In frmMe.Controls With varCtrl Select Case .ControlType Case acCheckBox, acComboBox,Leave a comment:
-
Hi NeoPa
I've always wondered why the hepfile examples used commas when my machine just keep giving me errors when I use them. Now when I look at my regional settings (which are finnish) I see that my list separator is ' ; ' while it can be changed to a ' , ' . Wierd! I have always thought that codes shuld be universal?? Anyone knows the truth?
By the way, thanks for the format command, hadn't realised it.Leave a comment:
-
Hi
I couldn't me more confused, I understood about 10% of your text (my head gets twisted halfway) but I think it should work with an IF sentence in the criteria field of your query. In that way you could tell your query to do the calculation if there is a value in the abcent field otherwise it just skips the calculation.
I'm in a hurry for work but hopefully this helps a bitLeave a comment:
-
Adding multiple values in a listbox to a table
Hi
I have a form with a few textboxes and some listboxes with multiple values allowed. I would like to use an append query to insert everything into a table but for some reason it just gives me no values at all for the listboxes (the textboxes are ok). Is there something that could be done.
Thanks in advance -
I just realised that you wanted to invert the months with the days
so then it should be:
=Left([InvCode];3) & Mid([InvDate];4;2) & Left([InvDate];2)
; )Leave a comment:
-
Hi
I have no idea in what you are trying to do this but if you have a form
you make your textbox/field whatever named InvNum which Control Source you specify as following
=Left([InvCode];3) & Left([InvDate];2) & Mid([InvDate];4;2)
Hope it helpsLeave a comment:
-
yiiiihaaa!!!
It worked thanks everybody, 2 days of misserable pain is over.
If someone still has a command for clearing the whole record/form please post but with this I will already come a long way.
Thanks againLeave a comment:
-
Still completly lost.
I've made a new form thats not bound to enything added a textbox (unbound) and a button. I set the OnClick to both Me.Refresh and me.RecordSource =me.RecordSourc e.
------------------------------------------------------------------
Private Sub Command2_Click( )
Me.Refresh
End Sub
------------------------------------------------------------------
Private Sub Command2_Click( )...Leave a comment:
No activity results to display
Leave a comment: