Search results

I'm testing/debugging a program I'm setting up about 9 watches for the crucial part of testing I have to end the program to test next part and have to reinput the 9 watches Is there an easier way to do this other than reinput 1 by 1

I'm working on a small database that has linked tables to effectively 2 back ends I went into the link table manager to not only check what's linked to what but to relink everything as well Lo and behold the list of linked tables is empty I can display the contents of each table so they are...

As per title I'm producing a fairly simple report but the width of the controls looks pretty random. Fields with few characters seem to have large widths and others are truncated as the width is far too small. I know I can go in and change the control dimensions but it seems a bit painful. Am I...

I am looking at an access database that uses to and from controls on the main form to control what is displayed in other forms and reports etc. I there an easy way to see which queries uses these controls as their criteria. So I've created a query using the following criteria...

I've inherited an access database. There is at least one instance where a subform is used on 2 different forms. Let's call them form1 and form2. The problem is that code in an event procedure (after update) assumes that the form is form1. The problem is that this event procedure is now...

I've been dragged out of retirement to do a 5 minute job. Unfortunately after 6 years I've forgotten more than I knew. So bear with me if I use the wrong names for things but.... I have a form that is bound to some query. It has sub forms bound to different queries. The form displays list of...

I'm supporting a small single user system that is deployed to various laptops. Other than the faults and bugs I've introduced myself the things that give me most problems are printers. They, the problems, don't always appear to be linked to the printers. I have had many and varied problems...

I've been asked to develop a small database. It'd fairly trivial to do in access but to deploy to a Mac I'd have to get them to install some sort of version of Windows, they'd have to but an access license and if anything goes wrong which turn out to be environmental I can't really test. So...

I've started using the website again and more often or not it's not accessible. I put it down to it being off line for some reason or other but when it started getting really irritating I used some website to see if was down or not and it can back that it was up and running and accessible from...

I want to know what the last set of objects to be updated are. I know I can display objects in order of last modified but the results are limited in that it appears to display those recently modified, those modified with 2 weeks and those older. Unfortunately the changes were made just before...

I have just completed some very small enhancements to a small system. This was with access 2016. I have deployed the software to 2 machines. 1 is using either 2010 or 2016 access the other is , I think 2007. On the 2007 machine he is getting an error to a form that has not changed and worked...

My user wants a report with (unrelated ish) data on it. The unrelated bit comes mainly because of the old design of the database and the fact it's not quite a relational model. I can run several queries to get the data he wants. But how can I then get it onto the report. So I want field 1 from...

I have a continuous form that the user can enter a number of items. he does this by selecting each item from a drop down box. the drop down box can contain quite a few items for each customer. doing it this way it is slow and laborious. I'd like to display on separate form all of the available...

i have an update in some VBA that works perfectly for me but when testing on a spanish network i get a syntax error(3144). The only thing that looks different is updating a number In the UK version I get number = me.number where me.number is 2.35 In the Spanish version I get number = me.number...

I've been making some changing to tables in development, adding and deleting fields changing names etc etc. I now want to copy these into the user test environment. How do I do this. I don't want to lose the data just copy the table definition if you like. I tried using the import database and...

This isn't exactly what I've go tut it's easier to explain this way! I have 2 tables. Items and Orders. Some of the items are longer and have been discontinued. The order form it is bound to a table that contains the item id. I have a combo box. The control source is the item ID from the order...

I want to do something with a control if another control changes. The other control is a combo box. When it changes I want to store the changed value in another control. There is a reason!! So I bascially have Me.atextcontrol = Me.acombocontrol.Column(1) The combo box displays a list of...

OK I could blame this on inheriting a database with missing error handling but it's all my fault! I got carried away with getting the code complete that I've missed quite a few modules without any error handling So basically I need to add a number of lines to each module. 1 at the top and...

I want to validate the fields on a form over and above the definitions that exist in the data definition (i.e. numeric, must be filled in etc). I thought all I needed to do was put a bunch of ifs and elses in the beforeupdate part of the form with a setfocus a cancel = true possible a me.undo...

I have a custom ribbon set up in usysribbons. The ribbon is so the user can navigate around his forms The ribbon contains some access commands that I've put on whilst I'm developing it I want to be able to dynamically alter the ribbon depending upon 1. whether or not it's me running it. if it...