Search results

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

Thanks, works like a charm. I need to hide that column associated with the combo box, if I do cmb123.ColumnHidden = True It does not do the selection anymore. Is there a way to hide the column and still be able to select?

My project includes a split form linked to a table, I added a combo box which is linked to one of the fields in the table which is a UPC code. I want to be able to select a UPC code and use the AfterUpdate event of th ecombo box to make the record with that UPC the current code and scroll the...

I tryed to create an installtion package for my app. using the publish option of the menu and Access froze, I terminated the process and since than the Publish option is grayed. I used the Publish option on my machine successfuly many times, how do I bring it back to life?

I am getting the values for the value list of the combo box from a table and the value that I tried to assign as default was not in the table, once i fixed that all works well. As to the comment that it might not work on other versions of access, I create a distribution package for my app which...

My application includes a split for which is bound to a query. the code below is supposed to assign a value to a combo box but it does not work correctly (the value is not displayed), the value which I show in my code sample is on the value list. Combo box is supposed to update when a record is...