Search results

thankyou i found what i didn't enter. Private Sub Form_Load() If Not IsNull(OpenArgs) Then Me.CustomerID = OpenArgs End If End Sub

Private Sub CreateCall_Click() Dim Msg, Style, Title, Help, Ctxt, Response, MyString Msg = "Do you wish to create a item for this customer?" Style = vbYesNo + vbCritical + vbDefaultButton1 Title = "Confirm Create Item" Help = "DEMO.HLP" Ctxt = 1000 Response = MsgBox(Msg, Style, Title, Help...

well sorry i already been through and read that and it's still doens't work, go fig.

well treat it as a beta -it's MS at the end of the day. TBH stick with 2003 because the new licensing terms theyhave are not gonna get much sales.

beta for ya. Best to get feedback off to MS and it'll get sorted.

I trying to setup a custom yes/no. In the table I set the yes/no format "Made";"Recieved" » lookup 'text box' I made the form and in the textbox and did value list with made and recieved. but it's giving me the could be text when number should be used and vise versa thing.

Private Sub PrintCustomer_Click() DoCmd.RunCommand acCmdSaveRecord DoCmd.OpenReport "Customers", , , "[CustomerID] = " & Me.CustomerID DoCmd.Close DoCmd.OpenForm "FrmCustomers", , , "[CustomerID] = " & Me.CustomerID End Sub it doesn't like line 5. Anyone got any ideas? This form with this...

having no luck with either i'm affraid - stuck as a dodo

brill thxs

How do i go about making a confirm yes and no dialog. I know i can do it with a form, but would rather have a proper one :D

Well that went st8 over my head. I'm only got basic knowledge atm of VBA. It's a work in progress

i was given them 2 codes for changing text in my DB fields. Now i believe they can be used on the lost focus part of a form textbox. I just can't implement it.

Public Function ReplaceAbbreviatedNames(Address As String) As String Dim PositionOfLastSpace As Integer PositionOfLastSpace = InStrRev(Address, " ") ReplaceAbbreviatedNames = Address Select Case Mid(Address, PositionOfLastSpace + 1) Case "st" ReplaceAbbreviatedNames = Left(Address...

yeah the item is autonumbered and the autonumber for that customer is copied into the item form to link them.

well that code works i guess as it should but the item record is still being created.

DoCmd.CloseForm acForm, Me.Name, acSaveNo doesn't like the closeform and it's not in the objects browser. Correct code... DoCmd.Close acForm, Me.Name, acSaveNo ?

.CloseForm what is the Me.name for ?

ok getting compile error, was i ment to replace part of that code with a form name?

I need to import 1600 people from excel. as the program that we use to use was free and setup for what we needed. That has the ability to create a excel sheets with the 1600 people on. Now all the fields are different, and i'm not sure how to do it. When importing do you get the option to put...

it's ok the code i was using is crap, i've replaced it with sommat really short :D