User Profile

Collapse

Profile Sidebar

Collapse
jyoung2
jyoung2
Last Activity: Apr 24 '09, 03:03 PM
Joined: Jan 21 '08
Location: Las Vegas
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • jyoung2
    replied to WebBrowser as default
    My Current Hiccup is that i only recive the error when I open a link when my program is closed and when it opens the program it skips the break points. I am unsure how to get the program to open in debug mode. I am trying to figure out the information that is getting sent the program when it is opening so I can handle it.
    In the debug folder is there a file that will open in debug mode when opened from outside of Visual Studio?
    See more | Go to post

    Leave a comment:


  • jyoung2
    replied to WebBrowser as default
    I found where to change it, It is getting an error because it is not handeling URI Formats "System.Argumen tException: URI formats are not supported." So i am going to work though and see if I can work around this. If you have an idea of where to start that would be great, otherwise I will fight through it until I can form a coherent question, ;-) and try again. thanks!
    See more | Go to post

    Leave a comment:


  • jyoung2
    replied to WebBrowser as default
    What I am trying to do is set the webbrowser I created to the default browser. I am not looking for the current default I am trying to change it.
    See more | Go to post

    Leave a comment:


  • jyoung2
    started a topic WebBrowser as default

    WebBrowser as default

    I created a webrowser in VB.net to track employee usage and it seems to be working fine but I wanted to find out what it would take to set this as a default browser on a PC. I also would need to know how to pull the URL from shortcuts so when the program opens I can have it open to the URL in the shortcut.

    thank you
    John Young
    See more | Go to post

  • Thank you for the input, I will take a look
    See more | Go to post

    Leave a comment:


  • Is there a standard practice For Version Control

    I have been looking for an article explaining the Standards of using version control. I understand the point of Major builds but when should a Minor build be incrementeted and what is the difference between a build and a revision.

    Sorry if this seems simple but I am mostly self taught starting with Access and just recently switching to .net and I am trying to start good habits from the begining.

    Thank you for the...
    See more | Go to post

  • jyoung2
    replied to query with 2 linked databases
    you can use a union query in Access I would have your search querys feed into one Union query and then output however you desire. the union would look like

    Code:
    SELECT recievedbags.*
    FROM recievedbags 
    union
    SELECT  recievedbags1.*
    FROM  recievedbags1
    The key to unions is the names of the filds need to be the same. If you are doing Queryies then replace the recivedbags with the name of the Q...
    See more | Go to post

    Leave a comment:


  • Depending on how you want to format your letter you could use sub reports on the report. You would just have the data pull a query for each report.

    Another way would be to use a temp table and have queries append to the temp table and use that for the report.
    See more | Go to post

    Leave a comment:


  • Assuming that Previous balance includes all months until the current one then
    This is the basic format I You may want to use fields on the form to store the varible so the people can see what they are charged for.

    There may be a better way to format this
    Code:
    CurrentRentDays = DateDiff("d", Format(Month(Now) & "/01", "mm/dd/yyyy"), Format(Now, "mm/dd/yyyy") + 1)
    CurrentRentDollars
    ...
    See more | Go to post

    Leave a comment:


  • did you decompile then try a compact and repair?
    run the decompile from your run on the start menu. Make suere the path is correct
    Then do the Compact and repair from the tools->database utilities


    "C:\Program Files\Microsoft Office\Office11 \MSACCESS.EXE" /decompile...
    See more | Go to post

    Leave a comment:


  • jyoung2
    replied to Delete all Tables
    If

    You mised the closeing "end if" for the "If obj.IsLoaded = False Then" see the bolded if

    Code:
    Private Sub btnPBGUpdate_Click()
        Dim TblName As String
        Dim obj As AccessObject, dbs As Object
              
        Set dbs = Application.CurrentData
         
         '  Search for closed Tables.
        For Each obj In dbs.AllTables
            TblName = obj.Name
    ...
    See more | Go to post
    Last edited by jyoung2; Jan 29 '08, 10:27 PM. Reason: Missed explanation

    Leave a comment:


  • you can try this link http://www.meadinkent.co.uk/aopendlg.htm

    other wise the "write to excel sheet" that was posted ealier is the easiest way to do it and then the users can save as when they are done....
    See more | Go to post

    Leave a comment:


  • jyoung2
    replied to Save file as pdf
    So is the PDF creater based on a Printed report? Any progress on this?
    See more | Go to post

    Leave a comment:


  • jyoung2
    replied to Text Message
    Code:
    Private Sub Text88_AfterUpdate()
       IF forms!Customer!SFF![B]form[/B].dec > 50 then 
            [B]me[/B].textmessage.caption = "You have reached the 50.00 Mark!
    End IF
     
    End Sub
    Is textmessage a Label? Does this box do anything else?
    If you have a label it may be easier to set it up using visibility
    Code:
    me.textmessage.visibility = true
    see bold items for sugestions also watch your spaces you had...
    See more | Go to post

    Leave a comment:


  • in your form place a filed with visibilty set to no with a default of 0 call it whateve in this case fldAttempt. in your onclick event for the password check if the password is incorrect then

    Code:
    if me.fldAttempt > 2 then
       docmd.quit
    else
       me.fldAttempt = me.fldAttempt +1
    end if
    you could also do it with a global varible....
    See more | Go to post

    Leave a comment:


  • jyoung2
    replied to Text Message
    Generally it would look like
    [forms]![Mainform].[SFF]!form.txtmessag e_AfterUpdate(0 )
    Not sure I completly understand the question though The 0 is only needed if there is a (cancel as integer) in the after update and i don't remeber off the top of my head....
    See more | Go to post

    Leave a comment:


  • jyoung2
    replied to how to update a field in database..?
    you could expand your replace
    D:\sample\test\

    Replace(FieldNa me,"D:\sample\t est\","D:\sampl e\AAAA\")

    thedn it would replace the whole section. Alot of this depends on this gets populated but this would change the first test only...
    See more | Go to post

    Leave a comment:


  • jyoung2
    replied to how to update a field in database..?
    Is it always the same letters that need replacing and what are they being replaced to? Is that always the same. Where is that info stored.

    You can use an iif statement in a query with the instring "instr" expression, but if it is something that is not exactly the same each time it would get more complicated.
    See more | Go to post

    Leave a comment:


  • Bold section is simmilar to what you are looking like Fairly sure with pure SQL you do not need the Parentheses I took this from an Access Query in sql view mode. My radial is called
    [Forms]![frmSwipeEntry]![fsubGiftCardLis ting].[Form]![togIssueType]
    it has 4 Values. It is linked to a subform.

    [CODE]SELECT dbo_tblGiftCard s.*, tblTourn.TName, dbo_tblGiftEven t.fldGiftAmount
    FROM (dbo_tblGiftCar ds LEFT JOIN tblTourn...
    See more | Go to post

    Leave a comment:


  • jyoung2
    replied to Save file as pdf
    With your DoCmd.OpenRepor t "ReportName ". make sure you have warnings set to false


    Code:
    docmd.Setwarnings False
    DoCmd.OpenReport "ReportName".
    docmd.Setwarnings True
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...