AS400 ODCB table link
When i link tables with a ODBC driver then some table won’t give me any records (I link into microsoft access. But I do see the column headings. I the record fields I get: #Name? Is this an AS400 problem, ODCB or Access ?
Answer Question
| May 3, 2010 4:14 PM
AS/400 errors, Microsoft Access, ODBC
When i link tables with a ODBC driver then some table won’t give me any records (I link into microsoft access. But I do see the column headings. I the record fields I get: #Name? Is this an AS400 problem, ODCB or Access ?
Answer Question
| May 3, 2010 4:14 PM
AS/400 errors, Microsoft Access, ODBC
Report -Conditional Format with multiple conditions: Access 2007
I am trying to generate a report that will change the font to different color if of a date field but the total number of days will change if another field = ?. So basically if [TYPE] = CHILD then DATE()-30= (red font), and DATE()-31 BETWEEN DATE()- 60= (yellow font) and DATE()-61 BETWEEN DATE()- 90=greenfont) [...]
Answer Question
| June 24, 2008 10:39 AM
Access, Access reports, Conditional formatting, Conditional statements, Database, Database programming, Microsoft Access
I am trying to generate a report that will change the font to different color if of a date field but the total number of days will change if another field = ?. So basically if [TYPE] = CHILD then DATE()-30= (red font), and DATE()-31 BETWEEN DATE()- 60= (yellow font) and DATE()-61 BETWEEN DATE()- 90=greenfont) [...]
Answer Question
| June 24, 2008 10:39 AM
Access, Access reports, Conditional formatting, Conditional statements, Database, Database programming, Microsoft Access
Public Folders
I have created a public folder to store excel spreadsheets that I need users to be able to access and change. I understand the permissions. My question is can more than 1 user be in the same spread sheet at one time and make individual changes.Will all changes be saved?
Answer Question
| June 22, 2008 7:13 PM
Access, Excel 2003, Microsoft Access, Public folders
I have created a public folder to store excel spreadsheets that I need users to be able to access and change. I understand the permissions. My question is can more than 1 user be in the same spread sheet at one time and make individual changes.Will all changes be saved?
Answer Question
| June 22, 2008 7:13 PM
Access, Excel 2003, Microsoft Access, Public folders
Notifications Microsoft Access and Outlook
I have created a form and one of the fields in the form is for the date of expiry for certifications. Is there a way that access can send a notification or some type of flagging through Outlook (or any other method for that matter) to let me know that someones certification expiry date is [...]
Answer Question
| June 13, 2008 5:04 PM
Microsoft Access, Outlook
I have created a form and one of the fields in the form is for the date of expiry for certifications. Is there a way that access can send a notification or some type of flagging through Outlook (or any other method for that matter) to let me know that someones certification expiry date is [...]
Answer Question
| June 13, 2008 5:04 PM
Microsoft Access, Outlook
MDE to updating table in backend database
I inherited a few databases which were created in Access 2000. I only have Access 2003 and I needed to make a new MDE file, I converted to Access 2003 then created the new MDE file. Now the problem is this, the new MDE won’t write to the backend database.
Answer Question
| June 27, 2008 12:29 PM
.MDE files, Access 2003, Database conversion, Microsoft Access
I inherited a few databases which were created in Access 2000. I only have Access 2003 and I needed to make a new MDE file, I converted to Access 2003 then created the new MDE file. Now the problem is this, the new MDE won’t write to the backend database.
Answer Question
| June 27, 2008 12:29 PM
.MDE files, Access 2003, Database conversion, Microsoft Access
mdb talk to jdbc
is it possible to make an inner procedure in (any) jdbc db that will produce simple p2p connection with another db for example a mdb, this is highly needed that the other db will be a flat file (mdb), if you know any way to create connection through another db, with a non-java db (not [...]
Answer Question
| June 6, 2008 3:40 PM
Flat files, JDBC, Microsoft Access, Query
is it possible to make an inner procedure in (any) jdbc db that will produce simple p2p connection with another db for example a mdb, this is highly needed that the other db will be a flat file (mdb), if you know any way to create connection through another db, with a non-java db (not [...]
Answer Question
| June 6, 2008 3:40 PM
Flat files, JDBC, Microsoft Access, Query
DB Web interface
What would be the easiest language to use/learn if I want to create a web interface for my Access DB?
Answer Question
| June 6, 2008 7:26 AM
Database frontend, Database programming, Microsoft Access
What would be the easiest language to use/learn if I want to create a web interface for my Access DB?
Answer Question
| June 6, 2008 7:26 AM
Database frontend, Database programming, Microsoft Access
Dropdown Window connecting… Help!
Ok, to get to the point, I’ll talk about the WHAT, I am asking the HOW and I’ll leave out the WHY. I have 3 peices of Data, + credits (positive credits), – credits (negative credits) and I want a dropdown window to the left that stores ways of ‘getting’ those credits or losing them, [...]
Answer Question
| June 6, 2008 6:29 AM
DropDownList, Microsoft Access
Ok, to get to the point, I’ll talk about the WHAT, I am asking the HOW and I’ll leave out the WHY. I have 3 peices of Data, + credits (positive credits), – credits (negative credits) and I want a dropdown window to the left that stores ways of ‘getting’ those credits or losing them, [...]
Answer Question
| June 6, 2008 6:29 AM
DropDownList, Microsoft Access
Microsoft Access – I would like to have the first character of a field print without the first character?
I would like to have the first character of a field print without the first character? (ex: LC7 to print as C7, The size of the field may vary)
Answer Question
| June 6, 2008 10:42 PM
Access 97, Microsoft Access
I would like to have the first character of a field print without the first character? (ex: LC7 to print as C7, The size of the field may vary)
Answer Question
| June 6, 2008 10:42 PM
Access 97, Microsoft Access
Convert OO Base to MSA
Is there a way to convert an existing Open Office Base database to MS Access?
Answer Question
| June 18, 2008 4:51 PM
Access, Microsoft Access, OO, OpenOffice, VB
Is there a way to convert an existing Open Office Base database to MS Access?
Answer Question
| June 18, 2008 4:51 PM
Access, Microsoft Access, OO, OpenOffice, VB
Problem converting Access SQL query to T-SQL 2005
I have a SQL Server 2005 database. One of my co-workers has put a MS Access front-end on it, because of the ease of designing queries in Access. I need to convert an existing query from Access SQL to T-SQL to put it into production. So far, I have removed all the obvious differences between [...]
Answer Question
| June 4, 2008 3:41 PM
Microsoft Access, SQL, SQL Server 2005, T-SQL
I have a SQL Server 2005 database. One of my co-workers has put a MS Access front-end on it, because of the ease of designing queries in Access. I need to convert an existing query from Access SQL to T-SQL to put it into production. So far, I have removed all the obvious differences between [...]
Answer Question
| June 4, 2008 3:41 PM
Microsoft Access, SQL, SQL Server 2005, T-SQL
Date Picker
Can I create a Date Picker (enabling users to look up a date from a calendar) in Access 2003 forms?
Answer Question
| June 5, 2008 2:11 PM
Calendar control, Database programming, Date Picker, Microsoft Access
Can I create a Date Picker (enabling users to look up a date from a calendar) in Access 2003 forms?
Answer Question
| June 5, 2008 2:11 PM
Calendar control, Database programming, Date Picker, Microsoft Access
Microsoft 2003 Access relationship window
The relationships window is displayed, and you notice that one of the tables has two feilds shownin bold. What does this mean?
Answer Question
| July 8, 2009 2:05 PM
Access 2003, Microsoft Access, Relationship window
The relationships window is displayed, and you notice that one of the tables has two feilds shownin bold. What does this mean?
Answer Question
| July 8, 2009 2:05 PM
Access 2003, Microsoft Access, Relationship window
set up file not installed in other system
Dear sir i created an application useing VB 6.0 and MS-Access.i made it exe and packaged as well as deployed using “Pavkge and Deployment Wizard” from Add-Ins menu. it is installed in my own system where i created the application.While i am installing in another system an Warning shows that “SET UP CAN’T CONTINUE BECAUSE [...]
Answer Question
| May 30, 2008 6:51 AM
Microsoft Access, Package and Deployment wizard, VB, Visual Basic 6
Dear sir i created an application useing VB 6.0 and MS-Access.i made it exe and packaged as well as deployed using “Pavkge and Deployment Wizard” from Add-Ins menu. it is installed in my own system where i created the application.While i am installing in another system an Warning shows that “SET UP CAN’T CONTINUE BECAUSE [...]
Answer Question
| May 30, 2008 6:51 AM
Microsoft Access, Package and Deployment wizard, VB, Visual Basic 6
MS Access IIF
There is a task type column and a cost column. I need to pull out only the costs related to the task type steel. I was thinking an IIf ( [tast type] = steel, sum, 0 ) statement would work. Not making it happen. Any ideas? I actually want to pull out all of the [...]
Answer Question
| May 27, 2008 9:16 PM
IIF function, Microsoft Access
There is a task type column and a cost column. I need to pull out only the costs related to the task type steel. I was thinking an IIf ( [tast type] = steel, sum, 0 ) statement would work. Not making it happen. Any ideas? I actually want to pull out all of the [...]
Answer Question
| May 27, 2008 9:16 PM
IIF function, Microsoft Access
auto send e-mail
How does one auto send e-mail from access
Answer Question
| May 22, 2008 1:59 PM
Database programming, Microsoft Access
How does one auto send e-mail from access
Answer Question
| May 22, 2008 1:59 PM
Database programming, Microsoft Access
Convert time as text to datetime
I’ve got a stupid table that I have to work with (and no, I can’t change it) that stores times of certain events as text (example: ’10:25 pm’ or ’3:02 am’). This table has an actual date to work with, which is essentially just the date with no time component. Know what I’m going to [...]
Answer Question
| May 15, 2008 11:53 AM
DateTime, Microsoft Access
I’ve got a stupid table that I have to work with (and no, I can’t change it) that stores times of certain events as text (example: ’10:25 pm’ or ’3:02 am’). This table has an actual date to work with, which is essentially just the date with no time component. Know what I’m going to [...]
Answer Question
| May 15, 2008 11:53 AM
DateTime, Microsoft Access
MS Access – Email from form – VAR email receipients
Hello, I have an access dbase and I need to email records (usually one at a time) to different receipients. The receipient name is part of the form and I have a table that lists the name and e-mail address. I am hoping to click a cmd button that will e-mail that individual the record [...]
Answer Question
| May 21, 2008 6:26 PM
Microsoft Access
Hello, I have an access dbase and I need to email records (usually one at a time) to different receipients. The receipient name is part of the form and I have a table that lists the name and e-mail address. I am hoping to click a cmd button that will e-mail that individual the record [...]
Answer Question
| May 21, 2008 6:26 PM
Microsoft Access
Microsoft Access
I have created an Iff statement where it will compare two fields and return the bigger number. The problem is that instead of compare the numbers as a whole, it compares them digit for digit. Result is that it will return a value of 150 instead of the bigger value of 1040, because the second [...]
Answer Question
| May 15, 2008 8:06 AM
Microsoft Access
I have created an Iff statement where it will compare two fields and return the bigger number. The problem is that instead of compare the numbers as a whole, it compares them digit for digit. Result is that it will return a value of 150 instead of the bigger value of 1040, because the second [...]
Answer Question
| May 15, 2008 8:06 AM
Microsoft Access
MS Access ActiveX Control
I am using a MS Form where I am trying to fill in a couple of date fields from a Calendar I inserted using ActiveX controls. How do I go about doing that? Thanks, Asuasol
Answer Question
| May 13, 2008 6:50 PM
ActiveX, Calendar control, Microsoft Access
I am using a MS Form where I am trying to fill in a couple of date fields from a Calendar I inserted using ActiveX controls. How do I go about doing that? Thanks, Asuasol
Answer Question
| May 13, 2008 6:50 PM
ActiveX, Calendar control, Microsoft Access
