Search results for query: *

Hi, I am having a little trouble creating a qry or report with more than one header, but i'm not sure if it is possible. I have a query with the following fields: Location Position PStatus ("open" or "filled" entered) What i am trying to do is count the number of open and filled records by...

Thanks All, I spent all day trying to figure out how to use SumIf with non-blank cells.

The Msgbox returned: (BaghdadMaint.DateIn Between #1/1/2004# AND #1/1/2004 23:59:59#). But when I use the Doc.OpenReport...BuildWhere(Me," AND ") I still get the rt error 3075, missing operator. Thanks! Tim in Iraq

How minor! Thank you very much! Now I get a rt error 3075 missing operator in query expression. I tried: DoCmd.OpenReport....BuildWhere(Me, " AND "). No luck. Not sure what I have wrong. I will be in a couple of hours as it is 2100 over here. Thanks again for you help! Tim in Iraq

Recopied the edited code from the FAQ and got rt error 2465 "MS Acces can't find the field 'StartDate_EndR' referred to in expression."

Thanks FancyPrairie! I started out with one list box and the date range. When the report opens, the list box filters perfect except the date range. I checked that the range boxes had _BeginR and _EndR and the BeginR box has the following tag: Where=BaghdadMaint.DateIn,Date; Any suggestions...

Hi, I have been stuck on this for a few days and can not seem to get any where. I have a Criteria Selection form with 4 list boxes and date range text boxes that are used to open up a report. It works great when using only one list box and the date range, but not more than one. I followed...

Great...I'll try that. I was going to try also: Application.CopyObjectsWithCells = False I appreciate your help! Tim in Iraq

Well the unprotected cells are for data entry, so I am trying to prevent someone from copying any cells over those unprotected data entry cells. Thanks for replying! Tim in Iraq

One way is, go to Format tab and select Styles and Formatting. The Styles and Formatting window will show on the right side, under "Pick formatting to apply" select something for example HTML Variable. That will remove the hyperlinks, then scroll down and select Normal. That should work. Tim

I have a protected workbook that i sent out to other personnel and all they have to do is data entry. How can i prevent someone from copying cells and pasting them over other cells on the same worksheet or workbook? Thanks Tim in Iraq

I've ran into that problem before and i ended up re-installing PP and haven't had a problem after. You might want to try that!

THANK YOU SO MUCH!!! That really helped...exactly what i was looking for! Thanks again!

Hey Ken...Well i tried the VLookup that you had and it partly worked but i could not get it to list all the items i wanted in the second column. It would only show the value from the second column on that same row. Is the expression you suggested supposed to be in the cell or as a validation...

Hello all, I'm not sure if this is possible either in code or formatting, but I need A1 to be a drop list, then A2 to be a drop list but A2 will list items dependant on what is selected is A1. ie. If "DS" is selected from the drop down in A1, then A2 will list DS1,DS2,DS3. If "BS" is...

I finally got it! I found the WIF information i wrote down, but i lacked the users PID's etc. Thanks Again for your help!

Thanks so much! That was it, just needed some data in there. I have another huge problem and very dumb of me. I allowed other people to access the file on my computer, well the Secured work group information file was deleted and now i am completely locked out. Any ideas. Thanks

Thanks for the reply! The rectangle is the same colour as the background, as if the sub form is not there. The subforms will be used to input data. Thanks again for your help! Tim

Hi All, I am currently assigning read only permissions to users in the database and when the users login the subforms are not shown. I set the applicable tables to Read and the subforms to Open/Run. When i change the permissions to Insert or Update the subforms start showing again. Any help...