Access: Form to input dates
Hi, I was wondering if some Access expert could help me with this short questions. I have an access database with one table, which has 4 columns: ID, Task, Date, Hours I would like to create a form in which a user sees the following headings Task : Mon : Tue : Wed : Thur [...]
Answer Question
| May 12, 2009 1:42 PM
Access forms, Access Forms Database, Microsoft Access
Hi, I was wondering if some Access expert could help me with this short questions. I have an access database with one table, which has 4 columns: ID, Task, Date, Hours I would like to create a form in which a user sees the following headings Task : Mon : Tue : Wed : Thur [...]
Answer Question
| May 12, 2009 1:42 PM
Access forms, Access Forms Database, Microsoft Access
How to use DateDiff to calculate costs?
Hi, In my Access bookings system you select a number of Units and a start and end booking time. I need to calculate the cost of each Unit for the booking as well as a total cost for all Units in the booking. The information is stored in two tables: a bookings table called tblHourPeriod [...]
Answer Question
| May 13, 2009 10:16 AM
Database programming, DATEDIFF, Microsoft Access
Hi, In my Access bookings system you select a number of Units and a start and end booking time. I need to calculate the cost of each Unit for the booking as well as a total cost for all Units in the booking. The information is stored in two tables: a bookings table called tblHourPeriod [...]
Answer Question
| May 13, 2009 10:16 AM
Database programming, DATEDIFF, Microsoft Access
Copy/paste a record with VBA in Microsoft Access
how can I copy number of records from a form and paste them in another form with VBA, not with the right click, in msaccess? Thanks
Answer Question
| May 19, 2009 3:37 PM
Access VBA, Microsoft Access, VBA, Visual Basic for Applications
how can I copy number of records from a form and paste them in another form with VBA, not with the right click, in msaccess? Thanks
Answer Question
| May 19, 2009 3:37 PM
Access VBA, Microsoft Access, VBA, Visual Basic for Applications
Access IIF Statement Not Returning All Records based on Option Group
I’m using Access 2007 and have a query referencing an Option Group on a Form as a filter. The Option Group has 3 choices: Billable Manhours (value = 1), Non Billable Manhours (value = 2), All Manhours (value = 3). My query statement is: IIf([Forms]![FormName]![OptMHs]=1,True,IIf([Forms]![FormName]![OptMHs]=2,False,???)) When All Manhours is selected (value = 3), I want [...]
Answer Question
| May 7, 2009 8:39 PM
Access 2007, IIF statement, Microsoft Access
I’m using Access 2007 and have a query referencing an Option Group on a Form as a filter. The Option Group has 3 choices: Billable Manhours (value = 1), Non Billable Manhours (value = 2), All Manhours (value = 3). My query statement is: IIf([Forms]![FormName]![OptMHs]=1,True,IIf([Forms]![FormName]![OptMHs]=2,False,???)) When All Manhours is selected (value = 3), I want [...]
Answer Question
| May 7, 2009 8:39 PM
Access 2007, IIF statement, Microsoft Access
MS Access 2002 Excessive Growth
I have an Access 2002 application that is running VB/DAO to manipulate data and have very few forms. When the application starts its size is about 20,000 KB. After completion of a run 4 hours later, it can grow in size to over 200,000 KB. And as the run progresses, it gets slower and slower [...]
Answer Question
| April 21, 2012 3:23 PM
Access 2002, DAO, Microsoft Access, Microsoft Access Performance, Visual Basic
I have an Access 2002 application that is running VB/DAO to manipulate data and have very few forms. When the application starts its size is about 20,000 KB. After completion of a run 4 hours later, it can grow in size to over 200,000 KB. And as the run progresses, it gets slower and slower [...]
Answer Question
| April 21, 2012 3:23 PM
Access 2002, DAO, Microsoft Access, Microsoft Access Performance, Visual Basic
DateAdd Function
I have a dateadd function in a query Cdate:DateAdd(“yyyy”,[Length],[StartDate]). I need the year added from how long we give someone to complete certain courses. Example, Lenght = 2, StartDate = 1/2/2007, Cdate = 1/2/2009. This works and that’s not the problem. Now I need to run the query with the criteria stating <[Enter Date]. This [...]
Answer Question
| May 12, 2009 4:38 PM
Access 2007, Access 2007 functions, DateAdd Function, Microsoft Access
I have a dateadd function in a query Cdate:DateAdd(“yyyy”,[Length],[StartDate]). I need the year added from how long we give someone to complete certain courses. Example, Lenght = 2, StartDate = 1/2/2007, Cdate = 1/2/2009. This works and that’s not the problem. Now I need to run the query with the criteria stating <[Enter Date]. This [...]
Answer Question
| May 12, 2009 4:38 PM
Access 2007, Access 2007 functions, DateAdd Function, Microsoft Access
Automatically generating info into fields
I am working on a databaase in 07 and i have a drop down field with peoples names and i want to when i select their name the next field to automatically generate their phone number. is this possible?
Answer Question
| April 30, 2009 12:16 AM
Microsoft Access
I am working on a databaase in 07 and i have a drop down field with peoples names and i want to when i select their name the next field to automatically generate their phone number. is this possible?
Answer Question
| April 30, 2009 12:16 AM
Microsoft Access
Microsoft Access database update question
So I have two Access databases that are linked together so that tables on one of the database can be updated offline but can update the main one when needed. I have ran into an issue though where my table isn’t recognizing the linked data from the other tables that it needs to. For this [...]
Answer Question
| April 30, 2009 3:29 AM
Database programming, Linked database, Microsoft Access
So I have two Access databases that are linked together so that tables on one of the database can be updated offline but can update the main one when needed. I have ran into an issue though where my table isn’t recognizing the linked data from the other tables that it needs to. For this [...]
Answer Question
| April 30, 2009 3:29 AM
Database programming, Linked database, Microsoft Access
Microsoft Access: Hiding form fields with Null values
Hello, I have a table that has Name F1 F2 F3 F4 Wes x Bob x x Mark x x and so on. Certain names have a check mark “x” and others do not. I need to be able to pull up someones name and see a summary of what they have “x”‘s in. I [...]
Answer Question
| April 30, 2009 11:22 PM
Access VBA, Microsoft Access, Microsoft Access forms, NULL values, VBA, Visual Basic for Applications
Hello, I have a table that has Name F1 F2 F3 F4 Wes x Bob x x Mark x x and so on. Certain names have a check mark “x” and others do not. I need to be able to pull up someones name and see a summary of what they have “x”‘s in. I [...]
Answer Question
| April 30, 2009 11:22 PM
Access VBA, Microsoft Access, Microsoft Access forms, NULL values, VBA, Visual Basic for Applications
MS Access Report modifications
I am using MS Access 2007. I am trying to modify a report and I want to delete the label in the page header section but not the detail field. I cannot find a way to detach the label from the detail field
Answer Question
| January 28, 2011 7:03 PM
Access 2007, Access reports, Microsoft Access
I am using MS Access 2007. I am trying to modify a report and I want to delete the label in the page header section but not the detail field. I cannot find a way to detach the label from the detail field
Answer Question
| January 28, 2011 7:03 PM
Access 2007, Access reports, Microsoft Access
My DTS package runs normally, but hangs when run as a SQL Job
Hi, I’m trying to run an Ms Access .mbd file through a MS SQL 2003 Server. The package runs normally and works when I start the job, but simply hangs when I run the package as a a scheduled job. I’ve designed a DTS local package as follows: ‘********************************************************************** ‘ Visual Basic ActiveX Script ‘************************************************************************ [...]
Answer Question
| April 29, 2009 6:01 PM
ActiveX, DTS Local Package, DTS package, Job scheduling, Microsoft Access, SQL, SQL Jobs, SQL Server 2003
Hi, I’m trying to run an Ms Access .mbd file through a MS SQL 2003 Server. The package runs normally and works when I start the job, but simply hangs when I run the package as a a scheduled job. I’ve designed a DTS local package as follows: ‘********************************************************************** ‘ Visual Basic ActiveX Script ‘************************************************************************ [...]
Answer Question
| April 29, 2009 6:01 PM
ActiveX, DTS Local Package, DTS package, Job scheduling, Microsoft Access, SQL, SQL Jobs, SQL Server 2003
Access Database update question
So I have two Access databases that are linked together so that tables on one of the database can be updated offline but can update the main one when needed. I have ran into an issue though where my table isn’t recognizing the linked data from the other tables that it needs to. For this [...]
Answer Question
| April 28, 2009 2:50 PM
Access Database, Microsoft Access
So I have two Access databases that are linked together so that tables on one of the database can be updated offline but can update the main one when needed. I have ran into an issue though where my table isn’t recognizing the linked data from the other tables that it needs to. For this [...]
Answer Question
| April 28, 2009 2:50 PM
Access Database, Microsoft Access
Create a report with only results with specific entry in field
Very simple question – sorry. How do I create a report where only the entries where a field has a specific answer. Such as only the results whose tick box is ticked, or who’s “category” field is a certain category?
Answer Question
| April 27, 2009 2:00 PM
Access 2003, Microsoft Access
Very simple question – sorry. How do I create a report where only the entries where a field has a specific answer. Such as only the results whose tick box is ticked, or who’s “category” field is a certain category?
Answer Question
| April 27, 2009 2:00 PM
Access 2003, Microsoft Access
Access Course/Student Database
I work in an educational environment. I have created a database that includes a table of courses, certificates & students. The relationships are correct, because when I look in certificates, I can see the courses for that certificate and under that the students enrolled in that course. Same with the students table, I can see [...]
Answer Question
| May 5, 2009 1:23 PM
Access 2007, Access Database, Access Tables, Microsoft Access
I work in an educational environment. I have created a database that includes a table of courses, certificates & students. The relationships are correct, because when I look in certificates, I can see the courses for that certificate and under that the students enrolled in that course. Same with the students table, I can see [...]
Answer Question
| May 5, 2009 1:23 PM
Access 2007, Access Database, Access Tables, Microsoft Access
adding hyperlink
I have created columns in the query for links to pdf files. Each one belongs to an employee. My question is how do I create the link to showup on the form for each employee? The links belong to certain employees while others have no link. I am currently running Access 2000.
Answer Question
| April 23, 2009 5:25 PM
Access 2000, Microsoft Access
I have created columns in the query for links to pdf files. Each one belongs to an employee. My question is how do I create the link to showup on the form for each employee? The links belong to certain employees while others have no link. I am currently running Access 2000.
Answer Question
| April 23, 2009 5:25 PM
Access 2000, Microsoft Access
AS/400 data to Microsoft Access database
In my business, I use an MS Access database to monitor inventory of my client and encode similar data to my client’s AS400 system. I am asked by my client to simplify my job by encoding only in AS400 and have the data transferred to my Access database automatically to whatever method is possible. How [...]
Answer Question
| April 21, 2009 8:11 AM
AS/400 import/export, Microsoft Access, Microsoft Access import/export
In my business, I use an MS Access database to monitor inventory of my client and encode similar data to my client’s AS400 system. I am asked by my client to simplify my job by encoding only in AS400 and have the data transferred to my Access database automatically to whatever method is possible. How [...]
Answer Question
| April 21, 2009 8:11 AM
AS/400 import/export, Microsoft Access, Microsoft Access import/export
Access 2007 table versus forms
I use Access for contact mgmt. database. I have my “main” table that has all my client info. If I create a form (looks like spreadsheet) and it is populated by the names in the table and I need to delete names from the FORM, not the original table, does it delete also from the [...]
Answer Question
| April 21, 2009 2:45 PM
Access 2007, Access forms, Access Tables, Microsoft Access
I use Access for contact mgmt. database. I have my “main” table that has all my client info. If I create a form (looks like spreadsheet) and it is populated by the names in the table and I need to delete names from the FORM, not the original table, does it delete also from the [...]
Answer Question
| April 21, 2009 2:45 PM
Access 2007, Access forms, Access Tables, Microsoft Access
linking report to form by macro
I have a report that various info including name is pulled off of a form. i want to be able to click on the name in the report and have it bring up that particular record in the form. i can click on the name and it brings up the first record, but i want [...]
Answer Question
| April 20, 2009 8:21 AM
Access, Form, macro, Microsoft Access
I have a report that various info including name is pulled off of a form. i want to be able to click on the name in the report and have it bring up that particular record in the form. i can click on the name and it brings up the first record, but i want [...]
Answer Question
| April 20, 2009 8:21 AM
Access, Form, macro, Microsoft Access
creating reports with forms/subforms
I have created a report that is linked to the form. When I click the preview command button it asks for Emp. ID I enter in the ID Number and click ok. The print preview screen shows up with nothing on it. How can I get the data to show up on the report? and [...]
Answer Question
| April 19, 2009 5:51 PM
Access 2000, Access forms, Microsoft Access, Microsoft Access forms, Microsoft Access subforms
I have created a report that is linked to the form. When I click the preview command button it asks for Emp. ID I enter in the ID Number and click ok. The print preview screen shows up with nothing on it. How can I get the data to show up on the report? and [...]
Answer Question
| April 19, 2009 5:51 PM
Access 2000, Access forms, Microsoft Access, Microsoft Access forms, Microsoft Access subforms
Change year range on ActiveX calendar on Access form
Hi. I want to change the year range on the calendar in microsoft access. At the moment it goes from 1900 to 2100. really annoying! I have the ActiveX Calendar 11.0 version. On the microsoft website it says to add the code: StartDateCalendar.Year = 2001 but how do you do this? the only other thing [...]
Answer Question
| April 17, 2009 10:01 AM
ActiveX, Microsoft Access, Microsoft Access Calendar control, Microsoft Access forms
Hi. I want to change the year range on the calendar in microsoft access. At the moment it goes from 1900 to 2100. really annoying! I have the ActiveX Calendar 11.0 version. On the microsoft website it says to add the code: StartDateCalendar.Year = 2001 but how do you do this? the only other thing [...]
Answer Question
| April 17, 2009 10:01 AM
ActiveX, Microsoft Access, Microsoft Access Calendar control, Microsoft Access forms
