Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. anasazii

    Create a Gantt Chart

    Hello! Has anyone successfully been able to create a Gantt Chart with .VBNET? We have ChartFX and I've been combing through the documentation, but I'm not having much luck. It seems like most of the examples are in C# or WindowForms - we're using VB and WebForms. I can get the basic chart...
  2. anasazii

    Can I remove a default value from a column?

    Hello all, I've got a table that has a column default value of 2005. Is there any way that I can remove this default? The closest I've gotten is the following: alter table xxtpm.tpm_project_savings modify (SAVINGS_YEAR NUMBER DEFAULT NULL) Thanks, Janel
  3. anasazii

    Date and Time Format

    I think I got it to work...thanks. select to_date(to_char(sysdate, 'MM/DD/YYYY HH:MI:SS PM'), 'MM/DD/YYYY HH:MI:SS PM') from dual;
  4. anasazii

    Date and Time Format

    I have an application where I would like to store audit information such as Creation Date and Last Updated Date. Both are Date fields. My application stores the SYSDATE value, but it is only storing the date part(03/28/2004) - no time (HH:MM:SS PM). Is there anyway to get the time included...
  5. anasazii

    Runcode from Switchboard button

    cg084, Were you ever able to get the RunCode() argument working from the Switchboard? Here's what I've gotten so far in case anyone else runs into this problem. If I enter just the name of the function - no () - for function name (i.e. Export) the code runs OK from SB. In my situation, my...
  6. anasazii

    Executable Toolbar

    Judge, Hello! I've gotten to the point where I can change the images. Is there anyway to display a different image then what appears for the choices? Thanks, Janel
  7. anasazii

    Verify Email address against Outlook

    I'm automating a report that gets sent to users based on criteria the user enters. The name of the user will be used with the docmd.sendobject to email the report. Does anyone know of a way to verify that the name is in the Outlook address book and will be sent ok? Right now, I have created...
  8. anasazii

    Info on Access 2003/other Access versions

    Does anyone know of a good place to find information on the differences/compatibility/known issues between each version of Access? Specifically, I'm looking for differences between Access 2003 and Access XP (or any versions for that matter) from a DEVELOPER'S point of view. I don't care what...
  9. anasazii

    Datasheet Column is AutoIncrementing

    no, not AutoNumber, just NUMBER. (Long Integer)
  10. anasazii

    Datasheet Column is AutoIncrementing

    I have a form in datasheet view. I have 3 columns in a row that are numbers. The first two are 0/1 entries and the third is a foreign key value. When entering the data, when I have 0 for the first and enter a 1 for the second, Access is automatically incrementing the next column to 2, which...
  11. anasazii

    OutPutTo under Access XP

    Sorry, I believe that was all I changed...My statement that I have looks about the same as yours also, except I'm using variables for my report names... docmd.outputto acoutputreport, srptname, acformatSNP, stemprptname, false Do you have all the correct permissions to the drive you're trying...
  12. anasazii

    Switchboard does not load - XP and 2000

    I have a shared front end database with users using XP and 2000. Database was originally developed in 2000. I was switched over to XP about 1-2 months ago, and have been maintaining it in XP. About 2 weeks ago, XP users could not open the database. They would not receive a runtime error -...
  13. anasazii

    OutPutTo under Access XP

    Estuardo, Thank you for your reply. I have figured out (hopefully) what my problem was. I had extra references set that were interferring. I went in and removed the following - "Windows Common Controls 6.0" and "Windows Script Host Object Model". I'm not sure what...
  14. anasazii

    OutPutTo under Access XP

    Lloyd, Have you had any luck with this? I am running into the same issue. DB built in 2000, now upgrading systems to XP. I tried running it in XP, crashed first time and received MS Access error. It now runs, and I get the output message that report is printing, and then nothing. Just...
  15. anasazii

    Potentially speed up form operations dramatically

    Never mind - I got it!!! I was using the wrong date for my report criteria. Oops. Thanks for your post, Bill!! It shaved an additional minute off my report. Janel
  16. anasazii

    Potentially speed up form operations dramatically

    Bill, I tried your suggestion on a report that I'm building, and it loads empty. Am I doing this correctly? I set the .controlsource of all my fields (19 of them) that are in my Details section in the Report_Open event, since there is not a Load() event, and Access won't let you do it in the...
  17. anasazii

    How do I create a menu bar on a form?

    Awesome!! I think I got it figured out. One thing to note for anyone curious about this is that (for me at least)it does NOT prompt you for which menus/toolbars to import. I just selected the option and then imported a module to test it. It went ahead and brought the menubars over along...
  18. anasazii

    How do I create a menu bar on a form?

    kind of an aside...but does anyone know if it's possible to transfer a customized menubar/toolbar from one database to another? Thanks, Janel
  19. anasazii

    Referencing Controls on a Tab

    Moss, With the help of one of my coworkers, we were able to get something working, but I'm not sure how well I'll be able to explain it. The query that I'll be talking about is the recordsource of my form that is located in the tab control. It is a subform of another form. Here's what we...
  20. anasazii

    Referencing Controls on a Tab

    Solodroid, please help!! I am trying to accomplish something similar. I have a main form, frmMain. On that form, I have my tab control. On my tab control I have a Subform, frmEntry, which contains another subform, sfrDetails. The query is in my recordsource for the subform sfrDetails. I am...

Part and Inventory Search

Back
Top