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!

  • Congratulations SkipVought 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: *

  • Users: dkape
  • Order by date
  1. dkape

    Set report field height to match another field value

    Hello, I was wondering if it was possible to set the height property for a text box on a report to be equal to the height of another field (text box). Such that if one text box grows due to the size of the data in it the other text boxes for that same record will grow to match it. thanks
  2. dkape

    How to determine number of records applied by filter

    I have a form which when opened applies the following filter. DoCmd.ApplyFilter , "USER_ID =" & "'" & Me![UserName] & "'" & " AND " & "USER_PASSWORD = [Enter Current Password]" Me![UserName] is supplied by a module and [Enter Current Password] is a user prompt opened when opening the...
  3. dkape

    sync (unix)samba users with windows users

    I just installed samba on a sun machine running solaris 6. I was able to share out the directories on the sun machine ok and can map windows drive letters to the samba shares. The Samba machine is not a PDC What I haven't been able to figure out is how to make the unix file permissions match...
  4. dkape

    Can I change form field font from radio button

    I have a form which has a series of 5 radio button, and a text entry feild. I would like to associate a font with each radio button and change the font of the text entry field to the select font. Has anyone done this? I don't know if I should try to control the font by usign styles or some...
  5. dkape

    Formmail log error

    Disregard this question. I must have uploaded the script in bin mode and hosed the file. When I resent it via ftp in ascii mode it worked fine. Learn as you go.
  6. dkape

    Formmail log error

    I'm trying to set-up formmail on a virtual server. I modified the script for my domain and changed the permissions to 755. But when formmail is called from the web form, I receive the following error on my browser: Internal server error. The log on the server says; fopen failed to open log...
  7. dkape

    How to refresh form on each new record

    I currently have form, which on open sets the enable and locked parameters of feilds on the form based on certain record criteria. I.E. if x=1, then feild1.locked = true, else feild1.locked = false. This works fine for the first record, but when the 2nd record is selected the locked and...
  8. dkape

    RE:FAQ705-1971. a Word/Excel/Picture/Any Other File from Access?

    I'm trying to use the code from this faq to allow users to open external files from a form. In the code on the form I've tried two different bits of code, neither work the way I'd hoped. One is: DoCmd.OpenStoredProcedure (fHandleFile("c:\test.txt", WIN_NORMAL)) Which opens...
  9. dkape

    use if-else logic based on null record set

    Thanks for the feedback. Could either of you give me some more information on using VB to get the recordset as you mentioned. I'm not familiar with how to do that. Thanks, Doug
  10. dkape

    use if-else logic based on null record set

    I currently have an access db in which the autoexec macro runs an exception report and then e-mails the report to two users. I have this db run automatically each night, so each morning the report is in the user e-mail inbox. Sometimes the query that the report is based on returns no data...
  11. dkape

    Can macro perform if-else logic

    I currently have an access db in which the autoexec macro runs an exception report and then e-mails the report to two users. I have this db run automatically each night, so each morning the report is in the user e-mail inbox. Sometimes the query that the report is based on returns no data...
  12. dkape

    DoCmd.OpenReport with two stLinkCriteria & wildcard

    I'm trying to use the DoCmd.OpenReport function with two stLinkCriteria & a wildcard feature on one of the slc. When I enter data in these feilds on the form, a DataTypeMismatch error is returned. Can anyone see if there is an error in the code? The table which the query for the report is...
  13. dkape

    What is the purpose of VAL() function.

    I'm trying to fix some bugs with an access db I inherited. I'm running across the VAL() funtion in queries and am unable to figure out what the purpose of the VAL() function is. Can any post quick explanation. Thanks
  14. dkape

    Using the windows logon ID to determine form to start

    I've been using the information in FAQ 181-93, titles "How do I get and use the Windows Login ID? " I've gotten to the point where my database properly identifies users in the tblValidUsers table. Now I want have different forms start based on the persons login id. I've appended the...
  15. dkape

    Help needed with removing carriage returns

    I have a script which parses through a test document ans removes unwanted lines. What I am having trouble doing is stripping away carriage returns for lines that meet a predetermined criteria. The following is a portion of the script. while(<STDIN>) { /^ Some text matching:(.*)/ && do { #...
  16. dkape

    Form filter button on form

    Thanks, for the reply. What I actually want to do is give the user a way to un-apply a filter, and show all records.
  17. dkape

    Form filter button on form

    Is it possible to put the apply for filter button ( the hour glass button, which is on the menu bar) on a form?

Part and Inventory Search

Back
Top