Search results

Hi Everyone, I have a sub which uses a collection to store twenty or so variables, each of which I give a name as the key. During debugging I can view the collection in the locals window but the valuables are listed by item number only. Is there a way to view the key name for each item as well...

Hi Chaps, I'm trying to construct a collection of all the subreport names in a report, but I'm having trouble retrieving them. CODE SO FAR: Private Sub Report_Load() Dim rptMain As Report_Xray_PackM1_rpt Dim rptSub As Report For Each rptSub In rptMain Debug.Print rptSub.Name Next End...

Hello, I'm looking for a spot of advice about event calls. I have a form with a datasheet containing three fields, and after an update I have a few lines of code to check what the change was in an "AfterUpdate" sub. The problem is, after the event trigger, which is in the form's event list...

I have a table on a form listing a schedule of parts which are allocated to a client and site. Behind each part listed on the table are two different lists of properties associated with each part. What I'm looking to do is use the Ctrl C (copy) and Ctrl V (paste) to copy and paste records to...

I've just changed from Access 2013 to 2016, but when I open any tables or queries, in 2016 version, I notice the font is "Calibri" instead of "Century Gothic", but if I use 2013 the font is "Century Gothic". So how do I globally change the default font name to "Century Gothic" in the 2016...

Hi Chaps & Chapesses, I have some code to perform a lengthy task of reading a text file and adding the data to fields within various table's record. The text file is long, the field names are varied and the tables are numerous. I have some code to load the text file data into a...

Chaps, I have property data for various items; such as… ITEM-1 Property 1: size Property 2: weight Property 3: manufacturer Property 4: URL address ITEM-2 Property 1: size Property 2: weight Property 3: manufacturer Property 4: URL address …and so on; one of the...

I'm looking for some help handling picture images in my database. What I have is a table that stores a string of the filepath for a jpg image stored on the web. What I'm looking to do is retrieve this image and display it using an image object on a form or report. I can open the image as a...

Chaps, I have a bunch of forms which have a split form layout, datasheet area to the bottom of the forms. I'm wanting to group all these split forms onto a "Navigation" form but when I click the tab for each form to be displayed in the subform area the datasheet split is now missing and all...

Chaps and Chapesses, I have a form with a child that holds a query and for 99.9% of the time remains locked as it's for viewing data only. However, if the user wishes to make a change then they need to press an unlock button first then make the changes. The problem I have is when closing the...

Hi everyone, I've got a split form with a datasheet view in the bottom half of the form, what I'm looking to do is find an event that is triggered when the user selects a different record from the datasheet view, I need to know if the data in the form part has been changed by a new record...

Hi everyone, I have a split form which is used to manage accounts using name, password, account type etc. As the database will be used by people who will have no experience of them I’ve added a command button to add a new record instead of clicking the asterix in the datasheet portion of the...

Hi everyone, I’m trying to construct a query for a report that calculates the internal volume of pipes in litres accurate to two decimal places, but when I view the query the volumes come back with 13 or so decimal places. I’m using a function to calculate the internal volume like so...

Hi All, I've got a report where I want to set the record source to one of six queries using code when I click a command button, and then fire up its print preview. The problem is the code keeps throwing up an error message saying I cannot change the record source once I've loaded the report...

Hi everyone, I’m hoping someone can help with a query issue I have. I’ve got two parts stores 1 & 2, each store issues parts by part number each day, I’m able to get the totals of each part issued by each store per day, but what I’m wanting to find are the totals of the parts issued by both...

I'm running assecc 2007 and I'm trying to edit the wording of a control tip text, but I'm running into a small problem in-so-far-as only the original control tip text I entered is display when I hover over, in this case, the command button. I've written code to change the text for me depending...

Morning everyone, I've noticed a wee problem with a table employing an "ID" auto number field as the only primary key. The table holds six additional pieces of design information for an enginnering application. This table is used in a query to display the data on a split form. I've added...

Hi everyone, I'm running Access 2007 with Windows 7 and I've run into a problem with a split form where the datasheet at the bottom of the form is now showing the data columns in reverse order with the columns reading from right to left instead of left to right. I have the form orientation...

I’m looking to write a common piece of code to get data from a table using the following code: Private Sub MySub_DataFind(My_TblQry As String, My_Field As String, My_Control As String) Dim My_RecordSet As DAO.Recordset, My_DataBase As DAO.Database Dim My_test As String Set My_DataBase =...

I'm have considereable problems trying to get a form I've designed to remember the size I configure. I'm looking for a popup form to auto centre and I want to set its width and height for how it would appear when it is first opened, but each time I size the form and close it the configured...