Search results

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

That was very helpful. Thank you very much.

Hi For example if I have contents in row 1 and some other contents in row 2, the procedure should exchange the contents so row 1 will now have contents of row 2 and row 2 will have contents of row 1. Thanks Ashik

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

Thanks! That helped greatly!!

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

Thank you very much for your response. I also discovered another way to find that. You can use the "document ananlyzer" or even the linked table manager to view the path and backend file. Regards, Ashik

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

Thanks for the reply. it is a bound control and so I have now used a combox instead. It is always better to use a simpler "as efficient" solution at times and in this case the combobox was a better solution as per my thinking.

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?

I took Ghudson's code to disable the x buton on the Access window. LET THEM CLOSE EVERYTHING THE PROPER WAY!! :D Thanks again Ghudson and Scottn!

Thank for the input Scottn and Ghudson. I was just exprimenting a little more. Just to calrify matters a bit more, the bound controls of the form are from two linked tables with a one to many relationship. The usr selects an IPO_name using a combo box (linked to table1) which displays some of...

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

I appreciate you response. So what you are saying then is that when a form has bound controls and the table that feeds the data to the form is on a back end on a network you cannot avoid huge amounts of data transfer across the network. Would that be correct? Thank you.

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

From what I have been noticing, I think ADO is the highly preferred one. The development of ADO.Net does confirm that. The company where I work, is also moving things to the intranet so that the front end does not have to be distributed to the employees everytime. By using ASP.Net employees...

Well from the info I have, if you migrate your system to an SQL sever using the upsizing wizard, all code shld be ADO. From the way I see things SQL is where things may be going where I work. I also know that Microsoft now has two minds about ADO but I want to be prepared.

No Mile, this also does not work rs.find "[user_id] = """ & the user & """" When I use the above I get error 3021 (EOF or BOF reached) This means that the syntax is correct but the string is not translating to something which specifies that the item to find is XYZ. If the syntax was not...