Search results

it sounds like what you have is a lot of repeated data in the same table, and j's suggesting you review the tutorial on how to break it up to avoid repeating, called normalizing. otherwise you don't have a relational database, you have a fancy spreadsheet. sounds to me like what you probably...

posted in forms because i think the answer *might* involve using a form to pass the parameter, but point me in another direction if you think i'm in the wrong place- is it possible to have one parameter prompt for entry do two things? i have a db that creates a table whose data will...

if your report is based on a query, the parameter that access is searching for should be indicated in the query in the "criteria" row. strange that request for parameter does not occur when you run the query however.

try forcing a new record in the main form after your first entry (tab stop zero). put this code on the "on enter" event: DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 once a new record is created in the main form, you should be able to create a new record on the...

i think i can work with the bit of code in your example, but when i switched the form in the "cangrow" database to continuous forms the field size is always the same so i don't think it'll work exactly as i was hoping. but at least i'm headed in the right direction. thanks!

Need advice on the best way to display a “notes” field that gets updated/added to multiple times, in a form. (Access 2007) I’ve got a DB to track information about product changes. Each month we have a meeting and discuss problem products. I’m concerned with a notes/comments section...

i'm missing something. your response added these two lines to my original code: Me.cboDeveloperID.RowSource = "some SQL string" and Me.cboDeveloperID.RowSource = "some other SQL string" plus the requery at the bottom. i thought that meant i should put the sql to call...

Well I added the sql language where you recommended, but i am now getting "sytax" error and the new section of code is the culprit. everything is spelled correctly and all the fields referenced do actually exist, so I'm usure what I've done wrong. Any thoughts? Private Sub Form_Current()...

I borrowed code from the thread titled "Inactive names dont show on old records" in this forum, and it works GREAT! (one post away from being able to add links, sorry!) But one tiny problem: we have a form that will have one combo box for Associates (like Employee in the OPs DB) which I've got...

Ok, so it can't truly be automated, but it still needs tweaking from Excel to Access. Because we'll be entering the data in single form view, I think what I need to do is run a very simple query or report to show the history and give the person entering the next record a recommendation on...

I borrowed this code and it works GREAT! THANK YOU! Now just one more question. We have a form that will have one combo box for Associates (like Employee in the OPs DB) which I've got set to show only active Associates for new entry per your tips above, but we'll also have a combo box for...

uh, because i don't know of any other way to do it besides what we are already doing- physically looking at a list that tells us who can be chosen and who is next, and after assignment physically changing the list, putting the most recently chosen at the bottom and putting the "next up" name in...

I would like to know if anyone knows of a way to automatically choose next in sequence via form entry in Access 2007. We currently have an excel spreadsheet tracking who attends review meetings for new products. There are 12 people who are eligible to attend the meeting, and the next person in...

I know a lot about working with existing Access databases, but I’ve never been through a class (well a 2-day class 15 years ago doesn’t count) so I need suggestions on “normalizing” my data. I think I'm just not seeing the relationships because all I can see is the original table. :banghead...

It's not running through a query though, it's VBA code attached to the "on click" event of a button on a form/menu. Forgot to mention also that I'm using Access 2007.

I am compiling a mailing list from an ordering system file that is imported into Access from a comma separated text file. I may have 15 or more "unique" records for one customer/mailing address. We don't want to send them 15 letters, so I need to combine certain fields and separate data by a...

I'm new here. I took an Access class offered through work on the basics about 13 years ago. It did me little good, until I found myself in a position of having to work on (read: usually fix) a db created by a coworker who shortly thereafter would leave the company and become completely unable...

What do I need to change in the code above in order to sum the data in a field while concatenating other fields? I've changed it to fit my table and found that I'm getting only a count of the records that have been combined (that would be in the OrgRefCount field, which I have changed to...