Search results

mark, This is probably a moot point, but did you check to see if the "Target" and "Look in" properties of the icon are set to the correct location for the database? jim

arGHHH, i meant to change that but apparently, a cog slipped.

pp, just off the top. =iif(isnull([enddate]), datediff("d",[startdate],now()),datediff("d",[startdate],[enddate]) should give the number of days. If you want weeks then replace "d" with "ww" jim

puso, The last line.... "Between 1 And [Qty]" refers to your [quantity field]

I did this a few years ago. SHould still work. Add a table to your database that only has one number field. Populate this table "Number" to contain sequential numbers 1 to whatever the maximum number of labels you would ever print. Add this table to the query that is the record source for your...

Put an unbound txtbox on your main form and reference the subform field using the following in the "Control Source": =forms![yourmainforn]![yoursubform]!yourtxtbox

jenny, Another thought. How about using pictures or drawings or just about anything, put a command button of the same size on the picture and change the "background color" to transparent. Plus, there are several sites that allow you to create buttons of various styles. You could use them and do...

LUC, check out Jean-Marie's site. he has barcodes for all occasions and the best part is they are free. It is nice if you make contributions however. http://grandzebu.net/informatique/codbar-en/codbar.htm jim

select in the "format" section of "Design View" enter $#.00;($#.00 [Red]) that will make Positive numbers black and negative values red with () around the number. If you don't want red, remove the [Red] from above

claddagh, Create a query selecting all relevent fields. Create a form, based on the query. On your form, from the tools menu, create an "unbound" textbox and enter your formula. jim

It is best not to save calculated data in the database. If one or more of the parameters changes the results will not be computed. Besides the fact that it just inflates the table size. create a query and choose the relevent fields. in a blank "Field" place; = ( [Total Ammount Inc Vat] -...

pedigree db The PAF5.Exe is a great human geneology program that is free...

inventory I would be glad to try and help. I don’t really know if my method is the best or not but it works well. I created another table Exactly like the original. Created a new form based on the new table. When I input new items in stock I enter the name in the first field. The second field...

control source Chris, you might try creating a new report, copying the control source of the form and pasting it in the control source of the report. then position the fields as needed. jim

grouping bpd, I forgot to add an important instruction!!! Open the report in design view and click on the "sorting and grouping" icon in the task bar. Select the field you want to group on. (your "section") Set the options below "sorting" as; Group Properties group header "yes" group footer...

column break bpd, Open the report in design view and click on the "sorting and grouping" icon in the task bar. Set the options below "sorting" as; Group Properties group header "yes" group footer "yes" group on "each value" group interval "1" keep togeather "whole group" open...

timesheet Not sure about the open form, seems like a subform would be a better idea. As for the time problem. If the officers are entering the time as Hrs:Min then the controls need to be formated as hh:nn In the detail section of the form the control can be translated to seconds by...

query example For the computational entry you can leave "field:" as the name or change it to "result:" but you need to type the following, using the names of your fields where the brackets are [your field name]. type in a blank field "Field:=...

count to table? Why do you want to store the "count" in a table? It is not good practice to store calculated values in tables. All DB's are designed to store info in tables. Results of info can be computed and used in querys, thus are available to forms and reports.

values Are you familiar with querys and forms? 1. According to DB standards you do not want to store calculated values. 2. It is easy to perform calculations in querys, forms and reports For a query. Click on the "query tab", select "new", "simple query" and select the table that your info is...