Recent content by pcdummy

Thanks I got it!! Just used VAL function in a separate Text Box works like a charm thanks alot!

Thanks for the quick reply.. How do I actually use these values to separate them then?

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...

Beautiful!!! Thank s alot!

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...

Anyone Please...Still Searching!! Jeff

Wait.... Design Error??? Your linked child field should be AttenddeeID or something like that... Include a number field in your Projects table for this autonumber field from the Attendees Table... Then Check your relationships, and make sure that you have a one to many relationship from...

Try This Create a Seperate Sub Called EditProject Private Sub EditProject() On Error GoTo Err_Editproject DoCmd.OpenForm "yourformname", , , "[tblNewProjects]![Proj_ID] = " & Me![Proj_ID] Exit_EditProject: Exit Sub Err_EditProject: MsgBox Err.Description Resume...

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...

Create a Seperate Report And Choose a Specific Printer for that report at design time. Is this an option, maybe? File..Page Setup..Page..Specific Printer. HTH Jeff [This message has been edited by pcdummy (edited 07-27-2001).]

How about this? IIf([LBS] < 34000 AND [MRT] < 40, [Something]+[Something]+154,[Someting]*[Something]+[Something]) I think you need to use the Iif Statement. Format IIf(Condition, If meets Condition, Else This Value)

Anybody? Any Ideas? Thanks Jeff