I have two tables in access, linked by a one to many relationship. I've made a query that pulls the information I want from both tables into one place. But now I can't type any data into the query or the form I made based on the query. Why not? [more inside]
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]
This week my blog (languagehat.com) had an unprecedented flood of weird spam; as I was in the midst of deleting another chunk of it, I found myself locked out of my MT control panel (when I try accessing mt.cgi, I get "Invalid login"). Songdog, who helps me with stuff like this, posted a report at the Movable Type Community Forum, where you can find the horrid details; unfortunately, since I'm still using MT 2.63, there's not much in the way of support, and nobody's responded at the forum. If anybody here has suggestions, I'm all ears and deeply grateful.
I've got photos, images, and brief video clips - some copyrighted, some not - on three seperate computers, and I'm looking for an ideal central location to store, view and access them. What are my options?
I have two tables in Access and this is what I want to do: [more inside]
Yet another Access Query Question. Similar to my other question, but even more frustrating. I need to craft a query that will tally values across many fields and entries. [more inside]
Dealing with no-records cases in Access [more inside]
How would you go about accessing, via the web, your bank accounts and bill paying services while away from home and trusted computers for months at a time? Does anyone have experience with Stealth Surfer and Roboform? Have you been able to use usb drives at public library's and/or internet cafes? (Bonus question: how about downloading mp3s at a library or internet cafe?)
I have a access query that is making me tear my hair out. My database has 40 fields that have three possible values (OK, NG, NA). I need to list only the entries that have NG in any one of those 40 fields. [more inside]
Nature abhors a vacuum; thus I need Access training in the Toronto/GTA area, any recommendations? [more inside]
How do I turn off my home email client when I am away from the (macintosh) computer? [more inside]
I'm using Microsoft Access 2003, SP2. Does it come with triggers and procedures? I searched Help, and it says trigger is only available to Access project. What's Access project? Help please.
In Access (and Excel as well I would imagine) what is the symbol for "Not Equals"? I would imagine since = is equals there must be a symbol for everything excluding said parameter [more inside]
Infuriating Microsoft Access questionfilter: I have a database that I inherited in which queries are set up to pull records which have dates of birth between certain dates. It works right in one database but is not working right in another, for a very particular reason.. [more inside]
How can I print multiple MS Access Snapshot files (.SNP) in Windows 2000/XP at the same time? [more inside]
How can I implement bi-directional synchronized table changes in a mySQL database and Microsoft Access? [more inside]
Access DB Filter: Help me figure out how to make a pretty report. [more inside]
We're outgrowing our 10 year old Progress database. We need some recommendations. [more inside]
How can I import selected fields from one database into another database? [more inside]
MS Access XP: Say I have 3 tables. [more inside]
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?
What is the best and/or most efficient website design software these days? [more inside]
It's not how I'd choose to spend my Friday evening, but for the last few hours, I've been trying to replace carriage returns that have turned up in an Access and Excel file, and drawing a blank. [more inside]
is there a way to make firefox work with outlook web access, in "premium" mode? [more inside]
WAMPfilter: Just upgraded to PHP5 and MySQL5, and now my scripts are getting access denied when connecting to the database. I can login from the command line with the same account just fine. [more inside]
My computer's hard drive died, taking my wireless access key with it. Unfortunately, I don't have a hard copy of it. Is there a way to re-set my wireless network's access settings without the original computer? [more inside]
What is the best alternative interface for an SQL server? [more inside]
My 15 year old son is getting a computer for Christmas. Any way to reliably and safely limit his internet access without restricting it so much it makes it useless? [more inside]
How difficult is it to switch from MS Access programming to Delphi? [more inside]
As a computer geek, I've wasted a lot of time contemplating how to build a system that would let me access, preserve, and share my information without being dependent on any particular computer. What are your thoughts? [more inside]
How can I manage my databases that are exploding in size? Can I run SQL Server on my laptop? [more inside]
Is there a way I can automatically restrict/deny access to my website from certain regions/locations (states/parts of states), possibly by redirection? [more inside]
Internet access for a short-term rented house? [more inside]
I need to become a database-design expert ASAP! [more inside]
How do I import data into a table in an Access database in such a way that the new table will retain all of the relationships currently extant in the database? Is there a way to make a new table and overwrite the old table (say the table is called 'users') and preserve the relationships?
Many libraries offer access to resources that charge hefty fees (e.g., Nexis, Dialog, Oxford U. Press titles). [more inside]
Is there any program that runs natively on OS X that would allow me to work with a Microsoft Access database? Or am I doomed to run SoftPC? [more inside]
How to break out of local Google? [more inside]
Database 101... I have two tables, with one common field, an ID number. One table has many more records than the other. How can I tell which records in the 'big' table are also in the 'small' table? [more inside]
I'm stumped on an Access/PDF problem. I'm printing a number of 1-page files from an Access report into pdf. The resulting pdf is almost, but not quite, right. If I select text - copy - paste into Notepad or Word from the .pdf, there's only gobbledygook, which means the pdf is effectively unsearchable. [more inside]
Yahoo mail password anomaly. [more inside]
Access 2003, ActiveState Perl, Win32::ODBC: my MEMO fields are being truncated to 255 characters when I pull them via SQL queries from a Perl script. [more inside]
Someone has been repeatedly trying to hack into my website. I'm on a windows box, running ASP and an Access Database. [more inside]
File sharing problem in XP.. I can access my laptop files from my desktop but not the other way around. [more inside]
Isn't there some simple way to list out all the fields in all the tables in an MS Access database? [more inside]
How can I get Microsoft Access 2000 to default to full-screen mode when I open a second instance? [more inside]
How do I implement a more custom look for a Microsoft Access database? [more inside]
How do I use Access to get information from Access databases and merge them into a series of reports?
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?
Visual Basic 6.0 and Access 2003 question.....(more inside) [more inside]
Database Query [+] [more inside]