Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. Thread: delete record

    by deb
    Replies
    1
    Views
    1,045

    delete record

    Acess 365

    I have a form called vendor (shows a list of Vendors), with a subform called VendorVariable (to add a Vendor that is in the t_Vendor table to the t_VendorVariable table. I then want the...
  2. Replies
    3
    Views
    1,234

    Re: How to handle duplicate vendors

    Thank you both, for your input.
  3. Replies
    3
    Views
    1,234

    How to handle duplicate vendors

    Need your advice on the best way to handle vendors that are the same just called differently in the data I receive. One data source may call the vendor something different than another data source. ...
  4. Replies
    4
    Views
    1,153

    Re: New table by grouping fields

    Thank you, I will try this. It looks great
  5. Replies
    3
    Views
    1,437

    Re: dynamic report header

    Thank you this works great
  6. Replies
    4
    Views
    1,153

    New table by grouping fields

    Access 365
    Need a table that looks like this....
    Table has several questions, answers and comments in each record.
    RecordID123, Question1, Answer1, Comment1, Question2, Answer2, Comment2 and so...
  7. Replies
    3
    Views
    1,437

    dynamic report header

    Access 365

    I have a QBF with a combobox "CboGrouping" that tells the report the tow grouping the user wants. (code from Allen Brown)
    Now I need to add the correct fields in the Header area......
  8. Replies
    1
    Views
    713

    Re: object required error

    I found my error. setfocus was set to a field that was previously deleted.
  9. Replies
    1
    Views
    713

    object required error

    office 365 ms access

    Form f_Site and subform f_site_variation.

    Form uses list box to find records of a specific alphabet. Also allows the new Site record.
    Sub Form adds a variation of the...
  10. Replies
    11
    Views
    1,158

    disable check box based on other checkbox

    Access 365
    Within my main form f_pac,
    I have 3 check boxes (USA, Canada, Combined)

    I need to have them enabled/disabled.

    If either USA or Canada is checked then disable Combined.
    and
    if...
  11. Thread: validation

    by deb
    Replies
    7
    Views
    1,093

    Re: validation

    Thank but not sure how to edit the suggested code to make it work foe me.
    If a,b or c has number then d must be blank or if d has number then a,b,c must be blank.

    Please help edit your suggestion...
  12. Replies
    20
    Views
    1,232

    Re: only allow one list box to have a selection

    Thank you this works great
  13. Thread: validation

    by deb
    Replies
    7
    Views
    1,093

    validation

    I have a form "f_pac" that allows user to enter a new record.
    There are 4 textboxes, A,B,C,D. They are all number fields

    If there is any number in A or B or C then D must remain blank.
    If there...
  14. Replies
    20
    Views
    1,232

    Re: only allow one list box to have a selection

    Tried but this did nothing.
    no errors and did not prevent selection of the other listbox
  15. Replies
    20
    Views
    1,232

    Re: only allow one list box to have a selection

    I am getting error 7777
    You've used the ListIndex property incorrectly

    any suggestions?
  16. Replies
    20
    Views
    1,232

    only allow one list box to have a selection

    I have two listboxes, lboFY and lboCY.

    If the use makes a single select or multiselect on lboFY, I want to clear all selections that may have been selected in lboCY
    and the other way around
    If...
  17. Replies
    1
    Views
    442

    filter subform using cbo box

    Access 2016

    I have a form f_WorkingHours with a subform f_WorkingHoursSub.

    The subform has a combobox called cboDate in the form header.

    I want to filter the [Report Date] in the subform...
  18. Thread: total field

    by deb
    Replies
    5
    Views
    686

    Re: total field

    You are so right. it is easier when the data is seen. Thank you for taking time to show me.
  19. Thread: total field

    by deb
    Replies
    5
    Views
    686

    Re: total field

    Thank you for trying but If I add all three, it would over estimate the workers.

    The data I enter comes in two ways;
    I have Workers and contractors or I have the total (not broken down)
    I need...
  20. Thread: total field

    by deb
    Replies
    5
    Views
    686

    total field

    Access 2013
    I have a form (F_WorkingHoursSub) with 3 fields (Workers, Contractors and Total)

    Sometimes I have the hours for Workers and Contractors, and other times I only have the Total hours.
    ...
  21. Replies
    3
    Views
    209

    Delete columns macro

    How can I create a macro to delete many columns.

    I need the below columns deleted. I tried but failed....

    ...
  22. Replies
    3
    Views
    134

    Re: date and time conversion

    Thank you, this works great
  23. Replies
    3
    Views
    134

    date and time conversion

    Excel 365

    I have dates and time (text format) European style that I need to setup like American formatting as a date.

    23.05.2012 14:11:56 changed to 05/23/2012 14:11:56
    24.08.2011 17:24:39 ...
  24. Replies
    6
    Views
    530

    Re: nove to next line in VBA code

    when I run the code I get runtime error 1004
    Application defined or object defined error
    Sub sbVBS_To_Delete_Specific_Multiple_Columns()
    ...
  25. Replies
    6
    Views
    530

    Re: nove to next line in VBA code

    This is perfect. Thank you.

    FYI it is mostly every other. then moves to every third then every other again.
    nothing is ever simple!!
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4