Search results

I hope I can explain this properly but here it goes... I’m designing a building pass and the enrolment software links to our Access Database. We have a combination of 3 areas to which access may need to be granted. IE, some employees have access to 1, two or all areas. On the ID card this is...

Hi, I'm just about to be put into a position where I have to improve a client management system and need some starting points for my research. This CMS will be in the context of taxation servicing several taxes and about 10,000 clients. The current system is written in Delphie for some of...

I have a login form with a button on_click event where it looks up a password in a table. If Me.txtPassword.Value = DLookup("Password", "Staff", "[LoginID]=" & Me.txtUser.Value) Then txtPassword = password text box txtUser = user ID ext box Staff = table with the the following fields...

Greetings wise ones I have a small problem figuring out how to include the “3 strikes and you’re out” code within my login form. I did get a start by using some code that I found in this forum (I can’t recall the name of the author, thanks to him/her in any case). However, is doesn’t seem to...

I want to achieve a simple thing here. I have a form with lots of fields from 1 table. In the first form I show bout 25% of the information from the single table. When a particular record is showing, I would like to open another form with supplementary information from the same table but only...

Greetings, I’m trying to emulate the lookup combo from NorthWind (Employee Details form) but to no avail. I have created the query and reproduced the relevant embedded macros but she is not budging. I get a message saying that the macro is not enabled? Does anyone know how to do this? I have...

I can’t seem to get this. I want to filter on payees that are only paud by 1 payer. Some payees have many payers and most payers have many payees. I probably explained this a bit awkwardly last time. In my example I would anticipate the query to return: Payee Number = 102 (although it...

Hi there, I have a table with "payees" and "payers". A payee can work for many payers and a payer can have many payees working for them. The table records all instances where any payer hires a payee. What are the options if I want to filter on only those payees that only work for 1 payer...

I have tried the Google thing and searched this site but can’t get this in my head. I want to create a junction table and I don’t think I have a problem with this. However, I can’t seem to understand how to get it populated. If I have a table called “kids” and a table called “sweets” and I want...

Greetings, I’m having some problems getting a “where” statement to work. I have a form with several combo boxes which together are (suppose) to set the filter criteria for a report. It filters OK on the first 2 combos but when the next combo is included the report filters only on this third...

Hi, is there a way of showing a picture based on the content of a combo box? Answer - Yes. The problem is that the picture is stored as a field in my "tblFileStatus" table (the status is either IN or OUT and the picture just displays this). This information is then displayed in a combo box in a...

Hi, I’m pretty much a beginner in Access and am running into a few problems with my database. I have a form (frmAssets) that gets it information from a table (tblAssets). The form displays some info in relation to asset tracking, (who, what, where and when type of info) – I trying to adjust a...

Greetings wise one, I tinkered with the Access 2003 inventory tracking template available from MicroSoft and I am trying to make it track paper files. I’m running into a few problems. I have a table in which the file details, a table with the owners of the files (person sitting on the file...

Hi there, I’m new here so don’t shoot me if I’m asking something that is inappropriate. I’m looking to make a DB for paper file tracking simular as you would expect in a law firm. I don’t want to reinvent the wheel so I’m asking if someone has built something like this before. I’m also looking...