Recent content by JRG0620

JZWP22, I do have an unbound field on the form with that calculation. The issue is it does NOT do the calculation until the record is written back to the database. I need/want the calcuation to be done as the user enters information into each of the fields. This provides the user with the...

I understand what you're saying about the relationships and if I designed the application, that's how I would have done it. The problem is that I have to maintain/update the existing processes. A Project can exist without a Building. For a Building, the fields exist: GenCon, SitePrep, Roof...

JZWP22, I'll see if I can be more specific. My table includes the following fields: Project, Bldg, GenCon, SitePrep, Roof, HVAC, Plumb The key to the table is Project The user enters the Project Number and all associated Bldg information is displayed. There can be zero records for the...

I have a slightly different issue but I think this is the proper thread for the post. I have a form bound to a table. The table has a primary key of Project and Bldg. The table has the following fields: Project Bldg GenCon% SitePrep% Roof% HVAC% Plumb% The user enters the Project Number and...

Let’s see if I can explain my issue in more detail. I have a form bound to a table. The table has a primary key of Project and Bldg. The table has the following fields: Project Bldg GenCon% SitePrep% Roof% HVAC% Plumb% The user enters the Project Number and all associated...

Misinglinq, thanks for the reply. I guess I don't know enough about MSAccess to be able to do what the user wants when the table is bound to the form. I'm finding it easier but yet more time consuming to actually write the VB code. For example: Bldg Pct1 Pct2 Pct3 Pct4 Pct5 are the...

Adam, Thanks. What I meant by 'grow' is that there can be 0 records in the table for that specific Project or there can be 50+ records for that Project. The record count grows not the record attributes. I thought about a continuous form but without the form being bound to the table, how are...

I need to be able to display 1 to N records from a table as well as add/update them to the same table. Here’s my story. I have a table. The key is Project and Building. The attributes are several (10) different percentages. The user wants to be able to enter the Project number and display...

I apologize if this has been posted in a prior thread but I cannot seem to find what I’m looking for so I’ll ask via a new thread. I need a date validation routine that will determine if the date entered is in the proper format. I have several unbound fields on my form and the dates are in...

NEVER MIND. I tried changing my program's DIM statements to be Double instead of Long and that appears to have worked. Not sure what all the differences are but the data now seems to be correct.

I need a little more help in this area: On the table my fields are classified as 'Double'. Within my program I have them defined as 'Long'. The issue now is when I calculate the result by taking the table field * 100, everything works well until I reach a table fields that is 99999999 or...

DCRAKE, Thanks for the quick reply. That got me around the overflow issue but now it changed my record formats. Before changing the fields to 'Long', the formats were what I needed to match the next program. Since I changed to 'Long' my record length is now shorter than before. Solve one...

I am trying to multiple a datbase integer by 100 and I get a dialog box that all it says is overflow. When I take the * 100 off the format, everything works fine but the number is not correct. My statement is as follows: MyQualcost = IIf(IsNull(MyTable![Qualcost]), zeroes...

I am linking to an ORACLE table and to do this I have set-up an ODBC link which is secured by an ID and Password. I am doing this so that I do not have to duplicate the data from another application into my MSAccess application. The issue I am having is that when I go to run my forms and/or...

Thanks for the quick reponse and information. I used the suggestions and the tutorials and figured out I could use the mid command: ProjCampus: ((Mid([Proj],2,2))) This got me what I needed. Thanks again.