Search results

  1. G

    Text Box between labels

    Hi, I am placing bound text box between two labels. How to adjust the width of the text box dynamically based on the length of data in the text box. Can shrink or can grow property is not helpful. Please help. Thanks
  2. G

    Avoid null values in a query

    Thank you, I will.
  3. G

    Avoid null values in a query

    So far, I don' have a DB! Just doing a planning. Anyway, thanks for trying to help me. If there is any better way please let me know. Thanks
  4. G

    Avoid null values in a query

    like joint custody or not, any pending cases, visitation rights, whether seeking child support, whether own property jointly, seeking monetary award, whether limited divorce etc., like these there are many questions. All are not applicable to everyone. Based on the answer, I will have hidden...
  5. G

    Avoid null values in a query

    It is a legal form related to divorce cases. Divorce based on various reasons and various claims like custody of children, alimony etc. The user will have only check marks. Based on their selection, a lengthy legal doc is generated in word as a retainer. It is for an attorney client (plaintiff)...
  6. G

    Avoid null values in a query

    Hi, I am creating a report which will be exported as a word document with the values from a query. The user will have a questionnaire form with check marks. There are around 100 questions. The user may check around 25 questions with check mark. I want to have the report generated only with the...
  7. G

    Outlook Task Error

    Thank you, sorry for the trouble.
  8. G

    Outlook Task Error

    Yes, I did. Thanks
  9. G

    Outlook Task Error

    Please help me, I am getting this error for the following code: Run time error: 91; Object variable or with block variable not set Thank you. ************************************** Private Sub SendTask() Dim outlookApp As Outlook.Application Dim outlookTask As Outlook.TaskItem Set outloopApp...
  10. G

    Filter Forms Record Source based on Computer User Name

    Thank you I found out my mistake. You can ignore. Thanks.
  11. G

    Filter Forms Record Source based on Computer User Name

    I added (AssignedBy] also in the select query. It fetches all the records, ignoring Environ criteria. MyString = "Select * from PendingQry where [AssignedTo] OR [AssignedBy]='" & Environ("UserName") & "'" What I am doing wrong? Thank you.
  12. G

    Filter Forms Record Source based on Computer User Name

    Hi theDBGuy, thanks so much. Just completed this one. It seems it is working. If I need to change anything, please let me know. Thanks for your help and time. I will be adding error handler. Private Sub Form_Load() Dim Dbs As Database Dim Rst As Recordset Dim MyString As String Set Dbs =...
  13. G

    Filter Forms Record Source based on Computer User Name

    The above code I tried with this SELECT * FROM SubmissionFrm WHERE [Assignedby]= Environ("UserName") in the form record source property Got error message: ......specified on this form or report does not exist. Please let me know how to fix this. Thank you.
  14. G

    Filter Forms Record Source based on Computer User Name

    Ok. I will It helps me very much. Thanks.
  15. G

    Filter Forms Record Source based on Computer User Name

    Thank you. It helps. It is a table. Thanks
  16. G

    Filter Forms Record Source based on Computer User Name

    Thank you theDBbuy. I do not have a query yet. Otherwise I have a fields with the names Ticket No, Task Status, Assigned By, Assigned To, Start Date, Due Date, Completed Date, Task Title and Task Description in my tblTask. How to add criteria to current user in a query? Please let me know...
  17. G

    Filter Forms Record Source based on Computer User Name

    I have a form with a text box with control source to "Assigned By" (name of the person assigning the task ). It's default value is the User Name of the computer. I am able to do this. After that, I wish to have the form's record source criteria with the user name of the computer. In other...
  18. G

    Converting desktop database to web

    Thank you.
  19. G

    Converting desktop database to web

    Can we host the back-end in SQL server? What could be the web technology? I googled, it says php or .Net. Is it correct? Thanks
Back
Top Bottom