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
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 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 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 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
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
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
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
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
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
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
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
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
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
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
How does one auto send e-mail from access
Answer Question | May 22, 2008 1:59 PM
Database programming, 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
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
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
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