Search results

printing Before firing off the code to print did you try saving that record? DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

reports Did you try creating a combobox on a form that contains all the courses you mention? You use that value as the criteria in the query containing the fields of interest that you have in your report. In other words, all the people signed up for that course will show up in the report...

tables Similar situations like yours have been noted in this forum where queries,for instance, just don't show up at all when using the wizard. Atleast twice now both cases were due to the antivirus program the machines were running. Try disabling your antivirus. One I know can cause this is...

display Insert a textbox in your report next to text43 (com) Put the following in the control source =IIf([text43]=0,"NC",IIf([text43]=0.1,"10%",IIf([text43]=0.2,""))) If all you are doing is changing how the field is visually displayed, use the above.

Ntac Another NTAC.................

characters Perhaps db corruption?

updates Each user will need that FE (forms,repoprts,queries, etc.) that you have made changes to on their machine. Since the BE (tables) is on the network any edits done to those existing tables will not be an issue.

query Are you able to post your db?

close Hope I am reading this right. docmd.close

Size Did you try the docmd.restore command in that form's (switchboard) OnActivate procedure?

posno Are you sure you don't mean 16 or 21? If you say AND this means the POSNo has to be both which doesn't make sense to me. In the criteria put 16 OR 21

references On one of those problem machines go into the program and in design view open a form (or a module) (or ALT+F11). In any On Event Procedure you have go into the vba code. Then up in your menu go to Tools>References. Look for any that are marked as missing. This forum under search has...

Line Use the On Print Event of your report then. Place a 2 pt line in your report header or footer. Set it's format to Visible=No. In the On Print Event: me.linept2.visible=false If me.group="Asian American" or me.group="Female" then me.linept2.visible=true end if ''or whatever criteria you...

checkbox If the field in your table is called IsComplete then create a query using the table. Drop all your table fields into this query. In the Criteria under IsCompleted set the Criteria to -1 for complete. Run this query and you will see only Completed Orders. Create a form using this query...

stock/inventory Take a look at the Inventory database and Sales Order Entry database that comes with Access as their example databases. This may give you some more ideas.

time Behind the On Click event of that button : me.textfieldtostoretime=Time()

Forms Create a form with no record source. Create one form using a query based on the criteria for Healthy plan. Create another form based on a query for Medicare. In both those queries use the criteria under each field for your filters. Using the Subform control in your toolbox drop your...

Checkbox Without knowing how you designate a finished workorder here is one possible solution. If you have a field in your table called completed (say using a check box) you could set your query (that your form is using) to only show orders where completed is YES. So in your query under...

groups If you have a group header/footer for your ethnic group this will do the trick. Just put the line in your footer or header (depending where you want it) for ethnic group in that report

form calculations You should always use a query to do your calculations, not a table. Base your recordsource of your form on a query. What calculations are you trying to do? Some examples would be helpful.