Search results

Ok can anyone let me know how to make a field a requirement? The end user has to enter required info before hitting the submit button? This is what I have but there is errors. :( Private Sub Command50_Click() If IsNull([FirstName]) Then MsgBox "Please input First Name" DoCmd.CancelEvent...

This is my first attempt at coding in visual basic. I have a few companies that have their own front end database in Access. Most of the databases will communicate to one backend database which is in Access for now. Here is what I would like to do: For each database I have about 4 or 5...

Okay everyone I figured out how to change the plot order for the graph. The answer is you must copy and paste the Data from Table/Query to the Chart Data Grid. You go to Design View of the Chart. Click on Property and select Row Source. It will direct you to a Query Builder, and then you can...

Hi JHB, So if we were to use your chart, is it possible to change the X axis to 10, 9, 8, 4, 2, and 1? If so how exactly do you do it? My report where the chart is pulling the information is in ascending order, but the chart that is created is in a random order. Is there any way to change...

Hi llkhoutx, I have been trying this for hours and could not figure out how to get to Chart Tools, Design, Layout, and format tabs and then figured out it says on the bottom of the link: Applies To: Excel 2007, Outlook 2007, PowerPoint 2007, Word 2007 Does anyone know anyway to change the...

I have a column graph I created for a report. The Y axis has number of days. The X axis has Member ID. When I make the column graph the data seems to not be in any order. The report is in order by the number of days in ascending order. How can I have the columns with the largest number...

Problem solved. Renamed DueDate in design view under Field. Date1: DueDate Date2: DueDate DaysOut: DateDiff("d",[Date1],[Date2]) Thanks again everyone. :D

Okay so this is what I did to get it to work. I created 3 queries. For all the queries I am pulling the dates from the same source or same database field. Query 1 - Date 1 from Due Date database field Query 2 - Date 2 from Due Date database field Query 3 - I have for each record Due Date 1...

Thank you very much Frothingslosh. I am thankful for your reply. I know I need to know SQL and VBA and am trying to read it slowly but right now I do not know how to code. I am trying to learn it and will be signing up for a class in the near future. I have tried the wizard to find duplicates...

I have a query which is used to pull data from 2 tables. A few things I am looking to do. 1. Only show the records that have 2 or more same Pat#, FName and LName. If it is a single record I would like to hide it. 2. Need to see the different dates amd know the difference. Currently Query...

Hi everyone my first post on the boards and just wanted to introduce myself. Just started a job where they are now asking me to support an already existing database. I have little experience in Access but learning and absorbing as much as possible. I am 44 years old and have three kids. I...