Search results

I fixed it by: Open report in design mode Click design tab Click Group & sort Select Group on “the field to group by” (in my case Date) Then the multiple headers disappeared. hope this helps somebody :)

Hi, I have my main report and a sub-report. Column headings in subreport don't show so I added a Group Header in the subreport for the labels with the RepeatSection property of the group header to Yes. Problem - I see group header repeated after every record.

Does not work, because your separator is "," and I need it to be ";" I changed to =Format(DateSerial(Year(Now());Month(Now());1);"YYYY.M.D") and it seems to work but as I said it's a problem of regional settings not access besides nobody suggested that it could be regional settings as I posted...

I want to add 2 buttons to my form 1st to update formulas that previous month dates would be displayed 2nd to revert back to current month Also on the fly date change would be nice. Now I can't enter my own date range. Another question I have is how to make unbound textbox dhow data from sum...

I wanted to say it does not have forms because I have not created them yet. Thanks for your reply

Sorry, I did not reply to your message. Your original sollution on post 6 did not work and as I understand it's a problem of regional settings not access. For some reason nobody suggested that it could be regional settings so I was stumped at it for 2 days. Sorry if my actions were rude or...

Does anobody know why access added aditional ")" anyway?

Well I made a test and opened my original database I attached to the thread above on anothe machine with regional settigns set to English (UK) The form works but formulas were changed by access to: =DateSerial(Year(Now()),Month(Now()),1) =DateSerial(Year(Now()),Month(Now())+1,0) Don't know...

on my form frm_laikotarpis I write: remove "" from formulas as I could not save otherwise. Did you miss it? I mean I said I got syntax error its obvious I can't save the form with formula in it. What good is form with empty textboxes? So I saved formulas with quotes thinking it's formatting...

sure I can, here it is:

Tried to place formulas without Now, and got different error: expression entered contains wrong number of arguments. I paste them in design view inside unbound text box. I wan't them to work (diplay date) when I open my form. My decimal separator is "," and date format is Y.M.D perhaps this...

Hi, I have a form with 2 unbound textboxes. I'm going to use them to provide query between criteria for my queries. I need to calculate the first and last day of the month: 1st textbox First day of month =DateSerial(Year(Now), Month(Now), 1) 2nd textbox Last day of month...

Thanks it worked

Hi, I was wondering when you have built access database with tables and queries that are cascading, but do not have any forms. Is renaming them and adding a prefix two different things. Furthermore I heard that access 2007 is better at this. Does this apply if I work with *.mdb file but still...

Hi, please see attached db with my problem. I have a parameter table with field "param1" Then products table with yes/no field. I made query from above tables and would like to be able to enter data. When the parameter table is included in the query calculations work fine. If parameter table...

Thanks for your prompt reply. If you say that the VBA works by: 1. Save record to table 2. copy record number times in textbox Then I think there was a slight misunderstanding. You misunderstood me how I need it to work, and I did not understand why it gives me 1 record too much. I wanted...

Hi, thanks for your reply. It's working but if I enter 5 records it gives me 6. It always gives one record too much. I changed the code here to make it subtract 1 from entered value and add 1 on msg box. This is my try at coding so I thought I ask if I have made any mistakes etc. 'If the Cnt...

Thanks, I am looking for another approach that does not need to changing SQL code if new field is added or removed from table that stores multiple records. I don't know how to do this. I trie to use http://support.microsoft.com/kb/88670 It works but need to keep pushing the button x times you...

If you enter start date 01/10/2008 and end date 31/10/2008 it shows a report of codes for that period but does not show codes that did not have any transactions during that time. I need to show all codes. Also you use auto population. The codes are in detail section of the report. As far as I...

I want total for each code. Since I group for say a month. If I have 10 codes in my table I must have total for each code. 1. I group by date that is stored in tbl_grcode. (this works trough a lookup, I assign entries from tbl_grcode - think of it as cash receipts etc. to items in...