Recent content by Renoir

Thanks for this. Is it possible to have the combo in a table and have the result of what you pick be placed in a field within the same table? The reason I ask is that I have some software that gives me the choice of selecting fields within a database. It is not a form within Access. Cheers.

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...

Cheers all, I had a look at Bob's example and have some questions about Forms!frmUSL.txtUN = strUser & Forms!frmUSL.txtUSL = intUSL and how this "select case" works. Could you post some comments on this? The on_click event is copied below. Private Sub cmdOK_Click() Dim strUser As...

I was under the understanding that 2007 did't support this any more?

Works like a wild beast. Could I use DLOOKUP for different access levels if I add this to my Staff table? If so, can I use different levels such as edit - write - delete or does Access (2007) offer a more direct solution for this? Cheers, Renoir

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...

What if you have a table with a list of staff user IDs and their passwords? Can this be looked up so that the user is identified and only the password for that user will open the form? Renoir

That was just what the doctor ordered. The reference explained what I needed to achieve as if someone was looking over my shoulder. Thanks to all contributors (another little step closer) Cheers, Renoir

SELECT Clients.ClientID, Clients.ClientNumber, Clients.ClientName, Clients.Concessions, Clients.QuickLodger, Clients.BusinessCategory, Clients.BusinessType, Clients.EntityType, Clients.EmploymentSize, Clients.TurnOverSize FROM Clients WHERE (((Clients.ClientID) Like [Forms]![Clients...

Just a query that I did in query design - the icon looks like 2 pages overlapping. How can I find out?

Thanks Ken Have it working "somewhat". I used this for the button that opens the other form and set the sourse or the form to the query. The only thing is that the query (although working well) opens rather than "executes".:confused: Private Sub cmdOpenClientDemographics_Click() On Error...

That was my original approach and I changed it because Access suggested the form was too complicated (large, I guess). It also introduced some other problems. In any case, not the solution here but thanks for your reply.

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...