Search results for query: *

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

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

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

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

Hello all! I have a form that sends an email. Currently I am doing this using an Outlook object, and after building the email I use the ".display" command to show the email... Does anyone know of any way to make sure that the email is then actually sent (i.e. 'Send' button is...

Hello everyone! Has anyone ever had this happen? I have a user that has tried running reports from several different databases. (Although I believe that they both have the same back-end) No numbers appear in the reports. There are several fields that display dates, and they just appear as...

Hello, Does anyone know how to combine an existing Word Document with an Access Report? I have a report that I created in Access, and would like to include information that is already entered in a Word document, stored on the network. I have tried creating both bound & unbound object...

Greetings everyone! I have a form that users enter a persons' first name, middle, and last. I then query the database to see if that name or one similar is found. If it is, I open a form showing that information and like the 10 closest records near the initial matched record in a listbox...

Hello everyone. I have a main form that consists of tabs. On one of the tabs, I have a subform that is made of continuous forms. The idea is to have a call history, and to document everything when calls come in. When an entry is made, it is automatically set to that day's date. Right now...

Hello everyone. I need help with an insert statement that is erroring on me, and I cannot figure out why. First, I have created two tables in the code: dbs.Execute "CREATE TABLE explic(ssn TEXT, type TEXT, st TEXT, num TEXT, exp DATETIME);" dbs.Execute "CREATE TABLE...

Hello Just wondering if anyone has had this problem? I have a report w/several subreports. In these subreports I have unbound text boxes that I have coded in the Report Activate event (of the main report) to show certain values based on other fields' values in the subreports(check boxes to be...

Hello everyone. I have a report that is really giving me some trouble. It consists of a main report and 4 subreports. The layout that I want is: Page 1: Main report information & information from 2 subreports (all small enough to fit on 1 page) Page 2: Info from 3rd...

Hello all! I'm designing a switchboard for my database, and I wanted to know if what I want to do is possible. I've only been working with Access for the past 3 months, so please bear with me if this is a dumb question. I have 3 separate databases that hold information for my company, and...

Has anyone had this problem??? I've made several of my reports in Access hidden. I now need to change them back to visible. Most of them switched back without a problem, but I have 2 forms that simply will not change back. I uncheck the hidden box under properties, click apply, and a check...

Ok. I have a form that is based on a query, which I am using also for data entry. After entering the first and last names, I want to do a search on my db and make sure that the person is not already in there. (I'm doing this w/ an event procedure in the AfterUpdate event.) I've gotten this...

I have an unbound form with multiple text boxes. I have placed a button on the form, with the purpose of using it to clear the form... Just curious if there is a simple way to do this other then setting all of the text values to "", and also to return the boxes to their default setting...