Search results

  1. 2ippy

    copy field to form

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

    custom yes/no textbox

    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.
  3. 2ippy

    problem with form

    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...
  4. 2ippy

    comfirm yes no popup

    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
  5. 2ippy

    Hell if I know what to do with 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...
  6. 2ippy

    importing data from excel?

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

    form issue.

    I am using VBA on a button to transfer customerID to this form and it's auto generates a ItemID. Problem is that it's making a record b4 anything is entered. Is there a way to make the record be made later rather than instantly, just in case someone opens this form?
  8. 2ippy

    Data from form to report.

    I'm trying to use a button to clear and then filter a report, with 2 variables. CustomerID and ItemID And then print, from a form i have. Private Sub Command86_Click() Dim stDocName As String Dim SupID Dim SupID2 SupID = Me![CustomerID] SupID2 = Me![ItemID] stDocName...
  9. 2ippy

    report single data and printing.

    I've done my report layout and such using the wizard and then edited it. How do i get it to show a customer of my choice and only a single item. Atm it's showing the 1st customer in DB and all the items. And then print. All this then gonna be assigned to a button at the end of a input form for...
  10. 2ippy

    date format

    I using a auto date in a table and want it to display differently in a form. How do i do it?
  11. 2ippy

    report invoice / reciepts

    anyone point me to a tutorial or samples of reports using 2 tables into 1. Trying to carry on a process in my DB where a receipt is given out after a item is dropped off and entered.
  12. 2ippy

    VDA entering data

    In a form, i have got a button to create new item. It VBA's to a new form and new record. How do i get it to auto insert the customer ID, as it'll be showing the current customer on the 1st form.
  13. 2ippy

    linking forms

    I have a button opening a create item button on a form. This open and creates new record on a input item form. This form is also on the 1st form within a subform (dataview). 1st Problem I am having is that the 2nd form for inputing items into the DB doesn't show the current customer the items...
  14. 2ippy

    restricting access.

    is there a way to pw or restrict access for ppl to a table, form / control page?
  15. 2ippy

    picture linking subform

    I'm having a problem with my sub forms and the sample linking image code. Top subform is in data view and the bottom in form. Sync'd with a textbox. notes show individual data per record as you click on them, and the picture updates the location the same. Problem I am having is that the...
  16. 2ippy

    picture linking.

    nvm wrong forum
  17. 2ippy

    getopenfile_CLT

    Private Sub cmdBrowse_Click() On Error GoTo err_cmdBrowse Me![txtPicture] = GetOpenFile_CLT("C:\", "Select the File") Me![txtPicture] = LCase(Me![txtPicture]) Me!Picture.Picture = Me!txtPicture exit_cmdBrowse: Exit Sub err_cmdBrowse: MsgBox Error$ Resume...
  18. 2ippy

    form to form VBA

    I'm working on the search sample in the sample database section on forum. I have got it looking as i want and working as i want bar 1 thing. Private Sub CustomerList_DblClick(Cancel As Integer) Dim stDocName As String Dim stLinkCriteria As String stDocName = "Customers" If...
  19. 2ippy

    open form

    DoCmd.OpenForm sommat for opening forms?
  20. 2ippy

    pages within a control

    I want to use a button to goto new record and also goto page 0 within a control so you get to the start of the fields for this data entry. No help in macro so i was wondering how would i do it in VBA?
Back
Top Bottom