Recent content by anasazii

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...

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

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;

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...

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...

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

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...

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...

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

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...

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...

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 -...

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...

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...

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