Recent content by deljr15

What is the error message you get when you try to open the database as a second user? I have seen this happen if user 1 is in exclusive access, or if user 1 is/has edited anything sense last close.

Has anyone found a way to move the navigation bar up to the ribbon? I have been able to add the - First, Last, Next, Previous record buttons but I am stuck at the search box I have been doing some googling and I have seen some work-arounds. However these were to add a text field on the form...

Thanks I managed to get it working I just thought I would post my solution for other people Here is the line of code I used Me.[Purchase Orders Data Subform].Form!cboProduct.Requery Here is a broken down version Me.[Subform Controll Name].Form![Controll on Subform].Requery It seams this...

Hi I am trying to make a form for Purchase Orders. I want to be able to select a vendor on the main form and have it only list the available products in the subform. Example: Main form = [Purchase Order] Sub form = [Purchase Order Data] Vendor control = cboVendor -- located on main form...

Nice that is much simpler then what I have been trying to do, and it almost works :) The problem is it displays the ID of the account/wo not the value of it... I'm sure it is something simple that I am doing wrong. Edit: after some testing The individual fields display properly, so I tried...

Thanks for the response. What this is for is to insert a description of a item. It will get the data from a table storing item properties (properties may be a bad word to use here) the table consists of ID, Item_Id, Description, Value. I then pull all the data from the Inventory_Data table where...

I'm not sure if this belongs here or in the forms section. I also did not see anything applicable in the search. (tho I may not have searched the correct verbiage) What I am trying to do is set a property of a field in a tabular form on a per line basis. I can think of lots of ways to do this...

thanks pbaldy that solved the 3021 error. However this opened up another problem... because I'm assigning a value to a field in a tabular form it applies it to every line weather its applicable or not. I'm not sure weather I should start a thread based that question or not.

I am trying to put together a report to display a purchase order. For our orders we track the cost to either a work order or a expense account. For displaying/printing the PO I want to consolidate the 2 separate fields to one text box. I would like to do this in VBA so I can learn from it :)...

Hello Everyone, I am a CNC programmer from the Twin Ports area in Northern Minnesota (USA). Tho I am new to access, I have developed php/mysql applications for purchasing and inventory control/tracking. I have never been good at this kind of stuff... so I'll call this my intro :)