Export from Access to Excel shifts decimal position randomly
I am exporting from MS Access '03 to MS Excel '03. I retrieve several columns formatted as Fixed width with 2 decimal places in a query and then export those results to Excel. Occasionally, some of the columns, but not all values in that column, will display with the decimal point shifted one...
Answer Question
| Sep 2 2008 8:52 PM GMT
| asked by
MBachman
Access to Excel, Export, Excel 2003
Switch/Case statment in access
how i can use Switch/Case Satatment in Mic. Access 2003, am working on database as follow:Field Name: Directionsin this field i need to write codes like: TAmField Name: Translationhere i need to read TAm as T=Take, Am= Morning.the problem i have more than 200 codes, which they have to be togther in...
View Answer
| Aug 20 2008 11:10 AM GMT
| asked by
Darkblue46
Access 2003, Microsoft Access, CASE statement
How do I retrieve the most recent date from an access database
I am building a report in Access 2003 and am trying to pull data based on the most recent service call for a customer. There is typically several service call dates for each customer, but the only record I am concerned with is the most recent date.
View Answer
| Aug 15 2008 5:29 PM GMT
| asked by
TheMooseRI
Access Database, Access 2003, Microsoft Access
database form
I used microsoft access 2003 to create a simple database to track asset destruction. I would like to create either an application or a web based form that will allow my employees to fill out, submit, and update the database without having to manually update it. What is the easiest way I can go...
View Answer
| Aug 7 2008 1:41 PM GMT
| asked by
Sturdy27
Access 2003, Microsoft Access
Highlight Keywords in Access 2003 Forms
I have a searchable form in Access 2003. Users can type in a keyword or phrase to filter records. Is there a way of highlighting the keyword or phrase used in the set of filtered records?
Answer Question
| Aug 7 2008 1:20 AM GMT
| asked by
Morgandtx
Access 2003, Database programming, Microsoft Access
MS Access DB - Query
I have an Access database this is in place for in person registration at a convention. The registration system uses a few data fields then prints a report. I can't get the report to work the way that i want it to.I need the report to pull the record that i just entered via query (or whatever if i'm...
View Answer
| Jul 30 2008 6:23 PM GMT
| asked by
Phixious
Query, Access 2003, Microsoft Access
Access 2003 - adding values to a specific record via a query
i have a situation where i have a table whose fields are :-Date reference: is a number which repredents a date in the Date Table (this way it is easier to manupilate dates)-value of payment: the monetary value of the payment that has to be paid at that date-Paid: here i enter yes or no.Now...
Answer Question
| Jul 24 2008 11:45 AM GMT
| asked by
Mutaz
Access 2003, Microsoft Access, Database programming
Refusal to recognize SQL Server 2005 Express on a client PC
I have installed SQL Server 2005 Express with about 10 client PCs. I also have Microsoft Access 2003 on the front-end linking to it using System DSNs. On one of the PCs, it refuses to recognize the SQL Server when I try to create a DSN. It does, however, see a different SQL Server that was...
View Answer
| Jul 8 2008 3:45 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2005, Microsoft Access, SQL Server Express
limit number of users in access 2003
I converted access 2000 to access 2003 and I did the front end/back end approach. I need to limit the number of users accessing the front end so it doesn't lock up the application and not populate the look up table...I inherited this application
Answer Question
| Jun 16 2008 2:08 PM GMT
| asked by
Herdine
Access 2003, Access 2000
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.
View Answer
| Jun 12 2008 12:29 AM GMT
| asked by
Herdine
.MDE files, Database conversion, Access 2003
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?
View Answer
| May 30 2008 2:05 PM GMT
| asked by
Rmrj
Relationship window, Access 2003, Microsoft Access
Access Report Page Setup Won’t Save
I am running Access 2003 on Windows XP. In the page setup of a report, you can set custom page size and specific printer, etc. I have a PC that the page size will not save with the report. I have two other PC's that it works on. Has anyone had this problem and found a resolution? I should add...
Answer Question
| Apr 9 2008 7:25 PM GMT
| asked by
Randym
Microsoft Access, Access 2003
