in this case it depends...
changing it to a texxt box can help if ure typing everything in yourself. If so then i believe a text box would be more beneficial then any numerical field you would have in there since with a text field it reads it as is; however, with a numerical field 1.23 is the same as 1.2300000000. so how exactly are you using this data?
vkong85
Last Activity: Jul 19 '07, 07:07 PM
Joined: Jun 4 '07
Location:
-
you can run the textbox off a append query so everytime you requery it appends it onto the table.Leave a comment:
-
oops. i meant i just made a macro got too carried away with the big words...Leave a comment:
-
You would serve better to write a filter code then using dlookup. From what i know dlookup can only search for one value at a time.Leave a comment:
-
Query Criteria with dates
I am trying to write a query that will only display records between today's date and 30 days.
I've tried several different ways but nothing seems to work. Currently in the criteria of the date column in the query i have the following code:
Between (Date()) And (DateAdd("m",1, Date()))
The logic behind this was that it would take all records between today's date and today's date +1. Thats the... -
i found the solution. It was before update but instead of VBA code i just used the object oriented programming and made myself a macro. Thanks.Leave a comment:
-
There are two things that you can do. As said before be sure that you are regularly compacting and reparing your database through "tools> database utlities> compact and repair database" this usually takes care of most problems. Another solution is to basically split your database in two. So that data is linked from two databases both which contain half of the information. this way you can get two 1 gig databases instead of one full...Leave a comment:
-
dlookup ( "[field that you need]","[table that the field is located]","any criteria you may have")
ex:
dlookup ("[name]","[tbl people]"," ID = [tbl people][id]")
so in the example above you are looking for a name in the people tbl so long as the id's match.Leave a comment:
-
Its running now but nothing seems to be changing. The values are staying the same. After I changed it to a beforeupdate the msgbox would no longer pop up as if it wasn't being read. What I'm trying to do is read the username after a record has been changed thats why i chose to use the afterupdate.Leave a comment:
-
If the combo box's recordsource is only 'yes' and 'no' then you should think about using a check box. This way the user only has one option either checking it or not. It can make you program run a little more efficient. Also you can default the value for the check box by making the default value in properties =NO. However, if the combo box is dynamic (meaning that you have multiple options to fill the combo box's values then you can make it default...Leave a comment:
-
Afterupdate Error
Currently I am running a database in order to keep track of projects. One of the fields in the project tracking is a bit of code which tells me (if someone changes the records) who changed it and when. I am currently running some code to do this but i keep getting an error
my code:
Private Sub Form_AfterUpdat e()
Me.LastModified = DateValue(Now() )
Me.By = MODBY
Me.Refresh
End Sub
... -
what exactly is the problem with the onclick event coding?...Leave a comment:
-
To answer ure first topic all i would do is create an event procedure that has if statements to analyze whether or not the data is correct so for example:
dim datecorrelation 1 as long
dim datecorrelation 2 as long
datecorrelation 1 = me.date1
datecorrelation 2= me.date2
if (datecorrelatio n2> datecorrelation 1) then
exit sub
end if
something like this...Leave a comment:
-
it seems to me you can just use a query to count how many right and wrong answers ure kids get on the test at the end of the test you can just get simple report off a query and it should just tell them how many right and wrong.Leave a comment:
-
something that's really simple is to just place a control button into the form. Simply choose the control button option from the toolbox when in design mode for the form and access will walk you through the rest and write the VBA code for you!Leave a comment:
-
you can just use a query following watever criteria in order to single out the result you want. You can use something along the guidelines of
LIKE *& ...... &* : which would return a value similar to what the ... are
or you can use numerical criteria in order to filter the right answerLeave a comment:
-
i think i know what you are trying to accomplish because i've done the same. what i did (through some struggle) was figure out how to use a DLookUp. Basically its a command that tells the computer to lookup a certain value from a field given a certain criteria.
So if ure master field has the course number and the description then it will match the description to the course number and all you have to do is tell the computer where to...Leave a comment:
-
i figured out the problem. for future reference when using macro's to build an expression that will retreive a string value do not use an equals (=) sign in the expression field. the equal sign will command access to search for a property with the retrieved name which in many cases will give an error message. thanx rabbit for the help!Leave a comment:
-
ok so i was playing around with the macro and i seem to got it to work but there's another problem that popped up...
"The object doesn't contain the automation object ' description retrieved '. you tried to run a visual basic procedure to set a property or method for an object. However, the component doesn't make the property or method available for automation operations. Check the component's documentation for information on...Leave a comment:
-
yes im doing it through expression builder under the 'build event' option...
is there another way to populate the field without using dlookup?
what i'm trying to accomplish is filling a field with a value that is retrieved from another database so far as a 'username' or 'account number' is the same...Leave a comment:
No activity results to display
Leave a comment: