Search results for query: *

hello all- i am trying to subtract one date/time column (D) in format #mm/dd/yy hh:mm# from another(E) in the same format, to get a result in format #hh:mm#. since these values are for business time based on workdays, i have written a basic formula to obtain serial number values for the...

hello all- i have a questionnaire database from which i produce a report. the recordset used for the report is generated from several tables and append/update queries. when i try to run the report, i get error description 3218, even without any code specifying a lock type (exclusive, rs...

hello all, i have a rather simple, three table database with three users, running on a novell network. the only reason i mention the network is that this may be a network error rather than an access error. at unpredictable intervals, when users save a record they get a series of three error...

hello all, i have a form which contains several required fields. the first of these is the first in the form's tab order, and its control source is the underlying table's primary key. i would like to check whether the value entered will produce a duplicate in the primary key BEFORE the user...

hello, i have an option group with four choices. i would like assign a text value to each choice for display on a report. on the report, i've got a text box to display the text value, like so; optnThingy= 1,2,3,4 txtThingy = Yes, No, N/A, Pending in the report_open event, i've written a...

hello all, i have a few letters that i've made into access forms. is there any way for a user to edit text (change to bold face, remove phrases, etc.) on such a form? right now, the text is in labels, which can't be edited. suggestions? thanks, ap

hello all- i have written the following sql statement in the row source of a list box. SELECT Null AS strUWorMgrName, Null AS strRACF FROM qryAgfcyVisitbyRACF UNION SELECT DISTINCTROW qryAgcyVisiitbyRACF.strUWorMgrName, qryAGYVISITbyRACF.strRACF FROM qryAgcyVisitbyRACF; when i attempt to...

hello all- i have written the following sql statement in the row source of a list box. SELECT Null AS strUWorMgrName, Null AS strRACF FROM qryAgfcyVisitbyRACF UNION SELECT DISTINCTROW qryAgcyVisiitbyRACF.strUWorMgrName, qryAGYVISITbyRACF.strRACF FROM qryAgcyVisitbyRACF; when i attempt to...

hello can anyone help a beginner out with what '#name?' siginifies in a text box? and what i might to do remove it? the form's recordsource is a query containing the problem fields, and their names are spelled correctly in the query fields, so i dont undersatnd why im receiving this. any...

hello all i have a quick question. i have a form that is linked to a table, and unless the user highlights the values they enter in required fields (text or list boxes), the values do not show up in the table. how can i eliminate this requirement? thanks, ap

i have a public function in a db module called within a private sub in a forms class module. the function is on the right side of an equals sign as follows, without the specific call command: private sub a curb= function c (params) end sub if the parameters are correct, and they have the...

hello all- i am having trouble opening a hyperlink with a command button. the hyperlink is typed into the hyperlink address box in the button's properties window, but when i click on the button the operation times out. can this be done in access 97 or only in 2000? thanks! aperture

hello all i have a do/while loop in a function that should perform an arithmetic expression and return a resulting value to an access form. the compiler does not like my syntax when i phrase the expression as it appears below. i get the error: 'expected statement, not variable.' i also need to...

hello all i am having diffculty opening a recordset i generated from calculated query results. the code that appears below compiles, but when i try to run it, or open the form that it is it attached to, i get an error that says that one of the fields in the query cannot be found. the field...

hello all, working within a class module, the action to be executed after evaluating an if statement is a simple GoTo as noted below. the compiler tells me that the label is not defined, and highlights the GoSub statement. If varInterest_State = "NJ" Then: GoSub...

Grootings! A beginner has a few questions on calculations for anyone willing to help. Can I make the validation rule for a table an arithmetic expression with field names as operands? Tried this in the table properties expression builder, Like so: [field1]=([field2]-[field3])*(.5) In this...