Search results

Here's the situation. For data entry purposes, instead of typing out every single record, the user wants to copy and paste from Excel. This is, of course, possible by copying from Excel and using Paste Append in Access. HOWEVER, the average user will not know what Paste Append is and will...

Thanks for the input. I figured it out shortly after my post, and it was a really dumb fix.. I just had to stretch the subform to its actual size and anything adjacent would stay in place.

I am creating a form that also contains a couple of subforms. However, when I view it outside of Design View, all the other controls adjacent to the subform part of the main form are pushed down and displayed below the subform. I want the subform and the main form's controls to be displayed...

I did a search and was unable to find anything. Could you kindly point me in the right direction? By the way, I forgot to mention inthe original post that the assumption is that the table is already presorted by month so no need to calculate date sorting or anything like that.. Just need to...

Okay, here's the query as simplified as possible: Month - Days - PreviousMonth Month and Days are pulled from a table called Calendar. How do I get PreviousMonth to display the Month from the previous record? I was looking at a ranking formula, and it seems like it compares the field to...

Can you help me in doing this? DLookUp([ProductName],[tableProducts],[cboProductID]) That's what I came up with.. But I have no idea what to do with it. If I stick it under "Control" of the textbox, it doesn't work.. It doesn't work when I try to stick it in the VB code..

Okay, for simplicity's sake, I have a data entry form. It is bound to tableData. Inputs are: ProductID Customer Name ProductID is a combo box on the form. There is another table called tableProduct. In this table, is ProductID and ProductName. For convenience sake, when a user chooses a...

Okay, for simplicity's sake, I have a data entry form. It is bound to tableData. Inputs are: ProductID Customer Name ProductID is a combo box. There is another table called tableProduct. In this table, is ProductID and ProductName. For convenience sake, when a user chooses a ProductID...

Say I have a form with three blank textboxes: Name Date Description And I have a table with those same fields: Name, Date, Description How can I code a button to add a new row (record) from the form using the textboxes after they have been filled in? I am familiar with the basic data entry...

I have a query that draws from two tables, and the field in question looks like this: X: [TableData]![FieldA]*[TableNumbers]![A]+[TableData]![FieldB]*[TableNumbers]![B] It all works fine and dandy, but once I set it to sort by this field and run the query, it gives me the parameter prompt...

The Internet (and Google) is truly a valuable resource, as I would never have found this forum without them. Thanks so much!

I am basically making a form to streamline the processes and functionality of my database project, so basically it's just a form that runs queries. However, whenever it runs an action query, it always brings up a yes or no prompt for whatever action it is doing. Is there any way to disable...

Thanks so much. All of these answers have finally helped me to learn and accomplish my task!

Oh.. I was hoping there was a way to combine the numbers for each team in one query. For example.. Team A 2000 Team B 1000 Team C 9000 etc.

I have another question, which relates to the method you just mentioned. If I wanted to do exactly that (show sales by team), how would I accomplish this via a query? I know it seems like a real newbie question, but hopefully this will help everything else fall into place.

Thanks for the advice. I'll look into the solutions you guys provided. As for the reason for wanting to merge two records, the actual database I am trying to work with is a bunch of firms and companies. When two companies merge into one, I want to be able to consolidate the data (they're all...

Okay, I have two questions. First, if I have a table, and I want to combine two records together, how would I accomplish this? For example, say I have the following table. NAME SALES Bill 2000 Jim 500 Ted 1000 And by some miracle of science, Bill and Jim are able to fuse...