Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ColdDay
  • Content: Threads
  • Order by date
  1. ColdDay

    Want to bypass clipboard. Object var not set error.

    Having trouble with Object Variable or With Variable not set. Will have sheet with different months records. Need to filter, then copy filtered records to a sheet named either "Calendar2" or "PayPeriod2", depending on dates selected. I can get the filtering done, but no luck on the copying...
  2. ColdDay

    Hi-lite duplicate rows.

    I am wanting to hi-lite all rows that are duplicates based on the Number, Job and Date. In the following, rows 4,5 and 6 are dupes based on their same values. Rows 7 and 8 are dupes based on their same values. Same for 9 & 10, plus 13 & 14. Problem is that rows 7 & 8 are not being hi-lited when...
  3. ColdDay

    How to post an excel sheet here?

    Where on this site is info on how to post an excel table or sheet that stays formatted? I want to post some info, but all the columns move together and the headings don't match the columns and everything is a mess. I know how to do code, but not data from a table. Thanks.
  4. ColdDay

    Delete total rows with auto filter

    I looked thru past posts and did not find anything that matched my issue. I want to delete the rows with the word "Total" after doing a subtotal. I have done a copy and paste special for my subtotals so I can work on them. I have a few notes in the code below. Sub DeleteRowsWithWordTotal() Dim...
  5. ColdDay

    Remove custom menu code not working

    I want to add a custom menu when opening a wb and remove the menu when closing the wb. The open code works. The closing code does not. Here is what I have: 'Add a custom menu Public Sub AddTSEMenu() Dim cbr As CommandBar Dim ctlMenu As CommandBarControl 'add new menu control Set cbr =...
  6. ColdDay

    MS Small Business 2000 with XP?

    I am in need of a new laptop to run Excel. I have no desire to mess with Win 7 or 8. I have MS Small Business Office 2000 on my current laptop running Vista. Will the Small Business 2000 suite work with XP? XP Pro? I found the following on the MS site, but I really have no clue as to the...
  7. ColdDay

    VLookup problem caused by sheet issue?

    I am having trouble with VLookUp and it is driving me crazy. I have tried the two macros below with different results. I have verified the source sheet name as JobsAll. I have verified the case of the letters and have even tried JOBSALL in both code and the sheet name. One macro shows G2 and...
  8. ColdDay

    Use Find or Match to update records?

    I have two sheets. TimeSheetEntry (TSE) and CLNTINFO (CI). TSE has daily time sheet entries including leave time hours taken using the codes 186 and 189. CI has the balance of leave hours available in Col G.. I am needing to update the balance in CI from the weeks entries on TSE. The first...
  9. ColdDay

    Inserting columns with dates not working as desired

    I am wanting to insert columns and missing dates in row 1. Example: Starting in B1 and through to E1 (4 cells) I have Jan 1, Jan 2, Jan 5 and Jan 6. I want to insert columns and dates Jan 3 (D1) and Jan 4 (E1). This will put the 5th and 6th in cells F1 and G1 respectively. Column A is a list...
  10. ColdDay

    Licensing Question

    Sorry if I am in the wrong place, but I could not find a forum here for my question. We are a non-profit that is in need of a new payroll program. Since social security numbers are involved and we are under HIPPA regulations, we are looking at SQL Server 2008 Express or maybe 2012 Express with...
  11. ColdDay

    2012 Express not down loading.

    I am trying to dl 2012 express from the following site, but nothing happens. Usually when I dl something, I always get asked where I want to save the file, but with this, nothing. No box showing dl time, file size, etc. Nothing. I've looked through my programs and files in explorer, but there...
  12. ColdDay

    SQL Server 2012. 32 or 64 bit?

    I currently have SS2005 Express on my laptop. I was wanting to dl SS2012 Express with Advanced services from the MS site, but it gave me the choice of 32 or 64 bit. I have no idea which I should dl. Does it matter? Will there be any issues since I currently have 2005? Thanks for the help.
  13. ColdDay

    Wheel mouse and key movement in forms.

    I have separate form Add and Edit tab pages for entering information. Each has a text box for entering and editing info. Within each text box, the down and up arrows work to scroll through the info. The Enter key stays inside the text box and gives a new line as desired when entering info...
  14. ColdDay

    Text box on report formatting problem

    I have a report with a text box to show details/information about records that I have entered in the Add and Edit text boxes on forms. I would like to be able to enter data into my Add and Edit form pages and have it displayed in the report the same way I entered it. Such as: Something...
  15. ColdDay

    AC2007 User Permissions and Security Confusion

    I am wanting to set up some security/user permissions for an AC 2007 db, but I am a bit confused. I found some info here on Tek-Tips and Article ID: 918583 on the MS site which says: “This article describes how to use the Workgroup Administrator utility in Microsoft Office Access 2007. Note...
  16. ColdDay

    Form and parameters problem

    I am wanting to be able to enter the date ranges in a form named “CrossTabQueries” and then click a button to run a query and produce a report. “CrossTabQueries” is a tab page. When I run the query (or try to save or close it), the parameter boxes for the Begin Date and End Date pop up. I do...
  17. ColdDay

    UnDo macro command works on one page, but not the other

    I have a form in AC2010 with 4 tabbed pages: Add, Edit, Reports and Tables. On the Add page I have a button and macro for clearing the data in the text boxes before saving the info. The macro name is mcr_ClearAddForm. It uses the Undo Record command. It works as it should no matter how many...
  18. ColdDay

    Controls go darker and flash/flicker.

    I am using Access 2010. I have a tab control with four pages (forms): Add, Edit, Reports and Tables. When I add new records with the Add form or view/change records with the Edit form, the buttons grow darker around their edges, the text in both the labels and text boxes grows darker and the...
  19. ColdDay

    Programmatically change DataEntry, Addition, etc.

    I am trying to change the Data Entry, Addition, Deletion and Edit settings of a form (frm_aaa_TabbedPagesPractice) programmatically. This form has a Tab Control with the following four tab pages: Page Name Page Index Add/Main 0 Edit/Delete 1 Reports/Charts 2 Tables 3 The form...
  20. ColdDay

    Filtering problem with SQL and VBA

    I keep getting an error message stating that I have written “a subquery that can return more than one field without using the EXISTS reserved word in the main query’s FROM clause. Revise the SELECT statement of the subquery to request only one field.” But I am needing all of the fields to...

Part and Inventory Search

Back
Top