Search:

Type: Posts; User: deekatz; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Replies
    1
    Views
    680

    Read/Write Permission Via Apllication

    I am posting this question on behalf of a friend. Hope I get the problem right. For some reason he needs to allow a few of his users read and write permission to a certain folder on our network...
  2. Re: SQL server ecords not showing up (Access XP)

    Sorry. But no, the knowledge base wasn't of any help. I found a solution though. Instead of the creating the query within MS Access project I just created a view of base on the same select...
  3. Re: SQL server ecords not showing up (Access XP)

    I have created an Access project database that is using records stored on the SQL server. On one of the tables, there is more than 300000 records. But when I tried to see the table from Access...
  4. SQL server ecords not showing up (Access XP)

    I created an SQL query which give over 9000 records when run from the SQL server query analyser. But if I run the same query from Ms Access query grid, it is only returning 156 records. I have...
  5. Replies
    1
    Views
    295

    Calendar Control (Access 2K)

    I have several calendar controls on my forms (using Class MSCAL.Calendar 7.0, Calendar Control 8.0) . For easier data entry, my users find it helpful for the day of the week to start from Monday. ...
  6. Replies
    4
    Views
    1,411

    Re: combobox (VB.NET 2005)

    Tried this and tried that. It finally works. Have to make sure the bindingsource fot the lookup table is included, set the datasource, binding source...bla.bla.bla. But it works
  7. Replies
    4
    Views
    1,411

    Re: combobox (VB.NET 2005)

    umm..i am not sure. but i have a dataset which based on a table on the sql server. the lookup table is also on the server.
  8. Replies
    4
    Views
    1,411

    combobox (VB.NET 2005)

    Second day getting to know vb .net. Not a good experience. Can someone tell me what are the steps that i need to take to bind listbox to a lookup table. I have created a form which is based on...
  9. Replies
    3
    Views
    668

    Re: SQL/XML (vbnet)

    I am trying to export data into an xml document following a predefined schema. I' using sql2000.
  10. Replies
    3
    Views
    668

    SQL/XML (vbnet)

    I am trying to combine two select statements into one and I am not geting any luck with it. Can someone help out?

    SELECT statement1
    SELECT
    XMLELEMENT( NAME "household",
    XMLATTRIBUTES(...
  11. Replies
    2
    Views
    320

    Help With SQL statement (Access2K)

    Can anyone help me with this SQL syntax?

    strSQL = "INSERT INTO tblFromCMISMasterRecord ( MasterRecordID, SSN, FirstName, MiddleInitial, LastName, AddressLine1, AddressLine2, ZipCodeID,...
  12. Remove hyphens to store SSN as number (Access2K)

    One of the fields in a legacy table stores SSN as text (999-99-9999). A field in the new table stores SSN as number(999999999). I need to move the text ssn into a field in the new table as number. ...
  13. Re: Map SQL table to XML schema (SQL Server 2000)

    oops. sorry. it is a typo. and yes, i need to follow the schema created by an outside party. I am a newbie in XML, SQL/XML as well .NET. Can you possibly point me to the correct way of...
  14. Map SQL table to XML schema (SQL Server 2000)

    I hope this is the right place to post this question.

    I have a table which I need to make into an XML document. But the XML document must follow a schema not created by another party. What is...
  15. Change Form Caption When Moving From Records (Access 2k)

    How can i accomplish this...
    As I move from one client's record to another I want the form caption (frmClientInfo) to display the form name and in parenthesis the client's first and last name. FOr...
  16. Replies
    10
    Views
    536

    Re: Concatenation and commas (Access 2K)

    Thank you! Thank you! Thank you. I am forever indebted!
  17. Replies
    10
    Views
    536

    Re: Concatenation and commas (Access 2K)

    Hello hans, francois
    I am attaching a barebone version of the databse I am working on. I kinda able get the counter and part of the concatenation done but I am not sure how to iterate so I can get...
  18. Replies
    10
    Views
    536

    Re: Concatenation and commas (Access 2K)

    I hope this help Hans.
    For each symptom I have a checkbox (chkSymptom1 through chkSymptom11). Each corresponding texbox that my user user will be filling in on as needed basis is named txtSymptom1 ...
  19. Replies
    10
    Views
    536

    Re: Concatenation and commas (Access 2K)

    Yes, there is a textbox for each checkbox and no, the users doesn't always have to fill in each textbox.
  20. Replies
    10
    Views
    536

    Concatenation and commas (Access 2K)

    I have a form on which the user will list all of or some the symptoms identified on a patient. Some patients will display only one symptom while others might displayed 3,5, 8 or 10 other symptoms...
  21. Copy a record to a table in a different database' (Access 2K)

    I have a frmClients that is based on tblClients. Whenever a client is deleted from this form/table I would like for the record to be copied to a table in a different database. Despite prompting my...
  22. Calling a procedure from a subform (Access 2K)

    I have a form with a subform in it. The main form (frmTreatmentHeader) tracks info about who is the client, when is treatment, etc. The subform (frmTreatmentDetail) list all the procedures done...
  23. When to use .Value vs .DefaultValue (Access2K)

    Can someone please explain the diiferences between Me.DefaultValue and Me.Value. When should I use one instead of the other? Thank you so much.
  24. Replies
    2
    Views
    265

    Re: Is It Possible (Word 2K & Access 2K)

    Thank Hans. This is exactly what I was looking for.
  25. Replies
    2
    Views
    265

    Is It Possible (Word 2K & Access 2K)

    To create a form using Word and have the information in the fields saved to an Access table?
Results 1 to 25 of 46
Page 1 of 2 1 2