Recent content by MamadouNdaw

The field with the key is not on the form. Let me explain in greater detail. 2 Tables tblWords _____WordID (AutoNumber Key) _____Word tblDefinitions _____DefinitionID (AutoNumber Key) _____WordID (Long Integer) _____PartOfSpeech _____Definition Referential Integrity is on. 2 Forms...

That is exactly how my tables are set up. My query is as follows: SELECT tblWolofWords.Word, tblWolofToEnglish.WordID, tblWolofToEnglish.DefinitionID, tblWolofToEnglish.PartOfSpeech, tblWolofToEnglish.Definition FROM tblWolofWords INNER JOIN tblWolofToEnglish ON tblWolofWords.WordID =...

I have a simple database that acts as a dictionary. There is a One to Many relationship between the word-list table and the definitions table. Each table has an AutoNumber field as the primary key. I have setup a query to display all of the words in the dictionary and their corresponding...

It is actually already set up like that. Basically all sale information is very easy to enter as I use combo boxes. However, it is not feasible to have customer information for every customer. This is a cyber café, so there are many random, non-repeat customers. So, when a number of people...

The business for which I am designing this database has certain types of transactions that occur many times the same day, and do not require detailed information. On the main switchboard, I would like to create a button that allows the instant input of a transaction. My table system is rather...

Sorry to bump, but anyone?

Where do I place that second line of code relating to Form and Subform? Well, I attached my entire database to give someone an opportunity to see what a mess it is. But, the form in question is frmTransaction. You will see that there are many variations of the transaction subform as I am...

After a long hiatus, I'm getting back to learning access. So, I have 4 subforms each within a tab control. In addition, I have a combo box located in the page header. I would like the tab to automatically switch upon changing the combo box to a specified value. If someone can offer me some...

Thanks for the advice. This works well; however, there is a problem. For example, if the first entry is a service, not just the product field on the particular row is locked, but the entire Product column is locked. Using the button, this can be circumvented by click the next row then using...

Ok boys. That was very clear, and now works like a charm. The only problem I had with your code is that the .Column(1) portion produced a syntax error, but without that it works perfect. I don't find the concepts of vb code and access complicated; however, knowing the code commands and...

Yeah, I suppose that could work well. But it wouldn't slow the database having 4 subforms open simultaneously despite the fact that 3 are hidden?

Ok, new development. So this form where I'm attempting to lookup the price happens to be a subform. You knew that from the picture, so... When I open the sub form independently in form view, it actually works perfectly with the old code. But, when I open the parent form in form view, and...

Yes, the two ID combo boxes do have controls. That template that you posted does exactly what I want, but I can't seem to get it working with my database. This is the adjusted code: Private Sub ServiceIDBox_AfterUpdate() Me.PrixUnitaireBox.Value = DLookup("[PrixUnitaire]"...

I hate to bump this old topic but I'm doing the same thing, but it is not cooperating. I have made it so the proper price comes up when I enter a number in the combo box, but it changes all the prices in the list. I included a picture to make it clearer.... As you can see, the total column...

I'm sure there are many ways to do this, so I'd like a recommendation as to the best method. First, an overview: The database revolves around entering transaction data to draw a general picture of all money in and out with regards to a small business. All transactions filter through a main...