Struggling With TimeValue
Jul 6, 2006
Hello
I have a query that I'm trying to run.
The first field is a date/time field (tbotime) which is updated hourly
I want to get the results to show just the data from 07:00 and no other times, although I need it to show for each day. So I'd get the data for 07:00 yesterday, today, tomorrow and so on.
I'm beleive the criteria should be some sort of timevalue but everything I've tried either throws up and error and returns no data. I've searched the forum most the afternoon but still seem to be getting no where and now I'm rather confused as to whether I write some code or just put a line into the query criteria.
Currently I have my criteria as TimeValue("07:00"), yes all afternoon for this, I got fed up of seeing errors on my other efforts and this just gives me no data.
Any help greatly appreciated, thanks
View Replies
Sep 17, 2006
Hi all,
I'm new to Access and I've been struggling with this matter for a really long time and would really appriciate any help. Anyways here goes,
I am trying to make a field ( [NIVEA1A] ) become visible in a form where particular Products selected in the combo box [cboproduct] ( located in [colproducts] ) is selected. The [colproducts] is located in [tblProducts] and I would like those values that contain a "yes" value in the [NIVEA1] coloumn make the [NIVEA1A] field appear. The [NIVEA1A] Field populates a [colNIVEA] located also in tblProducts. So what I have so far is as follows:
IIF(Dlookup("colNIVA1]" , "[tblProducts]", "[cboProduct] = [colProduct]").Value = Yes, [NIVA1A].visible = True, [NIVA1A].Visible = False)
I hope it all makes sense
And any help would be really appriciated!
View 2 Replies
View Related
Jan 29, 2007
Is there any clear cut way to directly access a cell in a table via code?
Ive looked as far as my eye can look to try and find something quick and easy that allows me to cherry pick data out of a table, but ive had no luck.
For instance, I have a table named tblSANConnections with a field in it named fldServername.
I want a command button to go into tblSANConnections and snag information from fldServername of the current record displayed on my form, and hell, I dont know put it into a variable.
Can someone toss out a few key codewords that I can lookup to accomplish what im after? thank you
View 2 Replies
View Related
Jun 22, 2007
Can someone help, please?
I have a simple form to add a new record.
Form is
Single
Bound
DataSource is a simple select query which includes all records in a table.
All I want to do is validate what is typed into the textbox.
I have the following code in the BeforeUpdate Event of txtTest:
Private Sub txtTest_BeforeUpdate(Cancel As Integer)
If Me.txtTest = "Test" Then
Cancel = vbCancel
Me.txtTest.Undo
End If
End Sub
It works fine on an Edit but when I type "Test" into a new record and try to move or save I get the error: The value in the field or record violates the validation rule blah blah BLAH.
Why doesn't vbCancel kill this nonsense?
View 14 Replies
View Related
Mar 9, 2006
Hello people,
I'm not a programmer, I am infact a 17 year old College Student from the United Kingdom - Studying ICT!
For my major project I have to design, build and test a camera loans system for my photography department. Except, I am having problems with Combo box lookups. It's been over 6 months since I learnt this, and it's all a blank. Something as simple as this is simply not working...
e.g. in the Studentloans table, I wish to enter the Student ID number from the student ID card inside the combo box, and hit enter so that it brings up the relevant specific loans of that student.
I enter the id, hit enter and the student name, class etc does not change. Why? The same goes for my Camera Maintenance Table, Camera + Maintenance tables are combined to a CAMERAMAINTENANCE TABLE - Therefore I wish to enter the Camera ID number so that if i hit enter, it brings up the relevant service histories of that specific camera...
The relationships are all ok, the fields for Student ID are lookup, etc.
I don't understand. It's driving me insane. I need help with this, I'm struggling so much.
Help much appreciated.
Thanks - Neil.
View 1 Replies
View Related
