Search results

Thanks for the great help!! That worked like a charm!! Really appreciate it!

I have a form in which the boxes on the top part of the form accept the criteria which go into making up an SQL statement which then helps build up a query using querydef. The fields in the bottom part of the form are bound to the query created above using querydef. When I change the query...

Hi, I got it!! in the SQL statement I had to put in """" & name_of_car & """" (where name_of_car is YYA5(204) from the Combo Box. Thanks for your willingness to help. Regards, Access is really cryptic!! but logical!!

The value in the combo box appears as YYA5(204) but this is pulled from a table where the data is classified as Text.

Hi, I am trying to pull a value from a combo box on a form to be used in SQL in the WHERE part. The field of the table from where the combo box pulls list for the combo box is "Text" However, when the query is created, it gets populated into the criteria without the quotations i.e. instead of...

Compact and repair did not work..Is there any way I could do it through VBA?

Hi..I figured out how..just set the "pop up" to yes in the properties..Thanks for all those who tried to help. Rgds.

I am trying to link some tables to my front end and the tables are within an encrypted and password protected database. When I link the tables, it asks me for the passwork which I enter and the tables do get linked to the fron end.. However when I try to attach the table to a combo box or try...

Hi, I am coming back to Access after a while and have forgotten how to get the form to a certain size..The form enlarges to full size in form view..I use Access 2010 :(

Hi, Thanks for the response..it does work..the problem is that some of our folks have the new version of Excel and I have the old..they "thought" that date was a problem but it obviously isnt since I tested it on their computer after your reply. Thank you. Regards, Ashik

Is there a change in the "Year" or any other date function in Excel 2010 compared to the previous versions of Excel. In the previous version Year(some date) returned the year of "some date".

Thanks! That was extrememly helpful!!

Hello, I am getting back to Access VBA programming after almost 4 years and just cant remember how do do some simple things. I want to get the value of a Text Box in a form called "frm_form_welcome" and the Text Box is called "Text11". I have set it to a date format and am trying things like...

I am trying to get the color index number of an edge of a cell. So for example, for the cell B2 the code is color_index = Range("B2").Borders(XlEdgeTop).ColorIndex msgbox(color_index) This returns -4142. But if I change the range to say A1 (which is a cell without a border), it still returns...

I am trying to create modify an application in which if the users selects "disable Macros" the application should close. I am not sure how to go about it. Would appreciate guidance. Thanks Ashik

Thank you Gudson and HaHoBe By the way, HaHoBe I am also a fan of Jetro Tull!!

Hello, I am trying to protect a worksheet from being modified. If it is opened by certain users (I am getting the systems username) it should allow editing. For others using the workbook, it should protect the workbook from any modifications. I am using the following VBA code but it does...

Hi Sudhir, I could have given you the code, but the problem is that when I wrote the code it was in Access 2000 and in my new department they have Access 97 which wont allow me to open anything of Access 2000. But what you can do (if you dont want to use VBA), is use Record Level Locking. So...

Hi I basically did it using a record set clone object in VBA. As soon as someone went to a record (after pressing a button) I asked the program to keep moving to the next record till there was no update in what I named as a dummy field of each record. As soon as smeone stopped at a record, the...

Hi I basically did it using a record set clone object in VBA. As soon as someone went to a record (after pressing a button) I asked the program to keep moving to the next record till there was no update in what I named as a dummy field of each record. As soon as smeone stopped at a record, the...