Recent content by voskouee

Thank you so much my friend.. and this is not the first time you helped me.. i appreciate that you are sharing your knowledge..

can i replace the SOBP = with a speciffic value? where does the column closes?

I have a table with country names and currencies. I am using VBA and am opening a recordset and i want to FIND AND USE use only one speciffic record from that recordset. how do i do it? any ideas? i know i can use the find method of the recordsets... how can i use it after i find it.. how do i...

can you explain with an example what you mean? before i added that line everything works. should i change that too?

I get the error that is attached as a picture here when i run this query on vba. any ideas? Set RsType = CurrentDb.OpenRecordset("SELECT SOBP,SOBPDEBIT FROM RFGDebitNotes ;") Set RsTbl = CurrentDb.OpenRecordset("SELECT * FROM " & RsType!sobpdebit & " ;") strsqlDBl = " SELECT * FROM " &...

You can list of your table names in one table and use that field to alter all tables using one query... lets say you create a new table with a field called Tables_Names and you list all your tables there.. then you open a recordset of that table and you use the same SQL to edit all of the...

I did a lot of replacements in my project and editing of values with VBA. its very easy. are you ok with that or you need some examples from mine so you work on it? let me know and i can send you some..

Actually i did that.. i set the option on compact on close.. i just found out about it.. thanks guys!

i am using the following code that i found after searching the Forum Code: Public Function CompactData() SendKeys "%(TDC)", False End Function Code: DoCmd.Close acForm, Me.Name, acSaveNo CompactData i added it to the exit button. it does close but the size of the database is not...

thanks man.. it seems to work. i will check my multiplications to see if they are correct to the decimal.. thanks again

How do i do that? can u give a hint on the code?

but it used to work before i changed the debits and credits to currency.. which i had to do.. is there a problem multiplying currency with numbers? i think something like that might be.. anyone had the same problem?

i have the following code Sub CUR() 'Update Currency for RFG Dim strsqlCURa As String Dim strsqlCURb As String Dim rsCur As DAO.Recordset Dim rsRows As Variant Set rsCur = CurrentDb.OpenRecordset("SELECT SOBP, CUR from CURRFG;") Do While Not rsCur.EOF DoCmd.SetWarnings (False) strsqlCURa...

Very Weird Thing Is Happening! this weird thing is happenning my friend. when i import the excel using the automated import with VBA that i wrote.. even if i clear the IDs and everything i get the extra line.. the one that is colored in the Excel before. when i import the excel manually into...

thanks so much for the help.. sorry for the late answer back but am working from home and had no internet last two days.. i will give it a try i guess with the queries.. thanks again....