Search results

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

I'll keep this simple to begin with!! I have various tables but basically a list of items sold against a date. I want by month how many items were sold per month. here is one order per month To get this I've used the query wizard. I did a bit of research and it seemed I needed a crosstab. THis...

I have a custom ribbon defined in USysRibbons and I want to get rid of the access File tab. Researching this I haven't found how to do this but found something that suggested using backstage to hide all the options under File tab. I've successfully hidden a few using <backstage>...

I thought it was only dates that I couldn't fathom but now I'm stuck on numbers! I want to limit the user to 2 decimal places when input on a form. I can only get as far as displaying the rounded 2 decimal places but can't stop him putting in something like 231.1278364731. It will display as...

I am developing a database for a user who previously used an off the shelf piece of software which didn't entirely fit with his method of working. He's happy with what I am doing but he has been spoilt rotten by the nice to haves he currently experiences with his off the shelf package. One is...

Hi I have a form with various numbers on and in the form footer I sum these. The user now is getting all excited and wants the ability to highlight cells in a column, like he can in Excel, and get the total of these instead. I've looked at how to do this for a few hours but can't see that it is...

I have a table (A) that basically holds invoices. It has an invoice number which the user wants to be sequential. Another table (B) holds the last used sequence number so that. When a new invoice is created the sequence number from Table B is read, 1 added to it and that is used for the new...