Search results

Hello, after local currency change to Euro, I changed the currency symbol in the regional settings on my PC, however now access shows the nonsense like : #.##0,00" Lt";-#.##0,00" Lt" Instead of showing currency as to follow OS currency symbol? How to resolve this automatically, I cant change...

Hi, I have a query in my database that filter data from 2 tables with relationship one to many between tables. I also have a form with text boxes for inputing data to the query. In the query I have a criteria that takes input from my form. The code in query criteria field is Between...

I have downloaded the batch_restore.py from http://www.lionhouse.plus.com/photosoftware/gimp_plugins/ I'm using Windows XP SP3 With GIMP 2.6 I don't know any python, but I understand that this script uses invalid path for windows "/home/gjd/restore" I tried to change it to c:\res\...

Please see attached db example. View forms tbl_type and tbl_type1 First is made with listbox second with subform. My problem is that I can't find out how to: How to delete selected record on subform with delete button? Why right click delete is disabled on subform? Thanks.

If I have a report or form based on 3 queries: 1st query pulls data from table or multiple tables and filter by criteria (for example date interval) 2nd query is based on 1st - it is a total query that calculates sum 3rd query is based on 2nd query - it converts numbers to words by using a...

Hi, I have a problem that on some reports and forms I have placed unbound textbox1 that has formula and does some calculations. The textbox pulls information from a query and makes it available on report or form. The problem I have is with second unbound textbox2 that takes result from...

Hi, I need to check if subreport finished loading, how can do this and on what event? I now have this code to pupulate my unbound textbox on current event: Me.Text51 = ConvertDocumentsToEnglish([rpt_mysubreport].[Report].[my_subreport_control]) It works but I would like to make sure if it's...

Hi, I have simple totals query. I take my data from another query and use Sum to total it. I need to display 0 if nothing to total. I need to format as currency, tried to select it from property sheet does not work. I have made it work by editing SQL: SELECT CCur(Nz(Sum(my_query_...

Hi, I have a form and made my custom buttons to enter =date() into textbox1 that is used in query criteria and would like to auto click it when form opens. My button name is: frm_laikotarpis_current I have to put this on form open even: DoCmd.RunCommand frm_laikotarpis_current_Click() but it...

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.

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...

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...

Hi, I have a database where I need to 1. group items by group and date, 2. then calculate total. I do this using 2 queries. Since I need to create 50 groups or so that means 100 queries. :eek: I would be pleased if somebody showed me away to cut it in half or other method to do this. How...

Hi, please see my attached database. rename to rar I have table tbl_items where I enter items and another table tbl_poppular for popular entries I would like to be able to click a button see tbl_items form and copy the selected value from list box to text field. Also I would like to make...

I have a report that is made from data in 2 tables. My date format is Y-M-D One table has income data the other expenses. I made queries from these two tables with sums of each transaction. I have union query: Select Data From kio_group UNION Select Data From kpo_group; Then I made a...

Hi, I'm trying to make a running sum on a report that knows about previous rows. For example if I have a long list a few months of data, if I filter to show only the current month it needs to start from first record to the current month, not from zero. I tried Running Sum property of a...

Hi, I have created some lookups and for one access made syntax like this SELECT [tbl_bpo].[ID], [tbl_bpo].[Banko pajamu orderis Nr:] FROM tbl_bpo ORDER BY [ID] DESC; For another SELECT tbl_kpo.ID, tbl_kpo.[Kasos pajamu orderis Nr:], tbl_kpo.[ID] FROM tbl_kpo ORDER BY tbl_kpo.[ID] DESC; Both...

Hi, I need to store some infomration on my reports like version number, etc. This need to be changed at once on many reports. I was thinking to store it in a table, but how do call it?

lookup question ("lookup column" or "type in the values that I want") I know lookup is bad in access but I need to choose from 2 scenario: 1.I want the lookup column to look up the values in a table or query 2.I will type in the values that I want. I need to store some text that is rarely...