Search results

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

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.

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

Hi Guys, i am facing a big problem here. 5 users are using the database through access forms. When any one of them try to update a previously created record and click on save button it shows some msg window asking about save record or save to clipboard. click on save to clipboard, it doesn't...

Hi Experts, Hope any of guys can help me here. I got the above error while opening my application, and .idb of the file is even there. I am sure nobody is using this app. What could be the cause and any solution. Any help will be appreciated. Thanks!

Hi Guys, I was wondering, is it possible to see list of users using database application through any application(that can be create in access itself) or thirdparty software. Thanks!

Hi Guys, the case is i have two option groups in my application, when i add new record and click on the radio buttons, it works fine but when i add new record, its focus remains on the values clicked previously, Is there a way when I click on new button both of those focus go to the first option...

Hi Experts! I have two combo boxes on my form, where in one it should be the company's name and in another one it should show the names of all the contact person's name in that company, like company name is one and contact name in that company could be 5. I is retrieving the value from one...

Hi Experts, I created my own security code on database, that without entering right username or password, no body can enter. But entered person can close the form window and can access tables. I hide the tables by changing its name with prefix "Usys". and disabled the menu. But what if...

Hi Experts, I have two queries here, if you could help me to solve 1) When the record is checked from the combo box, it should enter the number it is checked in a table. if it is checked again the number should add up. 2) Update the value from pending to processed on button click where...

Hi guys! in addition to my previously solved problem, some experts helped me with the countdown timer of 20 mins on click of the button. It is working good, but when i try to click on another button it should stop but it doesn't. Please help me to solve it. I would appreciate any help. Thanks!

Hi Guys, Here is the issue, My manager asked me to use TAPI in access forms, where, any phone comes in its number should appear in a text box. I have no idea how to use this, cause till yesterday i did hear anything called "TAPI". My company is using AVAYA phone system, is there anybody who...

Hi Experts! I am designing the form where i need to put a timer on each call, It should be like, when I click button the time should start for 20 mins, it should show in this format "mm:ss" and need to change the color of the time when it reaches 15 mins. If it could be like countdown, that...

Hi all, I have a query that is retrieving values from a table, the result of the query is State RepCode Count AB AA 3 AB AA 4 BC BB 2 BC BB 1 *Count is showing the number of sales by each sales...