Recent content by SteveVS

  1. S

    DSN-less connection not storing password

    The settings are set to use it that way and has been from the beginning But the problem still persist The steps run through the part where it sets the credentials to use sql server but it stills default to windows auth What confuses me is that this solution worked on another Access db using...
  2. S

    DSN-less connection not storing password

    That is what is the odd part. As I run through the code stUsername is set "USR" I can see this clearly within the variable and in the connection string
  3. S

    DSN-less connection not storing password

    I am aware of the security risk his type of solution exposes but due to reasons im forced to use this approach I need to store the sql login credentials in the connection string I have succesfully done this for a other application but it doesnt seem to work again When the code runs it shows...
  4. S

    Subform Calculated Column

    It is in the query
  5. S

    Subform Calculated Column

    on the subform there is a calculated column that populates a checkbox I tried to check if the checkbox is checked or not on the before update event but i saw that the calculation is done even before the event is fired How can i do the comparison before the column is recalculated
  6. S

    Copy from certain value

    Hi How do I copy from a certain character in a string? Example Flaperon Composite Parts: Stage 2 Fuselage Jet Composite Parts: Stage 3F I want to copy everything that follows the :
  7. S

    Access Sql paramatized query assitance

    At the beginning. It is like it won't compile at all
  8. S

    Access Sql paramatized query assitance

    Hi all I'm still new to the access world and I require your assistance once again i call this stored procedure on sql ALTER PROCEDURE [dbo].[sp_StockMovement] @type CHAR(1), @itmcd VARCHAR(25), @descr VARCHAR(60), @jsbtch VARCHAR(25), @poprj VARCHAR(20), @spldpt VARCHAR(50), @frmdt...
  9. S

    Access Listbox

    This is how the data is displayed Unfortunately, I can't upload the DB
  10. S

    Access Listbox

    It doesn't even correctly display with the break point. some rows only show the "date" and not the other fields while other rows show the other fields but not the "date" field
  11. S

    Access Listbox

    I have Tried that but still gives the same errors
  12. S

    Access Listbox

    Yes I do get the correct results from the query when I run it
  13. S

    Access Listbox

    Hi all. I require a bit of assistance with a list box I populate the list box from a SQL query the query works fine and the column widths are properly defined But the problem is it doesn't show the "Description" of the first Row and none of the "Date" columns But when I debug the code the...
  14. S

    Greetings

    Greetings I'm new to this forum and the access world
Top Bottom