Search results

Access allows for a developer to create queries to function as record sources for forms and reports. If the developer uses this practice – he will end up with a number of queries sitting in the navigation pane which have no other purpose than to be a record source for forms/reports. In the...

Hi All, I may have asked this question in a different way a while ago. So I apologize for not remembering the answer. I'm adding a field to a form which essentially points to another field in that form. At first I used the expression builder to create the pointer to the source field. I did this...

Hi all, I've got a friend who has asked me a question about an Access system. I don't have access to this system myself to look at it - so I can only describe. The issue is a form in which there is a control field which either provides a drop-down list or simple data entry. The data value this...

Hi All, I've noticed my Access 2016 only appears to have one label template. What I see there now is called "Label1"and its size parameters are 1.00" x 1.50" I'm assuming Microsoft provides a source for downloading and installing Avery labels? Thanks in advance!

Hi All, I'm trying to find Microsoft's official descriptions of the errors one finds with calculated text box controls on a form. The #Name? error - I believe can occur with two possible situations. 1) Where the record source for the form does not contain table/query field that is being called...

Hi, I know there are different ways to make a combination MAIN/SUB form for a one-to-many relationship. One way is to create the subform perhaps in datasheet or tabular mode and then use the sub-form control to import it into the main form. With this method one ends up with the sub-form as a...

Hi All, A lookup in a table for data-entry can be created from a table or a query. In the case the lookup is created from a table, it establishes a relationship link between the two tables. And the lookup-wizard gives the developer the option of selecting referential integrity for that link...

Hi All, I'm having trouble with changing the width of a form. There is the width parameter and in one case set to 8.1514" When I try to change this number - it reverts back to what it is. Can anyone tell me how to control this parameter? Thanks!

Hi All, I have a sample db for learning purposes. It has 3 tables. Customer Orders Products The Customer table has a CustomerID field and it also has a "CompanyName" field The Orders table also has a CustomerID field which is used to link to the Customer table. The strange thing is - when I...

Hi All, I have Access 2016 and am attempting to make a connection to and query a table. I tried this and got a compile error: DIM rst as ADODB.Recordset But this is working: Dim rst As Object Set rst = CreateObject("ADODB.Connection") Any suggestions on what the script would look like from...

Hi All, I have a subform within a form - which I've added a calculated control (text box) It is simply the formula avg([UnitPrice]). I've named this control "UpAverage" But the subform is in datasheet view and displays the average prices in every row. So I've made this control invisible. Then...

Hi All, When one saves a MAKE query - it is saved in the navigation pate with an exclamation point. I know that one cay open this in design mode and run it in datasheet view to change it back to a NON-MAKE query. And then re-save it. But it is still saved as a MAKE-query in the navigation...

Hi All I have these three ultra simple tables. When I add Table_A to the query editor with this query SELECT TABLE_A.[TABLE_A DATA VALUE] FROM TABLE_A; It returns 6 records - which I would expect. However, when I add TABLE_B into the editor SELECT TABLE_A.[TABLE_A DATA VALUE] FROM TABLE_A...

Hi All, I'm building a new database and one of the tables I originally created with the ID field as an autonumber. However, it became obvious as I continued to refine the DB and add data to it - that the autonumbers are now out of sequence and there are some missing numbers. So I changed the...

I'm playing with macros for the first time. I would like to create a split form based on a query, and have a text field in the top of the form - in which I could enter a search string - which would be used in the where clause of the query. I thought I could do this by using an on enter event...

Hi all! I have a data search form which contains a top section having a text field which initiates a parameter query. I type text into the search box and then press enter. Enter activates a macro which initiates the query and returns the results into a sub-form in data-sheet mode below -...

Hi all, I have Access 2016, and picked up a book specifically on forms. Problem is this book was written for Access 2007. There is a part in the book which describes Access Forms having an auto-format mode. This mode allows someone to create the style/look of their form and then save it. And...

Hi All, I have a table having a field named "MonthNum" - datatype is integer. It holds numbers from 1-12 I can use the MonthName function in a query to get the name of the month using this field. However, when I try to do the same thing in a report - where MonthNum is a field in the report - I...

Hi all, I would love to have a book written by a long-term Access Sys-Dev - specifically dedicated to building professional forms. Over a period of time, I assume one settles on a specific subset of design models, which serve as tried and true for any database project. Any recommendations...

Hi, I am new to Access and especially to reports. I've noticed when creating a report with a group, when I add a label along side the control field which is bound to the group data value, that label appears twice on the reports first page. It is displayed within the group header section and...