Search results

If you are serious about producing Letters, consider linking the data to a Word document. Otherwise, you could have multply Reports. Use an If Then statement to open the report matched to the writer.

I guess MS developers may be like other marketers, they add Bling to sell their product even if it may not be practical for any sizable application. A Family Database would not have an issue with images saved and speed but a hardware store, saving images of the 40,000 products :(

Saving The QtySold, SalePrice, CurrencyRate and TaxRate isn't saving calculated results.

I think you are correct Vassago. The car forum I am on appears to have quite a social network but then they can share parts, help with repairs and attend Meets. For Access, you can do nearly all of that within the main forum. No need to have a Cuppa or beer at the same time.

Why do you need to save this value ? You can include DateAdd() in your query and have the result when ever you need it. Most advice is to not save Calculated Fields ie keep them in queries and Forms only. It is possible to add a record to a table or update a field on a table by using an...

Glad to assist:)

Some observations today. Maybe I have too much spare time :eek: The thread on renewable energy only has 15 voters. Is this an indication our energy supply is not a concern ? or just not a gripping subject for database people ? Is it just me or are we having an increase in new members ? there...

With a Quote and an Order situation, they can be virtually identical. ie, you quote a customer for 4 items. The customer gives you the go ahead for all 4, I see little or no difference except the fact that one is a quote and the other is an Order. Of course, a quote can be partially accepted...

Day can not be a field name - it is a reserved word. Google Hungarian Naming Convention The list of Reserved Words is "as long as a pce of string". Best way to avoid using same is to use double or triple names eg WorkDay rather then Day TeacherName, ClassRoomNumber, tblWorkers...

Looks like what ever event restricts teh records to 10 in the report does not reduce the records in the recordset which then appears to mean the =Sum() sees additional records to what the report displays. If it is allways 10 records, then maybeyou should do the filtering in the report record...

I have just tested and you can use =DateAdd() directly in a Form Control. No need for a user function and additional code. =DateAdd("d",[DateInterval],[dmDateRcd]) This is the Control Source for the form control. "d" you know. [DateInterval] is the field name in the query/table your form is...

Use your Report Grouping facility. Group on producttype and use =Sum([myfield]) in each of the group footers. 4 product types = 4 groups and respective footers.

Have a look at the sample database attached. Refer to frmTestDateAdd, modDateTest and tblDataSort

Do you understand how to make a Function ? Once this done, you can test in the immediate window, then refer to the function in your form control and all should be well. You may even be able to use =DateAdd() directly in your form control. I will try and replicate and confirm.

If your interval is day then use "d" as Interval Type. You didn't make life easy when putting spaces in field names. This may work. FirstDate = Me.[STRG Start Date] Number = me.[Storage Day Qty] What you are doing is creating a Function to return the result of DateAdd() In the function...

What benefit do you get from this ? instead of just using a normal table ?

You may have different margins/page size etc on your pdf printer ? Play with the size of controls on your report. Allow more space and see if that resolves the issue. Check Page Setup on your report.

You can use the other field reference in DateAdd() Inthe example, wouldn't you just substitute your field for Number ? Dim Number As Integer Number = Me.[StorageDatQty]

Use DateAdd() to get a date so many days, weeks, months or years from another date. This may assist http://office.microsoft.com/en-us/access-help/dateadd-function-HA001228810.aspx

If you want the five or seven "boxes" to just indicate if a person works on respective day then you would use a Check Box or Text Box. A Combo Box gives you the ability to click and select an option. This would be suitable if you wanted to change the status of a day. Check Boxes have very...