Recent content by avtuvy

I have a Split form (Access 2007 with VBA) with some text boxes which are not bound and are used to enter data, some other text boxes are bound to allow display of records in the datasheet section of the form. I enter data in the unbound text boxes and used a parametrized insert query to insert...

Thanks, I was able to change the data source.

I need to change the name of the ODBC connection that my Access app is using, in other words I changed it using the control panel and I need to chnge it also in my app, how do I do that?

ret = MsgBox("You are about to modify a record, do you want to continue", vbYesNo) If ret = vbYes Then strTemp = "UPDATE dbo_MAP set CROOM_ID=" & Rooms & ",TROOM_ID=" & TRooms & " WHERE dbo_ROOM_MAP.ROOM_MAP_ID=" & Me.roomMapID DoCmd.RunSQL strTemp...

I do some updates to data displayed on a split form, data is selected on the datasheet view and updated on some text boxes which ar unbound. After I click the update button the datasheet view scrolls to the first record instead of remaining on the record previously selected. I use the code below...

I inherited a large Access project, the Query menu displays many queries and I have a feeling that many of them are not used, is there a way to identify those unused queries?

Thanks you made my day, I read in a few places about that registry change but nobody had the text of the change itself. I ran the script and it works.

This are the entries at the path that you suggested Key Name: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\Access\Menu Add-Ins\&Add-In Manager Class Name: <NO CLASS> Last Write Time: 9/2/2008 - 4:25 PM Value 0 Name: Expression Type: REG_SZ...

Thanks, please see below Key Name: HKEY_CURRENT_USER\Software\Microsoft\Office\Access\Addins\CnfViewer.sortie Class Name: <NO CLASS> Last Write Time: 3/18/2010 - 2:05 PM Value 0 Name: CommandLineSafe Type: REG_DWORD Data: 0x0 Value 1...

I am trying to avoid that, from what I read the setting which cause that problem is saved in the registery and needs to be handeled manually

I installed the developer extension and all was running fine for a while. My pc crashed while access was on and the developer extension option disappeard from the office menu, I followed the steps listed in the link below and the developer com is not in the add in menu. I browsed and selected...

This is my first project which requires creation of a report, I need to create a report which has a spreadsheed look (borders around cells). the way I am doing it now is by drawing a horizontal line for the top and bottom of rows but I am not able to create the vertical lines. is there an easy...

the ID column of the combo box has a width of 0 and is not shown, the column with the UPC code is shown in the datasheet view, if I make it not visible than I select a value on the combo box but it does not effect the datasheet view.

My combo box is not bound to a filed,

It's set to 0, my combo box has two columns, the first one is an ID column and the second one is a UPC code which is displayed correctly. The combo box is used on a split form so on the bottom I have a spreadsheet like display of all the records. When I added the combo box it added a column on...