Search results

Hi Guys.. I am pulling my hair out with this one. I am converting some huge table from an old DBASE format.. No problem there. However, I have one table tblProdAux that has two fields [Part_Num] and [Weight] part number is fine - simple number field.. however i need to convert the [weight] field...

I am trying to design an Invoice Report. The problem I am having is that the spacing between the items in the detail section, is too much. I mean.. that one line prints several inches below the other. Also how can I have the report print multiple header and footers, if the data in the details...

How can I set up a Text Box or Combo Box That lets a user determine the number of copies of a report printed from a and a command button. Example: On a form I have a lable that refers to "Report A" I have a comman button that allows a user to directly print the current record in Report A...

I have a dilemma that i need some help with... I have a field called [Total].. i then need to calculate a discount from the field [Total] to come up with [NetTotal].... easy enough.. however; I need to be able to choose from EITHER a Variable (Input by user) percentage discount say(25%) or a...

I Have two tables tblCustomers tblDeals I Have a main for which is linked to "tblCustomers" and a SUBFORM that is linked to "tblDeals" both have a common link to CustomerID from the tblCustomers table, and a One to Many relationship. This is fine; however... When I open the main form it...

Hi Guys.. Little Stumped here.. Here is what i need. I have a form with a command button to delete the current record.. That is simple enoungh.. However,, i need this I can create a message box that asks the user to confirm deletion... yes or no.. again easy enough... Now what i need is a pop...

Ok.. am not sure if I am going to ask the right question here, but here goes... I am almost finished with a particular app, and do not have a bundle of money to spend on software that allows a registration code to be entered to ensure purchase. However, i was wondering if some of you guys had...

I have a Calculated text Box [TotalEquity] this can a return a positive or negative currency amout. OK to here; I arrive at this control by the following: [Allowance]-[PayOff]=[TotalEquity] I need to provide for a control that returns the negative value(if any) of [TotalEquity] and then place...

hi guys. I have looked thru the posts here, and have found some that are close.. But none that works for my particular case.. I have a currency formatted and unbound calculated text box that displays a calculated currency amount If Me![TotalEquity] <= 0 Then Me![TotalEquity].ForeColor =...

OK I have tried every syntax i can think of and am still receiving an #Error with a null value... Please help Ok I have a table (tblAdjustments) AdjustmentID Description AdjustmentCost from this is created a subform.. in the footer have a calculated text box txtTotalAdjustments Control...

Ok Let me try to explain my dilemma. Am trying to construct new db, where customers can by individually or jointly. Have a orders form where when you enter the customer information, you can use an option group to choose "individual" or "joint" purchase. i would like the CO Buyer Fields and...

Could someone please explain to me how to open a form from an external access database using automation. I would like to open the form from within another database. Is this possible? If so, how? Thanks A Million Jeff

Hi ! I was wondering if any of you gurus had come across a good scheduling/appointment ocx that works with both Access 97 and 2K that doesnt cost a fortune. Would hate to have to code something this complex, when I am sure some has already invented the same wheel... Thanks in advance.... Jeff

Hello. Someone please help..... I have an unbound text box on a subform which is created from a paramater query.. Quite simply the text box is a counter for the number of records returned from the query. I have the unbound text box placed within the footer, as was told is good practice. Every...

I have an application that I would like to be able to create a commannd button on the form which would pouluate a memo field box with the current date and time. However, it must not disturb any of text that is already there. I am using this to keep a record of notes taken when speaking to a...