Search:

Type: Posts; User: gheyman; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.09 seconds.

  1. Replies
    1
    Views
    143

    Access: Upload Data From Excel

    I know you can have a Template and upload/import the data into Access.

    My question is, can you do that from the Excel Sheet or do you have to import it from Access (have access Open and tell it to...
  2. VBA code Problem: Paste in the next available Row

    Where I am pasting to is a table. My Titles in the Table (CMOPTable) start on Row 11 in B. Note the Table size will vary depending on what's being pasted each time.

    This Pastes from the last...
  3. Replies
    5
    Views
    84

    Re: Problem with VBA code

    THANKS I really appreciate the help.
  4. Replies
    5
    Views
    84

    Problem with VBA code

    This filters and copies then errors where it should be pasting.

    Sheets("CMOPUpload").Range("B" & lstrw).Paste




    Private Sub CommandButton1_Click()

    'Dim CMOP As Worksheet
  5. Replies
    3
    Views
    101

    Re: Table: Number of Rows

    Thanks, but I didn't mean 10 specifically. I meant what ever number the user entered into cell B5 (it could be 10, 2, 18.....)
  6. Replies
    3
    Views
    101

    Table: Number of Rows

    I have a Table where the user enters data. Is there a way to add a certain number of rows to a table based on a number in a cell?

    If the User wants to add 10 Items to the Table. They would then...
  7. Replies
    4
    Views
    110

    Re: Copy Data where column F = Yes

    Thanks! I will give this a try. It looks logical. I didn't think of filtering and then copying. I was thinking I needed to Loop through each line. B11 has a Title, so it will always have data.
  8. Replies
    4
    Views
    110

    Copy Data where column F = Yes

    I have a table and in the last column (F) there will be a Yes, No or it will be blank.

    I want to loop through each row of the table (which starts on row 4) and if that row has a "Yes" in column F,...
  9. Re: Select a Row from a Table and use that data elsewhere

    Got it.

    Just added a column after the last column of the table and put a Data Validation list in (Yes, No). Then I am using Code to copy down the contents to the row, so when the table is...
  10. Select a Row from a Table and use that data elsewhere

    I have a very large table (Power Query table).

    I want the user to be able to select an item and then have that item (the data in the cell) be loaded in a cell on another tab.
    I hoped I could add...
  11. Replies
    3
    Views
    377

    Access: Key behavior in Field - Cursor

    I have a filed on form that is formatted as currency with a default of zero "0". When the user enters the field to enter an amount, the cursor appears in front of the defaulted value of 0. So...
  12. Re: Access: Load data from one form to another

    Thanks Joe. Is there a way to make sure the form "frm_VendorQuoteData" is open before the code is run?
  13. Access: Load data from one form to another

    I have code that loads data that is selected on one form to another form (Someone here helped me with - thanks!!!!!)

    The code runs great except for the last line that I tried to add. I want filed...
  14. Replies
    2
    Views
    349

    Re: Access: Saved Import

    DoCmd.RunSavedImportExport "YourSavedImportName"
  15. Replies
    2
    Views
    349

    Access: Saved Import

    I have a saved import that I want to run using VBA instead of the ribbon (because I have other actions I want to happen while with the import (First I am deleting the records in the table where I am...
  16. Replies
    1
    Views
    354

    Access: Delete all records in a Table

    I have a situation where I want to delete all records in a table - I don't want to delete the table - just the records.

    Is there a way to do this in VBA (click button event)

    My table name is...
  17. Access: Autopopulate a field on one from using another Form.

    Default Access:

    This is Repost with different title - since my original did not meet posting requirements (in error). Sorry started writing the issue and forgot to get back to the title to...
  18. Replies
    6
    Views
    630

    Re: Combo Box List Rows limit

    If I create a subform using a query, can I put a Checkbox in one of the Query fields? And then based on if that check box is checked, store that data onto another form?
  19. Replies
    6
    Views
    630

    Combo Box List Rows limit

    I have a Combo Box that has 6 columns

    The source of the data for the list is huge. There is over 30k rows

    SELECT [ModelGeneral_vluItem].[TotalLeadtimeDays], [ModelGeneral_vluItem].[ItemID],...
  20. Replies
    4
    Views
    473

    Re: Access: TExt Box = Combo Box

    Thanks. Ill try it with the "me" in front of both!
  21. Replies
    4
    Views
    473

    Re: Access: TExt Box = Combo Box

    just trying different things to see what I can get to work.
  22. Replies
    4
    Views
    473

    Access: TExt Box = Combo Box

    I have a Combo Box (unbound) that when its changed, I want another field (a bound text box) to equal what was selected in the Combo box.

    I tried versions of these, but its not working (two...
  23. Re: Access; Error Message on form fro ComboBox

    can you elaborate? what is this doing by adding The CStr? what I am looking for is the ItemID to be populated in the combo box after the selection. That's my bound column.
  24. Access; Error Message on form fro ComboBox

    Error: "The value you entered isn't valid for this field"

    The combo box, where I get this message, is a bound field to a table.

    The Field on the table is tied to an ODBC table. In the Data...
  25. Replies
    6
    Views
    827

    Re: Access: Timestamp new records

    Private Sub Form_BeforeUpdate(Cancel As Integer)
    Dim sUserName As String

    UserNameID = (Environ$("Username"))

    If Me.NewRecord = True Then
    Me![_TIME_STAMP] = Date
    ...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4