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...

gol4 thanks. i thought it must be a network issue as the database itself is very small, very simple, very young, and has very few records. my only other thought is that one of the users may have a small utility program (screen saver, desktop...) that interferes with access/novell somehow...

MD (and all- please help!), i appreciate your post...my problem may indeed be something rather obvious. but, the user/group permissions are appropriate. (check) default openmode is shared, default run permissions are the user's, and record locking is set to no locks. (check, check and...check)...

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...

thornmaster, jerby- thanks! both worked...im a happy ap. john tarleton

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

Terry- No, that query runs alright. 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...

thanks tempclerk, uncle jack in a related development- will i have a problem updating the form's recordset if the record source is a query? my other alternative is to make subforms out of the various groups of fields on the form and to make the recordsource the form's own table. i have a...

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...

Databaseguy good call. literally. it worked well, thanks! ap