Recent content by smile

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