Search results

I've been asked to improve functionality on a form that someone else has designed. Currently, there is a multi-column listbox that can be filtered by two option buttons. Checking one button will display all records, checking the other will display the top 100 records for the user who has logged...

Apologies if this has been covered before; I have searched, but not found quite what I need. My report is based on a crosstab query. I have a couple of calculated controls which calculate percentage accuracy rates (based on the number of checks a person does against the number of errors they...

Gosh, 10 years already, and still using Access! I bet there are other AWForumites who've been members here for considerably longer than I have. Thanks for all the good advice!:)

I've done a quick search, but as I'm not really sure how to succinctly explain what I need to, I'm not able to find what I need. Here goes... I have a regular group of users who need to access a db to log enquiries. Chances are, there will be three concurrent users all day, every day...

I wasn't sure of the best section for this, so opted for 'General'. I have a db which records the results of accuracy checks across different workstreams carried out in our organisation. Aside from the accuracy side of things, it also logs date information. For three workstreams, I need to...

I've created a database to record the outcome of quality checks that are routinely carried out on several workstreams. This db replaces an 'Excel database' (several linked workbooks) and while the structure and data entry side of this seems sorted, the reports I need to replicate are not. The...

I apologise in advance if this is a stupid question. In one db, I have a form where users can choose an email address from a combo, then press a button to send an email to that person. This works perfectly. In another db, I want to do something similar. The difference here is that the email...

I've an unsplit db on a network which is being used by several people. When the db went live, I did split it, however, diabolically slow network speeds meant that after 5 minutes, there was no guarantee that a form would load... More often than not, Access crashed. So, I reverted to an...

Hope that you're having a great day, TessB!:)

Bon anniversaire, I hope you have a lovely day.:)

Has Access developed a mind of its own, or is there something I'm missing? I have a db that has been working fine for ages. Today, I have been doing some data entry, and noticed a few things going wrong. 1. I have a combo box on a subform where I can choose a number. Rather than it displaying...

Dear all Over the past couple of weeks, Access has been acting very strangely, and I'm at a loss as to what do about the problems. I'll number the problems, and if anyone can shed any light on any of them, I'd be grateful. My scenario is this - I have a database which is used in three Areas...

Hopefully someone can offer me some advice on this. I have a db which is now being used in other offices. To do this, I just copied the structure but not the data. All versions of this db have been working fine (for months) until I changed some data today. What I'd like to know is a) what...

Hopefully I'm posting in the right place. I need to create a report with a tricky calculation and I just can't figure out how to do it. Whatever I have tried doesn't seem to encounter all of the null values. Here is the scenario..... The report will be used to monitor how well a scheme went. I...

I intend to set up a help system for my db, where users can press a help button on a particular form, and then a pdf document will appear with the relevant help file.I tried using the following code Private Sub Command1_Click() FollowHyperlink "c:\pdf\project1.pdf" End Sub and this works fine...

I apologise in advance if this has already been covered (did a quick search, but haven't found anything), and if I've explained my problem badly. For reasons known only to IS, I am not permitted to have my db on a central server where different offices can view their version of it. Therefore, I...

I apologise in advance if this has already been covered (did a quick search, but haven't found anything), and if I've explained my problem badly. For reasons known only to IS, I am not permitted to have my db on a central server where different offices can view their version of it. Therefore, I...

On my main form which lists scheme details, I have a button which opens a search form. This has cascading combos on it. Once the user has selected what they want, they press a button and then return at the record they chose on the main form. However, I realised that the search form could be used...

I have a field (txtRevisedStartDate) which holds the revised start date for works. Currently, this is overtyped if a new revised start date is given. I don't need to hold information about all of the revised dates, but I would like to know how many times this field has been altered. I tried...

For information... For some time I have been hunting for info about code that automatically resizes your forms depending upon the screen resolution your machine is set to. I have searched posts on these forums, and like many others, have found that some very useful code (courtesy of the Access...