Search results

No bashing taken; I know the extent/limits of my skills. :D That's why this discussion and these forums are so valuable; I learn more EVERY DAY. W/r/t the project - this is where the idea of possibly having me manage it and let the grunts do the work comes into play. My sups all agree on the...

Good point. But then again, the answers I'm getting here are pretty informative, and it sounds like an Access FE might just be what we need. Here's the big zinger...I don't know how to use DAO at all. Everything I do in Access is done using the development tools within Access; all my coding is...

Hahaha - LOTS to think about, Doc, but definitely worthwhile, and your points make a lot of sense! W/r/t the ORACLE licenses - My company is BEEEG. I'm 99.9% you've heard of us, and I'm sure we have up-close-and-personal-agreements with Mr. Gates and Mr. Ellison. And if we don't, I'm sure we...

You have? Gimme gimme gimme! Seriously, though, this was done by another department using a HUGE VB function written into an ancient Excel spreadsheet. The code is LONG and TEDIOUS and, since it's using outdated commands, it only runs on this pokey Win95 machine using old versions of Office...

Seems like you've already decided not to do this with Access. On the contrary; if the front end can be in Access, I'd probably prefer it, as I would be able to take a more pro-active role in development since I know a little (very little? !!!) about building front-ends for that platform. I'm...

Hey buddays, I recently started working for a large (!!!) company and successfully managed to switch my department over to a DB management system (using Access, since that is what I know) after years/decades of using spreadsheets. My higher-ups have been so amazed at my parlor tricks, that...

Microsoft has knowledge base article here that show you how to set-up an automated mail-merge. I've used it, but you need to keep a copy of the document that Access will be merging with in a static place. I've found it difficult to keep my users from moving the document or renaming it, etc., as...

After you check your tables like Shay suggested, check your relationships, too. I often get bit by the "Duplicate Values" message when I have cascading updates in my table relationships, but build quick ad-hoc relationships in queries and then try to update records from there. And after the...

Your question is a bit unclear - I can't tell if you mean 1. "how do I change records in a table through a form", or if you mean 2. "how do I put these changed records from 3 tables into a new table?" If you meant #1, then you should be able to change records in multiple tables on a form...

In the upper left of the report (and forms, for that matter), there is a box with a little black square in it - double click and that will call up the Report Properties. Look for the Record Source attribute (should be right at the top on the Data and/or All tabs), and there will/should be a...

Easy! In the main Database Window, you can simply cut and paste objects (Tables, Queries, Forms, Reports, etc.) repeatedly. (You can also do this across databases, although the Import function makes it easier, especially for bulk copying.)

Sounds like you need an Append Query. There's been a fair amount of discussion on this in the past week or two, people have been asking how to set up survey databases. You can set an Append Query to run using a Macro or VB in the "After Update" event of your Form, or using a specific button on...

Elyisum, it sounds like you're trying to do some sort of mail merge? Both Word and Access have mail merge functions, and Microsoft has some instructions on how to automate that in this article if you want to put a big, fat button on your form. Hope that helps!

Without more info it's difficult to gauge where you're getting hung up. It sounds like you need a drop-down combo box or a list box which will let you choose records. (I'm assuming you got far enough to set up your form and can see your records, right?) In Design View of your Form, make sure the...

Hey Tinggg, I was misunderstanding what you were asking, but I think it's clear to me now. You want to see the spaces for every question, whether or not every user answers every one, right? You're looking to see even places that might be blank? I thought you were just asking to see all the...

Hey Tinggg, This looks like a prime candidate (IMHO) for a Form-Subform solution. What I would do is build two queries - one that just grabs User Info (something like "qryUserInfo" or whatever), and one that grabs the question/answer info (like you've done here, maybe called "qrySurvey" or...

Hey Tinggg, "FK" means "foreign key". W/r/t your question showing up on the form: It sounds like you just need to include the correct tables and fields on your query, and then put corresponding bound textboxes on your form. (Make sure your one-to-many relationships/integrity are set correctly...

Hey Tinggg, these types questions get answered a lot on this forum - you are looking to "normalize" your tables, and you're real close! 1. This will have all the people who answered your questionaire. Self-explanatory. tblContacts ContactID - PK First Name Last Name etc etc 2. This will...

ReAn's will work, but you can cut it down a step and get a bit more flexibility. Go to File->Get External Data->Import, and then choose the database and everything you want to import. There's an Options button, and from there you can designate how you want things imported, and if you want tables...

Could you just designate "mm/yyyy" in the Format property of the field storing the expiration date? I've found that when you use a Date/Time field, you can just put in "mm/yyyy" or what-have-you for the format instead of using one of the pre-formed "short date/long date/etc" options. While...