Search results

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

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

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

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

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

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?

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

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

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

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.

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.

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

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

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

nvm wrong forum

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

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

DoCmd.OpenForm sommat for opening forms?

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?