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
Make Table query Produces different result than same select query
In MS Access what would cause a make table query to produces differnet results than same query as a select query
Answer Question
| April 16, 2009 7:20 PM
Access query, Access table, Microsoft Access, Microsoft Access tables
In MS Access what would cause a make table query to produces differnet results than same query as a select query
Answer Question
| April 16, 2009 7:20 PM
Access query, Access table, Microsoft Access, Microsoft Access tables
Autopopulating following fields
I have created my first Access database form, and now when I enter data into some fields, it autopopulates the three following fields. If I enter data in one of the following fields, it changes all of the other fields. It seems that my fields are all connected to the same row in my tables. [...]
Answer Question
| April 16, 2009 5:22 PM
Access Database, Microsoft Access
I have created my first Access database form, and now when I enter data into some fields, it autopopulates the three following fields. If I enter data in one of the following fields, it changes all of the other fields. It seems that my fields are all connected to the same row in my tables. [...]
Answer Question
| April 16, 2009 5:22 PM
Access Database, Microsoft Access
AccessDataSource and ‘?’ parameters asp.net
I have been stuck on something for days and wondering if anyone can offer any help. I am using an Access Database, so i am using the accessDataSource in asp.net I drag and drop an accessdatasource on the form, and also a datagrid. This is a simple datafile with 2 fields. An ID and an [...]
Answer Question
| April 14, 2009 6:46 PM
Access Database, ASP.NET, Microsoft Access
I have been stuck on something for days and wondering if anyone can offer any help. I am using an Access Database, so i am using the accessDataSource in asp.net I drag and drop an accessdatasource on the form, and also a datagrid. This is a simple datafile with 2 fields. An ID and an [...]
Answer Question
| April 14, 2009 6:46 PM
Access Database, ASP.NET, Microsoft Access
Meeting Invitation not updated in Calendar
I have created a COM Program in MS Access using VBA code which will send meeting invitation. Invitees are getting my invitation and after accepting it is not updating their calender. How to do this. I attached a sample tag for the same. If you want complete code I can post the same. Thanks for [...]
Answer Question
| August 7, 2009 3:48 PM
Beginner Access Programming, COM, Microsoft Access, VBA
I have created a COM Program in MS Access using VBA code which will send meeting invitation. Invitees are getting my invitation and after accepting it is not updating their calender. How to do this. I attached a sample tag for the same. If you want complete code I can post the same. Thanks for [...]
Answer Question
| August 7, 2009 3:48 PM
Beginner Access Programming, COM, Microsoft Access, VBA
VB6: Getting List of records from one field of Microsoft Access Table in ComboBox
VB6: Dear sir, For the following code I am getting “Run-time error’3265′: Item cannot be found in the collection corresponding to the request name or ordinal.” However, I already connected Adodc1 to my database from where I want the data. Actually, what Im trying to do is, just to get record list from particular field [...]
Answer Question
| April 15, 2009 7:50 AM
ComboBox, Microsoft Access, VB 6, VB error handling, Visual Basic 6, Visual Basic runtime errors
VB6: Dear sir, For the following code I am getting “Run-time error’3265′: Item cannot be found in the collection corresponding to the request name or ordinal.” However, I already connected Adodc1 to my database from where I want the data. Actually, what Im trying to do is, just to get record list from particular field [...]
Answer Question
| April 15, 2009 7:50 AM
ComboBox, Microsoft Access, VB 6, VB error handling, Visual Basic 6, Visual Basic runtime errors
front end tools
My company is in the process of building out a DW. Although there has been many discussion topics within the individual end users, the one area of conflict is on what front end tool to use. More specifically, we have some expert users who want to directly access the DW and others who are ok [...]
Answer Question
| April 12, 2009 7:44 PM
Data warehouses, Data warehousing applications, Microsoft Access, OLAP/OLTP
My company is in the process of building out a DW. Although there has been many discussion topics within the individual end users, the one area of conflict is on what front end tool to use. More specifically, we have some expert users who want to directly access the DW and others who are ok [...]
Answer Question
| April 12, 2009 7:44 PM
Data warehouses, Data warehousing applications, Microsoft Access, OLAP/OLTP
Microsoft Access Date
Microsoft Access 2003 I have a Today button that uses the command.. Private Sub cmdtoday_Click() ‘Sets the Date From and Date To text boxes ‘to Today’s Date Me!OSJPQFrom = Date Me!OSJPQTo = Date End Sub To put Today’s date into my From and To Date fields. The problem is I have these From and To [...]
Answer Question
| January 2, 2012 6:29 PM
Access 2003, Access Functions, Microsoft Access
Microsoft Access 2003 I have a Today button that uses the command.. Private Sub cmdtoday_Click() ‘Sets the Date From and Date To text boxes ‘to Today’s Date Me!OSJPQFrom = Date Me!OSJPQTo = Date End Sub To put Today’s date into my From and To Date fields. The problem is I have these From and To [...]
Answer Question
| January 2, 2012 6:29 PM
Access 2003, Access Functions, Microsoft Access
Microsoft Access 1997 emailing
“I have a business that currently is set up on Access 1997. We have an option that allows staff to email directly off this data base to our customers. However this is only in an HTML format. I would like to change this to a PDF format. So essentially I am looking to change the [...]
Answer Question
| April 7, 2009 7:54 AM
Access 1997, Microsoft Access, Microsoft Access 1997
“I have a business that currently is set up on Access 1997. We have an option that allows staff to email directly off this data base to our customers. However this is only in an HTML format. I would like to change this to a PDF format. So essentially I am looking to change the [...]
Answer Question
| April 7, 2009 7:54 AM
Access 1997, Microsoft Access, Microsoft Access 1997
Trying to learn – How to filter dates…
I have a DB that lists a date in each column, so that when I run a simple query I can pull up only the dates that I need. I have tried (filtering by exculding dates not needed) but now my DB is too big to spend the time going through each date, to only [...]
Answer Question
| April 13, 2009 2:27 PM
Access Database, Access Database Filters, Access Database Format, Microsoft Access
I have a DB that lists a date in each column, so that when I run a simple query I can pull up only the dates that I need. I have tried (filtering by exculding dates not needed) but now my DB is too big to spend the time going through each date, to only [...]
Answer Question
| April 13, 2009 2:27 PM
Access Database, Access Database Filters, Access Database Format, Microsoft Access
Microsoft Access Report “Specific Printer”
Cannot get MS Access reports to let go of default printer. Selection of “Specific Printer” in page setup does not get saved. Also set .UseDefaultPrinter=False in code but it goes back to true no matter what. Have also tried every conceivable means of setting properties of both application.printer and report.printer objects. I must get this [...]
Answer Question
| April 6, 2009 1:10 AM
Microsoft Access, Microsoft Access printing
Cannot get MS Access reports to let go of default printer. Selection of “Specific Printer” in page setup does not get saved. Also set .UseDefaultPrinter=False in code but it goes back to true no matter what. Have also tried every conceivable means of setting properties of both application.printer and report.printer objects. I must get this [...]
Answer Question
| April 6, 2009 1:10 AM
Microsoft Access, Microsoft Access printing
Access 2003 using VBA
I am trying really hard to produce these tables. But when it came to populating the information into them, it was throwing up errors. Ive managed to sort most of them out, but this one for WeeklyUnitStaffRota table is annoying me. Can anyone have a look at the tables and see where I could have [...]
Answer Question
| April 3, 2009 2:10 PM
Access 2003, Microsoft Access, RDBMS, VBA
I am trying really hard to produce these tables. But when it came to populating the information into them, it was throwing up errors. Ive managed to sort most of them out, but this one for WeeklyUnitStaffRota table is annoying me. Can anyone have a look at the tables and see where I could have [...]
Answer Question
| April 3, 2009 2:10 PM
Access 2003, Microsoft Access, RDBMS, VBA
Resizing fields to see content in Microsoft Access 2003
In Access, to expand a field to view the field’s contents what can you press?
Answer Question
| April 2, 2009 9:43 PM
Access 2003, Microsoft Access, Microsoft Access 2003
In Access, to expand a field to view the field’s contents what can you press?
Answer Question
| April 2, 2009 9:43 PM
Access 2003, Microsoft Access, Microsoft Access 2003
CSV to Access
I have multiple csv files in a folder with many lines of data in them. Every day new csv files get added to this folder. I want to write batchfile to copy certain rows from these files to the access database table everynight automatically. How can I do this?
Answer Question
| April 1, 2009 7:56 PM
CSV, Microsoft Access
I have multiple csv files in a folder with many lines of data in them. Every day new csv files get added to this folder. I want to write batchfile to copy certain rows from these files to the access database table everynight automatically. How can I do this?
Answer Question
| April 1, 2009 7:56 PM
CSV, Microsoft Access
Creating Ref numbers from two fields
I want to create an ID code from the first 3 letters of a surname in the surname filed and combine it with a 3 digit number to create a unique ID code. Appreciate it if anyone could tell me how this is done in Access.
Answer Question
| April 4, 2009 7:42 PM
Access Database, Microsoft Access, Microsoft Access Unique ID
I want to create an ID code from the first 3 letters of a surname in the surname filed and combine it with a 3 digit number to create a unique ID code. Appreciate it if anyone could tell me how this is done in Access.
Answer Question
| April 4, 2009 7:42 PM
Access Database, Microsoft Access, Microsoft Access Unique ID
Simple SQL server question?
I want to do something that WAS easy in my former world (a dBase environment) but I can’t figure out how to do it in MS Access/SQL Server 2000. I would GREATLY appreciate anyone’s help. This is what I want to do, in order: 1) Select the top # records of a table, “#” is [...]
Answer Question
| March 31, 2009 9:00 PM
dBASE, Microsoft Access, SQL Server 2000
I want to do something that WAS easy in my former world (a dBase environment) but I can’t figure out how to do it in MS Access/SQL Server 2000. I would GREATLY appreciate anyone’s help. This is what I want to do, in order: 1) Select the top # records of a table, “#” is [...]
Answer Question
| March 31, 2009 9:00 PM
dBASE, Microsoft Access, SQL Server 2000
Update Access Databse
How do I set up web application, using classic Asp to update access 2002 database?
Answer Question
| April 4, 2009 3:08 PM
Access 2002, Access Database, Microsoft Access
How do I set up web application, using classic Asp to update access 2002 database?
Answer Question
| April 4, 2009 3:08 PM
Access 2002, Access Database, Microsoft Access
Barcode scanner that dumps into text file
Hi, I’m going to try to implement a barcode system to keep track of inventory. I was wondering if anyone can suggest the best handheld scanner to get that will let us scan several barcodes and then dump the scans into a text file? Or if anyone know of another better way to accomblish this. [...]
Answer Question
| April 1, 2009 6:26 PM
Barcode, Barcode Readers, Barcode scanners, Microsoft Access, VBA, Windows XP, Windows XP Professional
Hi, I’m going to try to implement a barcode system to keep track of inventory. I was wondering if anyone can suggest the best handheld scanner to get that will let us scan several barcodes and then dump the scans into a text file? Or if anyone know of another better way to accomblish this. [...]
Answer Question
| April 1, 2009 6:26 PM
Barcode, Barcode Readers, Barcode scanners, Microsoft Access, VBA, Windows XP, Windows XP Professional
printed out in Access to populate the box
I want to have a field where the date the form was printed out populte that box in Access 2007. How do I set this up?
Answer Question
| April 1, 2009 2:19 PM
Access 2007, Access Custom Fields, Microsoft Access
I want to have a field where the date the form was printed out populte that box in Access 2007. How do I set this up?
Answer Question
| April 1, 2009 2:19 PM
Access 2007, Access Custom Fields, Microsoft Access
Data Entry in Microsoft Access using ASP
Data from the form not able to add into the database although using Internet sample source code.
Answer Question
| March 30, 2009 8:08 AM
Active Server Pages, ASP, Database connectivity, Database programming, Microsoft Access, Web development
Data from the form not able to add into the database although using Internet sample source code.
Answer Question
| March 30, 2009 8:08 AM
Active Server Pages, ASP, Database connectivity, Database programming, Microsoft Access, Web development
