Search results for query: *

I'm retired and haven't used Access in several years, so I have forgot things. Specifically, how to format a date field on a report. I want the date Field to look like this: Tuesday July 12 So, I need to insert a cr/lf

I've been developing an Access database with SQL as the back-end. But have run into a problem with security. Although I can encrypt the SQL back-end, how do I encrypt the data as it is transmitted across the network between the Access front-end and the SQL back-end? I need to ensure that if...

I'm in the process of converting Access tables to SQL tables. However, several fields within one of the tables allow multiple values. How do I extract the value(s) of a multi-value field?

I have 2 access tables that I want to combine into 1 new table. There are no duplicate field names that I need to worry about. I know I can create a make table query that will combine the 2 together. The problem with the make table query is that it does not copy the definition of each field...

I have a main form (acts as a portal into the system), a form from which the user can edit/maintain their data, a form from which the user can select and filter reports, and a several forms that allow the user to maintain look-up tables. When I open the main form, the custom ribbon I have...

I have some code that has been working for a couple of years. However, today, one of the functions is not working correctly. Prior to exiting the function, I check the string the function is returning. It is what it is supposed to be. The variable that receives the value of the function is...

I have written a screen management system for web forms. As a result, there are a lot of things I don't know until runtime. For example, suppose the programmer wrote some code that sets the readonly attribute equal to true. I need a trigger of some sort that when that occurs a class is added...

(Access 2010) I have a simple form that contains an image (.png). (Note that the picture property of the form also contains an image (.bmp)...but that's not part of the problem.) I have placed 3 buttons on top of the image. When I open the form I want the image to be centered on the form and...

I have created several different wizards using UsysRegInfo. And they all work fine. The problem they all have in common is that when I exit my Access Db, the wizard database (one that contains the table UsysRegInfo) continues to run. I have to use the task manager to kill the wizard database...

I have a SQL table that I open with ADODB. I than loop thought each of the columns of the record. Is there a property or something that tells me if a column represents an Identity Specification (i.e. autonumber)? (NOTE: There is property entitled "IsAutoNumber". But it returns false for a...

I'm using Access 2010. I have 2 databases: 1) Library.accdb 2)MyDb.accdb. I set a reference to Library.accdb from within MyDb.accdb. Everything works fine (almost). From MyDb.accdb I can open forms and execute functions that reside in Library.accdb. My problem is that within a form in...

I have a library database that contains a bunch of forms. All my databases set a reference to this library database. I have a ribbon that launches forms from the current database and from the library database. When a form is opened a ribbon is assigned to the form. On the ribbon is an image...

I have created an access database that contains my library of routines (Lib.accdb). I then reference this library in my other databases (Other.accdb). Via code in Other.accdb, I open a form that exists in my library database (Lib.accdb). On the library form is a button. Via the onclick event...

I have a combobox that, when populated, exceeds the 64k limit. To get around the problem I programmed the onchange event so that when the user enters the first character I set the rowsource of the combobox (see code example 1 below). And, as the user continues to type, the combobox...

OK, my subject is a little misleading. I know how to get it to work. My problem is that I'm executing the command from within a "wizard" database I've created. For example, I register my wizard as an AddIn and then select an item from the AddIns menu. My wizard form pops up and asks a few...

The treeview control I inserted on my form has been working for several months. Now not only does it not work (click and check events not working) but the properties and their values are blank (via TreeView object properties). I have renamed the activex control MSCOMCTL.ocx and ran a repair of...

I have a listbox that is the size (width and height) of the Detail section. I have 2 buttons ("Save and Close" "Cancel") located in the Form's footer section. Both the Vertical Anchor property and the Horizontal property of the listbox is set to 2 (both). In the on Resize event of the form...

From my current db, I open a form that exists in my library database (codedb). Upon pressing a button on the form, my code creates a query and saves it in my current db. I then want to open that query via DoCmd.OpenQuery "QueryName", acViewNormal. However, because the form and/or code is...

I have some vba code that resides in my library database "MyLib.accda" (to which I have referenced). When the user clicks a button located on a form in my current database "MyCustom.accdb", a form that exists in my library is opened and the activeform (frmMain) is hidden. The library form has a...

I'm trying to load the backstage ribbon programmatically using LoadCustomUI. I can't get it to work. However, if I place the same xml code in the USysRibbons table it loads, does what it's told and fires the onload event. This does NOT happen when it is loade programmatically. When the...