Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. aperture

    excel 97 time functions

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

    3218 ("currently locked") error with single user

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

    save action gives "locked by user 'Admin' " error message

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

    save action gives "locked by user 'Admin' " error message

    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)...
  5. aperture

    save action gives "locked by user 'Admin' " error message

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

    preemptive primary key check

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

    option group and type mismatch

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

    option group and type mismatch

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

    editing text on forms

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

    union query not running properly

    Terry- No, that query runs alright. ap
  11. aperture

    union query not running properly

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

    union query not running properly

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

    easy- #name? on forms

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

    easy- #name? on forms

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

    forms to table question

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

    sub and function compile problem

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

    hyperlinks in access 97 - simple

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

    simple arithmetic in access vba

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

    problems creating a recordset on form load

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

    simple vba statement not compiling

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

Part and Inventory Search

Back
Top