Search results

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

Hello All, I was working on changing form design, instead of using option buttons, i have to use check boxes as per user requirement. What happens is that user select a value from option button and it is stored in table. In case if I use check box and user select multiple values how those will...

Hi guys, I am working on two combo boxes, If we select values from combo1 it should show value in combo2. Here is the twist... Lets say combo1 has value A and B, if we select A from combo1 it should return value from table1 and show in combo2. If we select B, it should show value from table2...

Hi Guys, Last week i posted my following problem, I got some other very good ideas and I implemented in my application, but my problem is still there(I thought it was resolved by splitting). If anyone can help me with that. I would appreciate it. I am facing a big problem here. 5 users are using...

Hi bob, Thanks for your reply. I think this is what you meant to say, what i did. I created a link table of backend table in the front end application. and It works great! Thanks for your FE/BE updater tool and I appreciate your help in this community.

Hi Guys, I used Bob's front end updating tool for updating. I did step by step, but I is showing this error "Error 3078, can't find <table in back end of application to see version>", But the table is there and it is spelled correctly. Any Idea Guys. Below is the link where I got the code...