Search results

You should attach a copy of your database that works (or doesn't), for the part in question. Sample data is handy, if only one or two records.

Best to post on the forum. Others may view and critique the database and or my code. The work is doen on a copy. You would then replicate/copy the code onto your original database so no need for the number sequence to be an issue as your numbers will start from where ever they should.

If you could post a copy of the database, without any sensitive data on, it may be easier to do this for you. I see two seperate tasks to do. 1. Create the Public Function to get the next reference to use 2. have code on your form (event of the Yes/No check box is a lilely place) to create...

I would create a Function to get the next number. Use code to find the last number and then add 1 to same and you have your next number. Call the function in the code for the "Yes" Command Button

Consider adding a new field as your Primary Key - Auto number. Keep the field you use for your Document Reference as a Number Field but not Auto Number. Auto Number can be a real head ache when you need sequential numbers as any mistake may well mean a lost number. If not auto number, you can...

Is this a new issue ? What query are you referring to ? Why not have three queries ? If the query is the Data Source for a Form or Report, then you have a number of choices. But first explain your task as well as your problem.

I still can't help thinking a Full Requery will resolve the issue. Is it possible to attach a database with non sensitive data ? I can work on a solution in 10 hours. Maybe other advice may assist in the meantime. I wouldn't have thought you would need to use this line of code...

By Requerying the Form you are simulating Opening the form. The form control TempSumOfHours is not bound to a Table or Query but it should still recalculate. I have attached a handy syntax for subs document from P Baldy. You can Requery the form control which should be...

Sorry, the code should be DoCmd.Requery "mainformname"

If you have Main Form and Sub Forms. You change some data on a subform and want the data displayed on teh main form to reflect same - provided the changes are made to the data the forms use, then Requiry the main form and your changes should be evident. Try adding a Requiry of the main form to...

Here is a conditional sum example =Sum(IIf([APLBank]="ANZ",[Principal],0)) Only records where field APLBank = ANZ will Principal field be considered in the Sum result.

Some issues to consider... You could force a Requery - may be needed with some of the following. You can conditional sum ie just sum fields that meet certain criteria. This may allow the main form sum to appear to reflect the subfrom data but in fact it just follows the criteria. I can...

Are you using "report" when you mean "form" ? If you want a report to display all sorts of different data in different ways, sometimes it is best to use an Unbound Main Form and have your data display form as a subform. This way you can have controls on your main form (unbound) that can do a...

Do mean the difference between a Single form and Continuous form ? If so, just go to the form properties and change from Single to Continuous. Do this on a copy if you are not sure. The controls can be moved around and place the general command buttons on the form Header and Footer with any...

Maybe you need to be aware of a few basics. Forms, often, are based on Queries, not tables. Forms can have Bound and Unbound Controls. A Bound Control is mostly a Text Box Control bound to a Field on a Table or Query. It can also be a List Box or a Combo Box or Check Box but they are all...

I believe 99% of businesses would want the UnitSalePrice, SaleQty to be saved regardless if the UnitSalePrice was taken directly from another table or calculated some way. The result of SaleQty * UnitSalePrice is arguable (my vote is do not save). Most argument relates to large databases that...

Study your tables and their relationships. Research Normalisation. t_Teams should not have fields BaseName, BaseLocation and Region. This data can be queried from the relevant tables as required. Before you can add a t_Teams record you do need to first have any relevant records in t_Bases as...

Should be a simple task. If your dtabase is new, small and with non sensitive data can you post a copy and someone can check it.

I am not experienced with using Word from Access but have tried it and it is not hard. As to how you would have the Letter format per the different access user, I do not know. I do know Word is much better at producing a letter then access is. Maybe there is some version of OpenArgs that will...

:eek: I guess in a few years that may not be such an issue:confused: