Recent content by Ste4en

Thanks - that worked.

I am trying to subtract 12 hours from a time-date field when the payperiod does not equal 01. in a query I have: work date: iif([payperiod]="01",[StartTime],[starttime]-#12:00:00#) - Access added a PM before the second hash so it looks like this...

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

Thank You that did it.

I want to combine the two functions below into one. I want to press one button on the switchboard and If macMissing returns more than zero rows, I want to run macMissing and show the query result. If it has zero rows I want it to run macCombine. How do I modify these converted macros to do...

thanks worked fine.

I need to append some rows into a table, before I add these rows i need to delete all of the old rows. I can't use a Make Table query because I am updating a linked table in another database. So how can I (automatically) delete all rows in that table before or during the append process...

used find ~~ and it works.

I need to replace a "~" character in a 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

STILL NEED HELP - Cross Tab & Number Generation Thanks, I think you mean that the query would need to return the data as shown below. I did a search for generating numbers and don't see anything that would do this...did I understand you correctly?; any other clues thanks newquery ITEM...

I would like to display the following date in the format shown below it – in a query/form or report ... 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 ___________1 _____2______3_______4_______5 Widget1 5/15/05...

In case anyonme else is looking for a solution to the same problem I found this solution on these boards and it was what I was missing. The way I do this is to base the form on a query. I then add an UNBOUND combobox that will store the ID #. In the query I set the criteria for the ID # to...

Ken I appreciate the help - you are right that I don't really need the subform/ form arrangement. I dont seem to be able to do what I want without it though (or with it!). I want to be able to select the combo value and have the form filtered to just show the related records. So I am still...

I am running into a problem with just one form in my database. I was getting the error 'Can't build a link between unbound forms'. After searching here and elsewhere the solution is/might be to type the linked fields into the child and master proprty fields. However when I do that I still can't...

I have 4 cascading combo boxes that filter a sub form. Everything works great up to the last selection ComboGroup4. The combo list is correct but it is not requerying the data when a selection is made in ComboGroup4. The vbas is below; please take a look at the "Private Sub...