Search results for query: *

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

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

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.

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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