Recent content by patentinv

Hi, I'm currently testing my database in runtime mode to check for proper error handling. I have been told I need to convert all my macros to Vb code modules, for error handling. I've also been told that the filter by form is not available in Access Runtime. Is there an alternative way for me...

Hi, I've finally opened the Visual studio for MS Office systems tools box and found the access 2003 developer extension CD and loaded it, I've been reading the overviews on the CD as always it sounds easy to use, how ever through experience on APPs that is not always the case. Sure enough I was...

Hi, I have a popup form called Labor that is working perfectly fine, what i mean is that it is getting populated with data from the query I built using a single table called PrimaryBid_Master. However I have had to add many fields to this table before invoking a query on it, now I'm running...

Hi, With a table in open view can a record be moved to a different position, i'm using access 2003. Also is there any way to sort besides ascending or descending? I've got a lot of tables to make and if I forget a single column/field and have to add it later (like I have done all ready...

Hello, I've got a text box on my form header with a calculation in the control source that adds values from other text boxes on my form. My problem is that since the calculation is in the control source of my text box I can not save the sum of the calculation to a field on the forms bound...

Hello, I've got a text box on my form header with a calculation in the control source that adds values from other text boxes on my form. My problem is that since the calculation is in the control source of my text box I can not save the sum of the calculation to a field on the forms bound...

Hello, I ran into another programming road block. I currently have a combo box that is bound to a table with 2 fields and has 4 different options/records in it, with an after update procedure, that has different calculations for each record. I want to add a Dlookup command that will display the...

Hi RG, I figured it outw/a little help. Here's the code Dim prp As Property, ctl As Control Set prp = Me!cboRidge.Properties("ListIndex") Set ctl = Me.txtRidgetot If prp = 0 Then ctl = ([txtridge]*100/30)+0.4 ElseIf prp = 1 Then ctl = ([txtridge]*100/45)+0.4...

Thanks RG, I don't think this will work, beacause each diifferent option/record in the combobox needs a slightly different calculation, I had a combo box for each selection but it clutters the form up w/unnecessary boxes. So I'm stuck wanting to use only 1 combobox, w/a different calculation...

Hi RG, I really struggle with VB code, Sorry. Here's the calculation I have in the txtridgetot box now in the control source=([txtridge]*100/30)+0.4 [txtridge] is another text box on my from, if you would could you give me an example of how this calculation would fit into your example code...

Hello, I have a combo box called (cboridge) bound to a table called (Ridge)with two fields/columns called (dollar amount) (Material type)with 4 different options/records, when the user selects his option/field the dollar amount shows stays visible in the (cboridge) combo box Then I have a text...

Hello, I have a program/database that I'm building in Access 2003, It has new client/bid entry form that has many text boxes for instance: Client, address, Phone numbers, Date etc. These text boxes are actually populating the same text fields in the PrimaryBid_Master form. My question is every...

Hi, Is it possible when choosing a combo box to have it make a text box visible, when in this text boxes properties you've chosen visible=NO. Can an event procedure or some code be written that will make visible=YES. Thanks any help with be greatly appreciated

Hi RG, I really appreciate your help, Now if I place this code you just sent me in the after update cbofelt1536 combo box, I see hwat we are accomplishing it will place the total in the txtinv1 text box. Now i have to make this value in the txtinv1 appear only in the form header under the...

Lets make sure I understand. We'll call the invisible text box (txtInv1) default value=0 with a calculation of (11*25) = 275 in side of it. reads like this in the control source=[cbofelt1536]*[txtTFelt] Now in the from header on the example print screen where the 30 and 40 yr calculations go i...