Search results

I've posted my relationship screen so you can see what I'm working with. I want to return the price from my transactions table for the value '1' in the ID field in this transactions table. That would be my first field in the query. The next one would be to do a sum of the sellprice field in...

Hello, I have a table I created for keeping track of the transactions within my business. Up until recently, I would enter the shipping costs of something I sold as a new record (row) in my transactions table. I realized it would be much easier to simply create a 'shipiping costs' field within...

Here's where I'm at guys. Table 1: (Transaction ID) Table 2: (Card ID) (Buying ID) (Selling ID) I have a one to many relationship from from Transaction ID to Buying ID as well as a one to many relationship from Transaction ID to Selling ID. I have a form based off table 1. So, I would...

On a form, I have textboxes that reference fields in another table. Out of nowhere, I now noticed that they are no longer correctly showing the values, but instead have this #Name? Does this just happen at random to anybody else? I know I must have done something, but I didnt. Thanks for...

SELECT tblInventory.ID, buy.[Transaction ID], sell.[Transaction ID] FROM ((tblInventory INNER JOIN tblTransactionID ON tblInventory.ID = tblTransactionID.[Card ID]) INNER JOIN buy ON tblTransactionID.ID = buy.[Transaction ID]) INNER JOIN sell ON tblTransactionID.ID = sell.[Transaction ID]...

I have three tables. The 1st table is for the sports cards. Each record is an individual sport card and the various columns and fields give detailed info about each record (card). The 2nd table is for my transactions. Each record is a specific transaction whether is a card sale, card...

I accidentally entered a value in a query, that may at some time have a value but doesn't as of yet. So, I need to get this value out but it won't let me know because it can't contain a null value? Any tips? I want this to go back to being a blank value I believe, but it won't let me because...

I've got this table with two particular fields in there (Year) and (Manufacturer). I've just been having these two fields use a value list to select from for entering the correct value for (Year) and (Manufacturer). However, I would like to set two new tables up for these two fields that way...

So...I looked up some info on this, but I can't seem to figure out why it's happening to my form. So, on my [Transactions] form I am entering a new transaction number. Let's call it (105) So, now I click one of my command buttons which will pop up a new form allowing me to enter new...

So...I looked up some info on this, but I can't seem to figure out why it's happening to my form. So, on my [Transactions] form I am entering a new transaction number. Let's call it (105) So, now I click one of my command buttons which will pop up a new form allowing me to enter new...

When you open a macro, on the bottom of the page there are six different action arguments that I see. The one I have a question about is the 'Where Condition' In the Northwind 2007 sample database, it reads 1=0 Does this simply mean that since 1 will never equal 0, it will not match any...

Is there a way to save the lines and colors I've added to a form header and apply that to every other form header in my database? Or be able to choose other forms that I would like this combination of colors and lines in my form header to be used in other form's form headers? Btw...How does...

Hey guys, I'm using the DLookup function to pull in values from another table into a form. Here's the formula. =DLookUp("[State]","tblCustomers","[ID] =" & [Forms]![EnterNewTransaction]![ID]) =DLookUp("[SCF_ID]","tblCustomers","[ID] =" & [Forms]![EnterNewTransaction]![ID]) The problem is...

Hey guys, I just want to add something to my home form that I can use to remind me of projects I need to get done. Whether this is a simple text box with a checkbox next to it, that I can mark it when I get or done or what I'm not sure. I'm wondering if anybody has any examples or ideas that...

I'm noticing that tabs placed in my form header are not available to be tabbed in my form detail area? I moved some check boxes into my form header area and when I tab from different controls on my form, these are no longer included. Is there a way to include them to be tabbed with the...

I would like a pivot chart to only return values within the current month. I can get the pivot chart to show me all values and their respective datees. I'd like to have this pivot chart filtered to only show values that match with the actual current month. In this case, only return values...

How come on one of my command buttons it places a white border box around the control? I have the 'back style' to transparent, but this white box still shows up on my command button. However, none of my other commands have this white border box. All of the properties look to be thee...

Is there a command to set the cursor to a certain field upon load? I'm assuming there must be something that would go under the 'on load' event of the form. I could be wrong, but that's just a guess from a rookie. Please advise, Thanks Brady

I have a textbox that I would like to show data from its table. So, I go into properties for that textbox and go to 'control source.' I click the three lil dots and bring up the expression builder. From there, I go into the folders and select the correct table from which I will select the...

Hi all, I have a form for entering transactions for my business. On it, there is a field for selecting the customer. On the very bottom of the screen where you can move to the 1st record, next record, last record, etc., I've noticed an issue. By clicking next record, it doesn't take me...