Search results

Just found this http://allenbrowne.com/ser-44.html Is there macro or something to reset this database wide?

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

I found a code that allows me to populates text box on my form with comma separated values from the listbox But for some reason when I pass the criteria on my query using the text box it only works for since selections I also found various posts about how to build the queries using SQL ir...

But this is the same issue I'm having. I need to filter a query that makes data for my report by using listbox extended (multiselect), and you posted about custom code I need. I read the articles, and I understand some of the code, but I need directions to help adapting it to my database...

Hello, I have multiple queries filter by date as criteria and then I open a report from those queries by using a button on my form. Button code is like this: I have inserted a listbox to my form: "I want the listbox to look up values in table or query" I then selected my table that contains...

I don't know what to search for, can you give me any keywords?

I have no idea how to write VBA, most of stuff I know I have learned from this forum by example. I can provide a database sample if you could take a look at it. Sorry if my English is bad.

Thank you, I'm so grateful. You saved my day :) I see this works for text box and comb box too. If I would like to use a list box (I think it passes as many variables as I select right?) to filter say 2 different criteria than I need VBA?

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

anyone ???

Hmm, I now see that becaue this code Dim rs As Recordset Set rs = CurrentDb.OpenRecordSet("Select * from [tbl_type]") rs.FindFirst "[ID] =" & Me!List3 rs.Delete Me.List3.Requery works with recordset the normal undo button does not work. How can make a pop-up to instruct the user that...

See my attached image So how do make it work? Is my solution on post 5 correct?

I know about correct naming, sorry was in a hurry just made a sample db using the wizard ant it named my form as tbl because it was created from table. Just trying to understand the correct way to delete selected items using a button. I need to be able to delete from listbox and subform as...

I have tried this code and it seems to work: Dim rs As Recordset Set rs = CurrentDb.OpenRecordSet("Select * from [tblEmployees]") rs.FindFirst "[EmployeesID] =" & Me!List0 rs.Delete Me.List0.Requery But works for listbox only Replace List0 with your listbox name Replace tblEmployees with your...

I have same problem posted here: http://www.access-programmers.co.uk/forums/showthread.php?t=163572 Have tried your solution and got this error: Syntax error (missing operator) in query expression 'Autput Type="4"'.

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.

I would partially agree with you, but as I said I'm no access expert and don't pretend to be one. I just looking for help if possible to use 1 query and no 3 for every report I make. If that makes me ask stupid looking questions I don’t care as long as I learn something. Unfortunately as you...

So based on everyone replies how unbound text boxes work and process data or should I say lack of replies I have made a decision that it’s better to have more queries since: Access creates a derived table (record set) from the first query, the 2nd query uses the derived table to create another...

BTW the delay can be seen if report opens in "report view" mode if I open it in "print preview" it seems to not have delay. Both open is same amount of time so anybody know?