Search results

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

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 :(

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

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

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

I have a general question about Access Projects which I plan on learning soon: I will be using SQL Servers for the databases. Are Access Projects very different from ordinary Access and VBA (.mdb)? I have a good grasp of Access Databases using Access as the back end. How much would this help...

I would like to know if there is a way in VBA to interchange two rows (and its contents). Is there some ready function that can be used or would you have to do it by coppying, inserting new row, pasting contents to new row, and deleting the old row which was copied to the new row. Thanking you...

This is a general question. If I have two tables say A and B with a one to many relationship and if there is no linked record in table B for a record in table A, if you run the query, that particular record does not show up at all. Is there any way that this record can be shown in the query...

I have been working on quite a few multi user Access projects in the past few months with a backend and a front end which has linked tables. I would like to know if there is any way to find out the source of a table linked to the front end and where would its location be on the network.

I have a report based on a query and the report has a field called EXT_NUM in the details section of the report, for the different telephone extension number information. When the report is opened, is there any way that I could could click on a certain telephone number on the report and have...

A simple solution to this seems to be eluding me. I have time fields in a table. I want to create another column which rounds of the time to the previous half hour. For example if it is 7:25 AM then that should map on to 7:00 AM On the other hand if it is 7:45 AM then it should map on to...

I have an Options Group on a form with two option radio buttons. When an option radio button is filled, it updates the field with the option value instead of the text. Is there an way I can update the tabl with the Text instead the option value?

Is there any way of sending an escape key (Esc) on the close event of a form using VBA? I have a problem that when the form closes if somebody accidentally closes Access, that the entries on the form get saved when they are not supposed to be saved. I have actually done this through macros by...

Could anyone tell m what is wrong with this VBA code snippet: Dim rec as DAO.recordset set db = CurrentDB strSQL = "some SQL" set rec =db.openrecordset(strSQL,dbOpendynaset) rec.Bookmark = Me.Bookmark (where "Me" is a form) I know it all works with the recordsetclone object. The...

I would lik to know how to use find for ADO. I am using the following and it does not seem to be working. rec.find "user_id = """ & theuser &"""" I have seen from some previous posts that it shld be rec.find "user_id = "'" & theuser & "'"" (using ' instead of ") but ' is interpreted to be a...

I have a general quetion about ntwork traffic with reference to ACCESS. If I have a BE/FE split setup with linked Access tables and if an FE opens a recordset ( as in DAO.Recordset or ADODB.Recordset), what is the process that ACCESS follows: Does it first send the whole table over the network...