General

Use Access for only one table?
If you only have one table, and not several tables to relate together, is Access the best program to use, or would Excel work better? Thank you! ... 4 Jul 2008 14:06

List Boxes
I have two tables. One for classes and one for students. I want a drop down box or list box in the classes table to show all students. The fields in the student table are separate such as first and last name. I can choose multiple names but it only shows the last name not first and last. Is this possible. D... 1 Jul 2008 20:34

Creating a blank new database from old
Hi, all. I have a database with multiple tables, scripts, etc. I would like to make a copy of the whole database and then create a new database from only the "shell" of the old one - all schema, code, etc. but with none of the actual data. I could do this with copying the mdb file and a series of delete SQL ... 1 Jul 2008 19:32

Citrix: What Happens To MS Access App After Citrix Sesh Timeout?
I've got one of my apps up and running on a Citrix server. So far, so good.... But it looks like there's an obligatory timeout. I'm told we have it set to the 60-minute max. But if the user doesn't do something within that period, their Citrix window closes and they have to re-connect via the Mega-whate... 2 Jul 2008 22:11

Removing HTML fields in Access 2000
Hi Folks- There is an old post from '04 about this, but this issue wasn't addressed. Hoping someone can help with this! I'm trying to remove all HTML tags from 2 memo fields, leaving just the text behind. In a perfect world, they'd replace the <br> tags with line breaks, but just removing them would be a start... 1 Jul 2008 19:32

Adjusted Date/Time
Hi. If anyone can help with this, it is greatly appreciated. I have a query that reads values from a linked table (via ODBC). One particular field is an Eval_DateTime field that displays the date and time an evaluation was performed in the format m/d/yyyy h:mm:ss AM/PM. The problem that I'm having is that th... 1 Jul 2008 19:32

Chart in Grouped Report in Access 2007
I have a grouped report in Access 2007, and I'm trying to create a chart that changes with each group. I've done this before in Crystal Reports, but I can't figure out how to do it in Access. My report currently has one grouping based on a warehouse location. Each record includes a cost field and a value fie... 2 Jul 2008 00:39

Why crasch Access 2007 when you try to create or open a report?
I have serios problem vid Access 2007. I cant create or use reports at all. I use W XP Ver 2002 SP3 2008-07-01 21:46 Microsoft Office 12 Faulting application msaccess.exe, version 12.0.6211.1000, stamp 46d4aa81, faulting module msaccess.exe, version 12.0.6211.1000, stamp 46d4aa81, debug? 0, fault address 0x001... 2 Jul 2008 01:40

Percent problems
Hi, I've got a table that is called Price Category. It has the following fields: Price Category Price Markup A 10 B 15 C 20 When I change the Price Markup to a percent, the numbers show up with 2 extra zeros, a ... 1 Jul 2008 17:29

Extracting 1 number from a series of numbers in a field
I need to extract a number out of 16 in a series. The number I need to extract is the 9th number of 16. I don't want duplicates. Any suggestions? ex. yyyymodt*bnoseqe (the series is: year, month, day, Batch Type, batch number, sequences.) I need to extract Batch Type. ... 1 Jul 2008 15:25