Access 2003: I have this database that is truly awesome along with some equally awesome queries. Co-workers have recognized this awesomeness and want to start running their own queries but know nothing of Access. Is there a user-friendly option? [more inside]
posted on Jul 1, 2008 - 4 answers
Microsoft Access: How do I save a 'global variable'? [more inside]
posted on Sep 11, 2007 - 2 answers ![]()
How do I add a 4,000 name MS Excel file to an existing MS Access database? [more inside]
posted on Jul 2, 2007 - 3 answers ![]()
VBA assistance needed. I've got the automerge and print down, now to save it as a unique file... [more inside]
posted on May 15, 2007 - 11 answers ![]()
How can I make Microsoft Access 2002 crank out organized web pages that conform to my design ideas? [more inside]
posted on May 14, 2007 - 2 answers
I'm trying to get my head around some Microsoft Access security issues, and could use some help. [more inside]
posted on Mar 15, 2007 - 4 answers
Microsoft Access. An SQL "GROUP BY" query. How do I generate the mode of the values that it's grouping, when I want averages in other multiple fields? [more inside]
posted on Dec 13, 2006 - 3 answers
Some colleagues are trying to export a MS Access report to Excel. Here's the error they get: [more inside]
posted on Nov 6, 2006 - 4 answers
Does anyone know where I can download television episode guides converted to Microsoft Access format? [more inside]
posted on Aug 9, 2006 - 4 answers ![]()
OSX Databases: I have just migrated to Mac OSX from MS windows but have left behind several MS Access databases of varying complexity. [more inside]
posted on Jul 3, 2006 - 6 answers ![]()
Access DB Filter: Help me figure out how to make a pretty report. [more inside]
posted on Apr 4, 2006 - 3 answers
Working on an MS Access 2000 record-browsing form; the text fields all display as dark grey text on light grey background, no matter what colors or transparency are specified in the design. I've never seen this before. I've been running in circles for 2 hours. What am I missing?
posted on Mar 2, 2006 - 12 answers ![]()
What is the best and/or most efficient website design software these days? [more inside]
posted on Feb 27, 2006 - 11 answers ![]()
How difficult is it to switch from MS Access programming to Delphi? [more inside]
posted on Dec 12, 2005 - 17 answers
How can I manage my databases that are exploding in size? Can I run SQL Server on my laptop? [more inside]
posted on Dec 9, 2005 - 9 answers
How do I implement a more custom look for a Microsoft Access database? [more inside]
posted on Mar 9, 2005 - 3 answers
Microsoft Access: I might be asked to use Access to get information from a series of online EU databases, merge them and produce a series of reports. I know very little about this, and would have to get up to speec very quickly as the reports are time critical, and if they are not done well, there would be problems for the NGO who have approached me. Could anyone recommend some low cost books or other resources that could help me?
posted on Feb 8, 2005 - 2 answers
i have some of my remote users in the office connect to our fileserver using webdav as a means to quickly (though admittadly not-securely) access and change documents, etc. it seems though, that since using windows xp SP2 it's been dirt slow. my user will click on a directory, and it will take no less than 10 seconds for the directory to be highlighted. that's not even attempting to open the directory - that'll take another two minutes or so. i'm trying to figure out what's exactly going on here. ideally i'll be switching to VPN soon, but in the meantime, i need to get this working properly again.
thanks!
posted on Sep 28, 2004 - 2 answers
Say I have a database DATA.MDB
Inside DATA.MDB there is a table called ImageTable.
In this table is a field named fimageOriginalFilePath. There are aprox 4000 entries.
Each entry holds an absolute path to a directory on the C drive. For example C:\pictures\10131009
I want to automatically replace the first character of each entry with the letter F. So that each path points to the F drive.
Can it be done? Can it be done without MS Access? Can it be done by a person with no programing skills, knowledge of databases, or understanding of SQL queries and the like? If so, how? Thank you all.
posted on Apr 17, 2004 - 15 answers