Search results
-
J
Variable length forms
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... -
J
Date Verification
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... -
J
OVERFLOW during calculations
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... -
J
Linking to tables outside of MSAccess
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... -
J
Extracting specific positions for a field within a query
I have a 6 character field. For some reason the person who created this field decided to combine 3 unique fields into one field. I now need to extract the middle field so that it can be joined to another table. Here is the senerio: The Field is Project and it contains 6 characters - 123456... -
J
How do I display Query parameters on a Report?
I have created a report using a Query as the record source. Within the query, the user must enter a 'start date' and 'end date'. The query executes and the report displays the proper data. The user now wants the 'start date' and 'end date' to display in the report heading. How do I do this... -
J
Displaying data on a form and multiple sub-forms
I apologize if this subject has been answered in another forum. I am new to this web forum but not new to programming. I’ve programmed for 20+ years but rarely in MSAccess and VB. A little background: I have a main form (ProjectInq) with two sub-forms (BldgInq and CatInq). All fields are unbound...