Search results

I have a simple form with a datasheet subform which could have more than one row of records. I want to be able to double-click on one of the records in the sub form to make the main form locate a record based on the row selected in the sub form. The main form has people's names in it and the...

I need to show the exact date and time when records are added to a table. I've created a small table with 3 fields, one of which is DateEntered, Date/Time and the Format is General which should show the date AND the time. Unfortunately it's only showing the Date, both in the table and on a form...

I am trying to make use of the Error Handling code: http://allenbrowne.com/ser-23a.html I've created the tLogError table and I've copied the code into a Module. What I am not sure about is how to call the function.. Can someone give me some example code as to how to use it? Many thanks Laura

I have been asked to help with an existing Membership Table with individual records for each Member - including title, first name, surname, addr1, addr2, addr3, addr4 and Postcode. Many of the individual members are spouses or family members living at the same address, in most cases just 2 per...

Dear gods of the Database, forgive me for I have sinned.. (sort of). I have just read the "Ten Commandments of Access Database Programming" and I have failed on some, but not all, but will do my best to heed the commandments in future. I have been working in a very small primary school for 14...

I have a very small Access 2002 application which works on Windows 7, but the same coding on Access 2013 with Windows 8 does not work. I think the issue is that once an image is downloaded, it is being cached on the Access 2013/Windows 8 computer. I monitor a wildlife cam which has refresh...

I cannot work out what is happening and hope someone might be able to shed some light and offer some advice. To summarise, I am losing records in one table when I delete from another, i.e., I do want to delete records in one, but the related records in the other are also being deleted. This...

I have written an application using Access 2003 and the person using my application has upgraded to Office 2013. Everything is working fine so far, but one thing is an irritation to the user and that is that she is unable to rapidly scroll through the records on a form by clicking on the left...

I am unable to open an .mdb file without getting this message:- "The Microsoft Jet database engine could not find the object 'MSysDb'. Make sure the object exists and that you spell its name in the path name correctly". I believe the computer was shut down while the database was still open...

I want to be able to show or hide columns in a datasheet (subform) depending on which checkboxes are checked on the main form. I found what looks like the answer I need on this site http://msdn.microsoft.com/en-us/library/aa217449(v=office.11).aspx but can't make it work. There is supposed to be...

I want to be able to have a form that has a grid (datasheet view) below, using the same data (i.e., one query). The idea is that the grid shows the entire query (all fields) other than the memo field which I want to display above the grid. When the user scrolls through the grid, the memo...

I have a small database in a school with only about 80 records in it. There are several data entry forms. The users of the database occasionally want to print one record which they are viewing, so they click on File/Print and end up printing 80 records (forms) and wasting a huge amount of paper...

I have produced a Report, which is a record of pupil assessment each term, but am having problems with the lines between the blocks of text. The text consists of 15 text boxes in 3 columns of 5 rows. Each box contains random text which can be as short as a few words or unlimited as the fields...

I have a very odd thing happening and hope someone can help. I am using a tab control on a form with several tabs. I have many labels and text boxes on the first tab. While I was busy creating and testing my form, I noticed that when I scrolled from one record to another, one or two of the...