Search results

Can someone help me please figure out why I am getting an incorrect value (this is just one of the example) as a result of a calculation in my query. Access 97: Table- - - - - - - - >Fields- - - - -- - ->Values tblMth02- - -- - - ->Absorption- - - - >28632.70 tblAbsAll- - - - - - >MachineDir-...

Help, We have a database created in VB3. Trying to get a report but I keep getting this message. Error: Error # 3146 has occured Error message {ODBC--call failed. [Oracle][ODBC Oracle Driver][Oracle OCI]ORA-01400:mandatory (NOT NULL) column is missing or NULL during insert. (#1400) } Can...

Hello I was testing a code from Microsoft website: http://support.microsoft.com I was successful but I needed to add 2 more lines of code without user intervention. a) After compacting the database, I want to delete the old/original database. b) Rename the new compacted database to the...

In my table I have one field called Description and each record has unique description. I also have a field called Category with values called Level1, Level2 and level3 and this field Category are what separates the 3 from each other. In my form called Main (temporary container that holds the...

Hi I have this expression in one of my textbox in a form: ="CA" & [lbxCuttingTools].[Column](0) & IIf(IsNull([txtInsertDesc]),"","-" & [lbxInserts].[Column](0)) & IIf(IsNull([txtAdapter]),"","-" & [lstAdapterResult].[Column](0)) [Column](0} always equates to the Primary key When testing...

I have a list box where records are filtered depending upon the value entered in a text box. All of a sudden strange thing started happening although it seemed to happen only to certain records that are almost identical but perhaps vary on certain characteristics. Example: If there are 3...

If a new record will be similar to the previous one, automatically fill text boxes with that data for the user to edit. On my form, in the BeforeInsert event, I have: Call CarryOver(Me) In the module called basCarryOver this is my code: Sub CarryOver(frm As Form) On Error GoTo...

Help! I'm designing a form in Access 97 where user have to extract different values from one form and all these values are being transfered/saved into another form but all of a sudden I started getting this error and could not add a new record. Run-time error '438': Object doesn't support...

Hello!.....would anyone wants to help me? FYI: Access '97 I have a form that serves as a template. I have (unbound) textboxes for comments where users enter different information depending on the type of task that's being done. I already tried it but when I close the form and open it again...

Hello! Help! Unfortunately I have a very complicated database and without using lots of verbiage I have narrow down the situation and hopefully someone will understand what I'm trying to explain here. txt298 in form2 has value that is coming from form1 and this is what I have in control...

Please! Please! Please! Help I have a very complicated form and had put in too much work. Without having to recreate the design of my form, how do I delete the last page? Have search the Help for topic but couldn't seem to find an answer. Many thanks!

Hello, I created a form to serve as a template and some of the values of the controls require user input. (One reason why a report will not serve the purpose). My boss is getting too fancy and he wants a different header for page 1 and pages 2 & 3 will share the same header. How do I...

Help! When I do a print preview on my report it displays 1 of 1 but when I print the report I get a total of 4 pages. I get a blank page for each page... Can anybody help me? Thanks