User Profile

Collapse

Profile Sidebar

Collapse
FNA access
FNA access
Last Activity: Mar 16 '08, 06:50 AM
Joined: Jun 25 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • FNA access
    started a topic Access to private members using pointers
    in C

    Access to private members using pointers

    Hello all,

    I am somewhat new to C++, so please forgive my ignorance. I have an assignment that I am working on and while I do not want someone to do my homework for me, some advice to point me in the right direction would be helpful.

    I have a Class CProduct that contains two private members of type string( we will say stringA and stringB).

    I am supposed to create an array of CProduct objects and then...
    See more | Go to post

  • FNA access
    replied to PHP shows in page source
    in PHP
    Never mind...

    I just needed to upload as a .php file.

    Sorry
    See more | Go to post

    Leave a comment:


  • FNA access
    replied to Return ref cursor from oracle procedure
    That is what I was trying to do.

    I kept crashing apache when trying to use bind variables for in parameters using the ExecuteCursor syntax.

    Took me a bit, but just passed the php variable directly in my call:
    Code:
    $IDPK = $_SESSION['user_id'];
    
    $rsEmployer = $dbConn->ExecuteCursor("BEGIN SELECT_EMP(:refc,$IDPK); END;",'refc');
    
    $arr = $rsEmployer->FetchRow();
    ...
    See more | Go to post

    Leave a comment:


  • Sorry it took me so long to get back. Between work, school, and side projects I've been pretty busy.

    Thank you for the clarification on information schema table, that makes sense.

    I should have been able to figure that out myself.

    Thank goodness for you guys.
    See more | Go to post

    Leave a comment:


  • FNA access
    started a topic PHP shows in page source
    in PHP

    PHP shows in page source

    Hello All,

    I have configured php apache and mysql at home and have coded with relative success.

    I have signed up to a web hosting company and am operating on a shared server.

    PHP 4.4.4 is configured on a linux box.

    This set up is an FTP site. I need to FTP my pages to the server.

    Wanting to test the php setup I tried to run a very simple script:

    Code:
    <?
    ...
    See more | Go to post

  • FNA access
    started a topic Query execute thread cannot connect to Mysql

    Query execute thread cannot connect to Mysql

    Hello all,

    I am relitivley new to mySQL. I started by downloading from the mySQL site.
    I then downloaded mySQL administrator and mySQL Query browser.
    With my set up I got a user root with a specified password.

    I created a DB(school) . When I log into mySQL Query browser with root connection, I see all my tables etc. I even see the information_sch ema.
    I can select anything from anything.
    ...
    See more | Go to post

  • FNA access
    replied to Return ref cursor from oracle procedure
    I am using php in the html to do my calls to oracle ie this is one of my insert statements:
    Code:
    <?
    $strParam = "'".$SELEMPLOYEROPTIONIDFK."', '".$VCHEMPLOYERNAME."', '".$VCHEMPLOYERADDRESS."', '".$VCHEMPLOYERCITY."', '".$SELEMPLOYERPROVSTATEIDFK."', '".$VCHEMPLOYERXTRALOCATION."', '".$SELEMPLOYERCOUNTRYIDFK."', '".$VCHEMPLOYERPOSTALCODE."', '".$SELEMPLOYERSALUTATION."',
    ...
    See more | Go to post

    Leave a comment:


  • FNA access
    started a topic Return ref cursor from oracle procedure

    Return ref cursor from oracle procedure

    I have spent numerous days trying to figure this out.

    This is my set up.

    I am trying to fill an html table with data from an Oracle table.
    I am using php

    The table I am referencing is fairly basic.
    The table has an auto id incremented on each insert (intviewpostidp k)
    It has a date field for when the insert occurred (dtmviewpostdat e)
    it has a number field that is associated...
    See more | Go to post

  • FNA access
    started a topic Change font size in a text area

    Change font size in a text area

    I have tried to do this several ways.

    I have a text area on a form that I want people to be able to type in. When the text area is typed in, the text is very large. I would like to be able to make the text smaller when someone is typing into the form.

    Thanks in advance
    See more | Go to post

  • Thank you that answers my question. I guess it is custom message box coding heaven I'll have to delve into.

    Thanks for all that tried to help with this, sorry for not being clear off the top.

    It does make me feel a little better that it can't be done, as I couldn't figure it out on my own.
    See more | Go to post

    Leave a comment:


  • That seems like code for a custom message box ( I do have several of those)

    Does that work for Access generated warning messages

    for example when you add a record with warning messages enabled access generates a warning message box that you are about to append one record.
    It displays a yes and a no button. I need to code the no button.

    When I trace the code :

    Code:
    sSQL = "INSERT
    ...
    See more | Go to post

    Leave a comment:


  • sorry it has been so long, life has a way of happening....

    I will try to be more clear.

    For the database settings I have checked both boxes for delete warnings and add warnings.

    In most cases I have managed the warnings by turning them off and on with no issues.

    When a user wants to create a new object I display the nessecary text boxes to collect all the data to enter into the table....
    See more | Go to post

    Leave a comment:


  • Add code to the Access generated warning message

    In some places I have left the warning messages enabled for the users. If they click cancel they get an error.

    How do you add code to this event. I have traced through the program, but I never see the code that actually fires this warning message.

    The error is 2501, runSQL action was canceled.

    Thanks in advance for the help
    See more | Go to post

  • Thank you to all !!!

    It works great. I decided just to bold some key fields instead of the whole line. DamonReid's code works perfectly. Just used an if else to toggle between bold and normal during the OnFormat event of a Reports detail line.
    See more | Go to post

    Leave a comment:


  • Sorry about the confusion in my post. I am trying to code the on format event for a report. I will try .fontbold. I didn't know that was how to set the weight, nor could I find that information anywhere.

    I will respond with how it works. Thanks to all that replied !!!!
    See more | Go to post

    Leave a comment:


  • Change fontwieght of a field during On format event

    I can't seem to be able to access the font weight property of a field.

    What I am doing is during the on format event of my form, If my key field is not blank or null then i want to make the whole record bold

    If Me!SupplierID <> "" And Not IsNull(Me!Suppl ierID) then
    'Make all fields in this record bold
    end if


    I have tried :
    Me!SupplierID.F ontWieght...
    See more | Go to post

  • FNA access
    replied to Conditional formating on a Report
    Thanks for pointing me in the right direction. I have played with some code and I got it to work. I am wondering if there is a more efficient way than how I coded it. This gives me the results I want, but it does have to run through the record set several times. As always thank you for the help.

    Code:
    Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    Dim db As DAO.Database, rst As DAO.Recordset, sSQL As String,
    ...
    See more | Go to post

    Leave a comment:


  • FNA access
    started a topic Conditional formating on a Report

    Conditional formating on a Report

    I have a request to highlight any entries in a report that have the same date. The report is sorted by date so the records would be one after the other. I cannot find any events for the report that I would be able to add any code to.

    Any input or advice would be appreciated

    I would like to figure the code myself as I find I learn better that way, I just can't find an event to put the code into.

    My report...
    See more | Go to post

  • I got it too work, maybe not the most elegant way, but...

    All I did was in the current event of my main form I set the focus to my subform and then back to my main form and voila, no ghosted data.

    I don't understand why the ghosted data showed up in the first place, but it is gone now.

    Thanks to all who tried to help. It is greatly appreciated.
    See more | Go to post

    Leave a comment:


  • Thanks for the insight. I was unaware that the container even existed. I checked the name and it was different. I still have the subform display data from previous main form record.

    Code:
    Private Sub Form_Current()
    Call AutoFillNewRecord(Forms!Alert)
      [Forms]![Alert]![AlertPersonnelSubform].Requery
    End Sub
    I have taken some screens of the form that depicts what is happening, as well as what I would...
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...