Search results

I am using Access 2010. I've recently started using this and I have a problem with crashing. It appears to be connected to command buttons and I have noticed that when I drag a button from the toolbar in a form design view, I get a warning that says a possible security concern has been...

I have a report that displays additional data via a sub report under a group header. I need to count the records in the sub report (either yes or no) and display them on the main report. Counting the records in the sub report is not a problem, but I can't get the sum of the total from each...

I'm using Access 2003. When I use the autoexec command to open up a form I get two tabs open on the task bar: The Form Tab and the Database Tab. On previous versions I only used to get the one tab - the Form Tab. How do I get the same with 2003? Many thanks, Saintsman

In a moment of madness, I put a close command before the open form command. Now it just closes the database as soon as I try to open it. Is there a way round the autoexec function? Thanks in anticipation

The 'C' word was used in one of the jokes in the other thread. One of our female members has taken exception to it's use. Other words have been used which can be considered by some as just as vulgar, but have been used without comment. What is it about that word that women don't like? You can...

We have recently converted from Office 97 to 2003 and Windows NT4 to XP. In the old days, when I opened a database up I would use autoexec and the db would open to a particular form. On the windows display it would just show that I had a particular Access database open. On windows XP, if I open...

My company is about to join the 21st century and they are upgrading from MS Office 97 to XP and Office 2003. We have lots of Access databases, many designed by me, so if they don't work next Monday people will start comming to me for answers. As I am only familiar with Access 97 (and I am by no...

I have a form with a field that gives me an average of results. Below the number 10 it works fine - for example, if I have 6.3 as an average it displays 6, if it is 6.7 it displays 7. If however the number is greater than 10 I have a problem. Should the number contain a decimal it rounds down...

I have a form with a field that produces a value based on entries in a sub-form. I have code that produces a different back colour dependent on the value. This works fine provided there is an entry in the sub-form (sometime an entry is not required). If there isn't an entry then the back colour...

I'm looking for suggestions on how to do this. We have a fleet of aircraft that have mixed variants (ie some have cargo doors, others do not). I am looking to control the workcards that are issued for the maintenance. Currently we have them stored on Word. For simplicity, a particular...

This is a continuing problem despite my best efforts. I have a form for inputting data. The first record is a dummy record that identifies itself as for information and has a large field that states to use the binoculars for searching (people type in the number etc into the field and then try...

Very simply, can you get an autonumber to start from zero instead of one?

I wish to develop a simple database that will be used for one job to control all the spare parts that will need ordering for a particular job. For each new job, the operators will take the template of the database, save it and use for just the one job. They will then repeat the process for the...

I am having trouble getting some reports printed. Depenedent on a certain field value I want either two reports printed or three reports printed. My reports are currently selected for print in two macros (2 reports in one and three in the other). How do I select which one I need? This is what...

I tried searching but without success. How do you produce a list in a form that will display one duplicated record as well as non duplicated records? Thanks in advance.

I've got a simple bit of code but I keep getting an error message. "You entered an expression that has no value.The expression may refer to an object that has no value, such as a form , report or a label control." All I wish to do is highlight the fact that my forecast date is overdue...

I,ve been fiddling for ages so someone help me out please. I don't know VBA but I have got the following to work: Private Sub Form_Current() If Date_Forecast.Value = Date + 1 Then Date_Forecast.BackColor = 26367 Else: Date_Forecast.BackColor = 16777215 If Date_Forecast.Value < Date Then...

I am designing a report where I want to print something attached to the last record on each page (a signature block). The problem is that it must be attached to the last record (not always in the same place on the paper) and I can do this by using a report footer. However that will only print on...

I have a form with a combo box where the 'Row Source Type' is a Table/query and the 'Row Source' is a Table (Table 2) which is used purely to provide the information for the Combo Box. This works fine but I have one entry that does not fill in all the information. Is there a limit on the number...

I have a form which contains a sub-form. If I use the spell checker, it does not work for the contents in the sub-form. I get the message that the spell checker only works for fields that are text or memo even though they are of that type in the sub form. Is there a way around this?