Recent content by johnyjassi

here is the what you need.... thanks for your reply

Hi Guys, Need help in this. I was trying to run update query. Table names are "Table A" and "Table B" and columns name, size, datatype is same. when I tried to populate Table B with values in Table A. when i run the query it changes the name of few fields (unknown to table.... and asking for...

Hi Paul, Thanks for replying me back. yes you are right, i did the way you just told me, in tools/options/edit/find the action queries box was not checked.....I check marked it and here you go......all set to go. now it shows msgs on any query i run. Thanks a lot for your help!

I have no idea where should i check the set warnings false option, because i don't have any forms. I have just few tables and few queries. do you have any idea where should i check the set warnings false option

Hi Paul, Thanks for your reply, yes it shows some other warning messages like if I create a query that creats a table and try to re-run it.....msg pops up that "Table will be delete......." any other suggestions?

Hi Guys, I have some queries in my database, till yesterday it was working fine but today....when I run any query(make table, update or append) its not displaying any message that how many rows are being updated like it use to ask before any query. I have to check the table whether it has...

i am trying to run the code below from one of the experts here but it is giving me a debug error highlighting the dim fso as filesystemobject. Any Help. I would appreciate your help. Private Sub Form_Load() On Error GoTo Err_Form_Load Dim CompactedDB As String Dim dbName...

Thank you guys for your help. the link Rabbie gave is very good explanation of suforms and syntax. But my problem is still there and I noticed that any function that is refering to any other control on form is asking for value input like it is not regonizing the field. I am sure that it is...

Hi ken, the name of the sub form is different than the form. It is creating a problem only when I use the source form in the subform otherwise it is working fine. Any other suggestions?

No, its not working. Any other suggestions?

Hi ken, Thanks for your reply...Its the perfect solution to my problem......But one function doesn't work properly. there is one macro that runs and choosing a value from combo box, that populate the value in text field.....but now it is not working. the path where the value is assigned is...

Hi all, Is it possible to use existing form as another tab in tab control? If yes ,can you please guide me on this? Any help will be appreciated. Thanks in advance.

No worries guys I found the way..In query in input it should be like like [Enter value]&"*" Thanks

MSAccessRookie gave you a very detailed and good example of how it works. Anyways, change =firstdayofmonth(Now()) to =now(). If you explain what exactly you want..that helps alot...and you may get some different ways to get your output.

Hi guys, I was working on this report, that need the user input...It works well..when user enters the exact word. but now I need to work the following input...that excepts the any number of letter and then * gives you the right result, Example below: exp* or exp-* should give the output...