Recent IT Questions

1 - 12 of 12
<<PREVIOUS 1 NEXT>>

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


1 - 12 of 12
<<PREVIOUS 1 NEXT>>