Search results for query: *

I have a row of checkboxes to show work stages completed. If I check box stage4 - I want stage1, stage2 and stage3 to be checked. Below is how I was trying to get Stage3 to check itself. It is on the AfterUpdate. It does not work. Please show me how. Thanks; Steve Private Sub...

I am trying to count the records in the detail section withing a group. Where the quantity of records is >1 I want to suppress that group & detail. Group Name: Person Record: Address 1 Record: Address 2 Count of the detail for this person would be 2 and so would be suppressed in the report...

I am trying to use a Case statement however the red part as below is being ignored. Can anyone point out my error. Thanks; Steve Select Case (myActivityCode) Case 201900 CostCodeN = "201900" Case 201901 CostCodeN = "201901" Select Case Left(myActivityCode, 3) Case "950"...

I am trying to open a form in datasheet format from a button. Even thoug the form itself is set to datasheet view it opens as a single form. I suspect I need to add something between the commas on the Do.Cmd statement, but what? Dim stDocName As String Dim stLinkCriteria As String...

I have a start and end date field on a switchboard, this allows the user to select a date range to filter a report. I am using an unbound text box to hold the start and end dates, however this requires the user to reenter the date every time the form is reopened. How can I store those values - I...

I have some data as shown below. It is storted by the qryLinks_link field (name and date) then by counter. I need to change the job number when it is 201901. For each qryLink_link when the first jobnumber is 201901 it needs to be replaced with the jobnumber in the next record. If there is only...

I am trying to filter by date and not getting the right answer I think the problem is that the field I am filtering is a date time field. 1/16/2006 6:30:00 AM I am asking for data greater than 1/16/06 but it is including 1/16/06 I am assuming because my filter is 1/16/06 (at 0:00:00) so that...

I received a spreadsheet which has about 700 rows. When I turn on the autofilter on the top row it does not give me the list of values; actually it just gives me the first value in the row beneath the header row where the autofilter is set. There are no blank rows. Why does this filter not...

The results of a cross tab query are shown below. I need to filter these results in a report and am trying the code beneath. I only want to see the rows where an employee's time is greater than 8 hours on any day AND when it is charged to code 3101. In the example below it should return 2 rows...

I am trying to use a Select Case statement instead of an IIF statement in a query. I think my attempt is self explainatory below but it is causing me problems and I suspect my syntax is wrong. I started off making it a public function but that did not work either: In a select query I want to be...

I have a fairly new AMD setup (64 3700+); 1Gm RAM and a 6600GT AGP graphics with Windows XP. I have a problem with viewing video on this computer; whether it is an AVI from my digital camera (looks fine on my laptop) or viewing a video clip on CNN. YouTube video seems to work fine. Where do I...

Having trouble with this simple combo report filter - not use a date for the filter before...what do i have wrong? Private Sub Command2_Click() Dim stDocName As String Dim stCriteria As Date stCriteria = "[Work Date]=" & "#" & Me![Combo0] & "#" stDocName =...

Data in my table includes the folliwing information - the sales by week are cummulative ( I cant change the way that that happens) Type, week1, week2, week3, week4 cars, 1, 3, 5, bikes, 1, 2, trikes, 0, 1, 2, 5, I need to be able to get the data for any week as examples below. Sales at...

I have some data as shown in the following example: Fiat 4 Ford 2 Porche 1 I need to make: Fiat 1 Fiat 1 Fiat 1 Fiat 1 Ford 1 Ford 1 Porche 1 How can I achieve this, I am importing data from a spreadsheet; appending it to a data table. Thanks Ste4en

I have the following table and I need to update the IsObsolete field. Item, ReceivedDate, IsObsolete 1, 6/5/01, 1, 6/6/05, 2, 1/1/05, 2, 2/2/05, 2, 2/15/05, 2, 3/2/05, 2, 6/6/06, 3, 2/2/05, I need to evaluate every item and make the item with the latest receiced date FALSE i.e. not...

I need to replace a "~" character in an Excel spreadsheet with a "-" I have thousands of instances. I can not use search and replace? How do i do this.. I seem to remember using a search for an ASCI character but cant seem to do that either. thanks

I am trying to make a cross tab report based on data structures as below: ITEM modified Widget1 5/15/06 Widget1 6/15/06 Widget2 3/13/05 Widget2 6/14/06 Widget2 7/23/06 Widget2 8/15/06 Widget3 3/15/05 The cross tab, should list the number of mods accross the top and the date of each mod in the...

I am experiencing an error "the instruction at "0x73dd11c7" referenced memory at "0x000000004". The memory could not be "read". Click on OK to terminate. This occurs when I try and add a sub report to a report. I see several mentions of this error on the web, but no solution - any ides...

I have 4 steps of cascading comboboxes, each selection filters the data in the next combo box and applies the filter to the line items in the sub form. Everything works fine except when I make the 4th selection the data in the sub form does not requery. The vba is below; please take a look at...

I am trying to link three computers. We are all logging in locally. I have them all connected to a Linksys network hub. Mine is the "server" and has a shared folder \shareme I configured the local network connection on my computer with an TCP/IP address 10.199.1.100; subnet 255.255.255.0...