Search results

Thanks for the response Alan, I tried, but still getting exact same behavior from the buttons as with the original code. I have an inventory item in Row 3, with a Quantity in Stock (Column C), a Received (Column D) , and An Assembly (Column E) Now If I enter a new product in Row 4, and add to...

try this code: Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[yourfieldnamethatcontainsyears]=" & str(Nz(Me![yourcomboboxname], 0)) If Not rs.EOF Then Me.Bookmark = rs.Bookmark

Hi, I know this is more an Access forum, but maybe someone can help me. I have the following code in a basic Excel Inventory worksheet : Private Sub Assembly_Click() Range("C3").Value = Range("C3").Value - Range("E3").Value End Sub Private Sub Received_Click() Range("C3").Value =...

Thanks Michael - I think i understand what i need to do! I'll give it a try right now and post if it is successful Thank you for your suggestion, Brian

Hi Michael - I dont have a continuous form, its in single form format because its got a subform and does a lot of fairly complex computations based on dropdowns. I believe it is set up the best way possible for my application. I build a product based on many different tables through dropdown...

Hi thanks Michael and Ruralguy for responding - Im not sure how to go about this based on your suggestions- I have limited informal vba knowledge and ususally piece together code based on the many examples i find online; such is the case with the code i pasted in my question. Please explain...

Hello - I have a form which calculates and stores a cost into a field through the 'on current' event of the form. I used code which cycles through my recordset on the click of a button and updates the entire recordset when clicked. The code runs but doesn't seem to alot enough time to allow...

Hi Bob- I find that the problem lies in the report design, not in the sql. It seems I am doing a couple of very complex calculations on the report itself, setting the control source for one field in particular that is getting stuck without the proper data and preventing my report from opening...

Thanks Bob :D

Hi Alan, thanks for responding. I forgot to mention in my original post - I am using a query for the recordsource of the report, and if i run the query standalone it works fine, the problem seems to be occurring in the design of the report which is preventing the report from opening if query...

Hi, When I run my report which incorporates a parameter query asking for start date and end date, i get the following: error 3071: expression is too complex / can not be evaluated / typed incorrectly My report is based on 5 tables. It seems if one of the tables is missing information that is...

hi - i am new to the site i was trying to post a thread to reports, but it said i was signed out, when i signed in it automatically posted it to introduction page - can i move it over to reports? Thanks, Brian

Hi, When I run my report which incorporates a parameter query asking for start date and end date, i get the following: error 3071: expression is too complex / can not be evaluated / typed incorrectly My report is based on 5 tables. It seems if one of the tables is missing information that is...

Hi thanks very much for the welcome and for replying! No, the product form is not a subform. My Sales order form (frmSalesOrders) contains a subform (fsubProduct), which has a combobox that gets it rowsource from another form / table (frmStandardCost). So if i'm writing a sales order and want...

Hi everyone! I am a new poster to the site and hope to learn much here! I have a Sales order form that has a product subform within it. The product is selected by a combobox which pulls a few numbers in addition to selecting the product code number itself. In case the info retrieved from...

Hi - i dont use macros too much and have basic vba knowledge Is there a way to use a macro to attach to a button that will cycle thru all of the records in my form? my goal is to have the 'on current event' run on all records in my form at the click of a button which will update the recordset...

Hi, This is my first post here and I am definitely a novice programmer, much more of a designer in Access and in much need of help from experienced users! Ok, here it goes! I have a form that calculates a cost for a product that we manufacture, composed of several components, based on...

Hi - I am relatively new to database designing but not a complete novice. I started a project in 2009 for the company i work for. I am designing an Access database to replace an Excel based system used to handle all company figures and records including Sales, Inventory, Raw materials, and...