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...
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
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...
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
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.