Search results

AunN Open the form in design view and right click in the box in the upper left corner, select properties. Click on the Data tab and in the record souce box. Click the drop down arrow to the right and select the table with the data you want to display. You sound like a new user, so I will...

Strike Eagle: The easy answer is to do an update/append query from the source table into the target table with just those fields for that table, then change the target table and update/append the other fields to that table. Can't figure out why you want to do this. Anyway, if you have a real...

PaulA, I would suggest you put the record source in the properties of each sub form and not in the open event of just one sub form, which is what your code indicates. Each form should be linked through a Master/Child field so the proper records are displayed with the main form selection...

Matthew, I want to say I am not testing this beforehand, but I think it is what you are looking for. Create a query with all three tables. Put Dunning in the middle and draw the relationship lines from the Dunning invoice number to the invoice numbers in Main and VendorLines. Now, carefully...

Robert: Your problem is not how do I clear it but why is it showing up; get rid of that code. Your item form probably has a combo where you select batteries. The value of the combo is the primary key number. This number will also be in the itemtypes table where you list the various sizes of...

You use a combo box on your form and your users select the product choices (they see the text), but the combo stores the number. Read up on combo boxes, they display the text but store the numbers, which is fundamentally how databases work. As far as where to save this number, it depends on how...

tassiegal: Are you asking for someone to build you a switchboard? I just use a form and tell Access to open it when the database opens. I also build a reports form to handle the multiple options that people need to filter their results. You have less than two weeks, let me know if you want to...

freddawson: Putting multiple things in a field is a bad idea and you really don't want to to this. You will have problems down the road. The answer to your question, however, is concatenation. Something like things = things & " " & newthing. Or you could add twenty columns to your customer table...

patatrac, it is. One option would be to include the date and time the update was made and use this to filter a report. When I add a new record I have a column called TransLog formated as general date and I use now() to get the date and time in there. Whenever the record is changed you update the...

orshims, you might want to rethink your strategy. Why is it a problem if a report displays a field that is empty? On some records a field could be empty, but on others it could be populated, so the field should be on the report, right? Having said that, there is an option on the report to shrink...

ddrew: I don't have access 2007, (Access 2002) so I will try to guess the solution from what you have written. Combos can only display one record, so if an owner has two dogs, which one does the combo display. There are two ideas that come to mind, perhaps you need "cascading" combos where the...

nylex, Bear in mind that I have not tested this, but here is my suggestion. Get the setfocus out of the double click event. Perhaps create a procedure with the setfocus and after all else has executed in the DC event, the last line calls the procedure with the setfocus stuff. If that doesn't...

David, OK, I think I understand now. The log is really a log of all fistank activities and some of those activities impact the inventory. Here is the kicker, your primary goal. "The main object now is to log all activity, and stock within the same form." So how do we know when the activity is...

Just read over my post and realized I forgot one moderately necessary command. Before you start the do until loop, you want to make sure your "cursor" is on the first record of the recordset. So, add this line. rstNewTables.MoveFirst Again, make sure this is above/outside the loop otherwise...

MM70, No programming experience but you are doing For Loops, not bad. This should rock your world. You create a recordset of table1 (which is like a copy in ram) and use the movenext command to progress through the table and the EOF (end of file) to know when to stop. Try this. Dim dbs As...

Melissa, Access is very much like Excel here. When you type in a number, it is not really in the cell untill you hit enter or move to another cell. In the checkbox afterupdate, try me.refresh, it sends any values from the form to the table, like an enter. Also, the negative one in Access is...

khwaja, A few general observations. Before you call a function, check if the fields are populated. This way you can avoid using variants and you can send the value as a valid date or string. You are sending five values to a function, a bit too much. And you are sending back a null, which is...

David, I am a little confused because the transactions table implies things happen there. If I take money out of an ATM, that is a transaction, and my account / inventory is reduced by that amount. Perhaps we should rename the transaction table to Supply, or ReStock or something more...

CTSmith84, If I read you correctly, you have the advertizing banner in a group called groupheader1. In the design mode of the report, right click on the box in the upper left corner of that group and select properties. Locate the "Can Shrink" property and set it to yes. Then click on any and all...

David, Great work with the tables. Your confusion with the Inv/Trans is understandable. The answer is the transaction table will have the InventoryID in it, because each transaction has to have a part associated with it. So with that one number, (TID) you can get anything in the transaction...