I have a form I use to pay monthly bills. I had a findrecord combo box and a find next record button that worked before MS Access 2007. After I selected the bill I wanted to look at it would fill the form fields with that record and I could edit it. After I converted the DB to 2007 now I get...
I have a database I use. If the database is open and the shortcut icon is clicked again, another instance of the same database is open, so now you have two instances of the same database open. If you enter information in one, it is not reflected in the other until it is closed and reopened...
I have a database that has tables based on the Windows userid of the person who opened the database. When opened a form opens that the user inputs work information for their job. The form is linked to each of their personal userid tables.
The windows userid's where based on the first initial...
I have a bills database and I need to find the last date paid for each bill in the bills table so I can start weeding out bills I don't pay on anymore. I'm tring to do this in a query but can't seen to get it. I've tried using the MAX, DMAX, DMIN, datediff and between dates to not avail.
Any...
Hey Everyone!
I have a birthdate database for work and had to convert it to 2003 access. It tells me how old a person is based on this query expression -
Age: DateDiff("d",[birthdate],Now())+1
This worked great in Access 97 but in 2003 now anyone born after 07/01/1977 it comes up as a year...
Our company installed all new computers which now uses the XP Operating System. All our in-house databases were created in Access 97 before the new computers, and now have to all be converted to Access 2003 using the Access 2000 format. Our Staff uses Access 2000 runtime to be able to access...
I have a text box that shows the forms list box record count using this code in the text box control source.
=Count(*) & " " & "Total Records"
and the text box shows "76 Total Records"
I also have a label box at the top of the form telling you the name of the current table you are looking at...
Hello,
I'm new to the Microsoft Access forum and I have a problem I could use some help on. It is probably a simple solution but I can't seem to get it. I have searched through out the forum with no luck.
I have a combo box that list record names and when you click on that record name...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.