Search results

Hi all, Im not an Access wiz but have managed to build quiet a few different queries in Access which are from tables linked to the software that holds all our data. Im looking for some way to put all these queries in one please for all my colleagues to VIEW ONLY. I just want some sort of...

Hi there, Re: Telephone call logging I started making one of these a few week ago, its been a slow paced project because im new to Accesss. Unfortunately due to my work computer packing up, i have lost my database. Now its time to start again. But before i do i was wondering if there is any...

Thanks guys but i dont seem to be getting the data i need. -Some people may have a position that started before 01/09/2014 and is still ongoing -Some could have a position that started before 01/09/2014 AND a new position that started AFTER the 01/09/2014 meaning they will have two lines of...

Hi CJ, Many thanks for you prompt reply. I have got the code working, but is this only pulling out records that where effective before 01/09/2014? I have gone through the data from the results and there is no records that are effective on or after 01/09/2014. Sorry if i am misunderstanding...

Hi all, I have a query from a table (to reduce the number of fields). The list is all the positions people have performed, as person could have one record another could have 10 the number is unlimited. Fields are:- -employee ID -start date -position I need to find any records that were...

Hi Rx_, Im using Access 2010. The code i have about is code I found online. I will have a read through the information in you link. Many thanks for the reply.

Hi all, I have successfully made a Login form, and now its time to put in some sort of permissions. I have a table called 'Users' with a filed called 'Access Type', there are to choices in this field 'Admin' or 'User' I want to HIDE/LOCK as much as I can in access (Tables, Queries, Forms...

Hi Minty, I solved it with this code 'Changes password on tblUsers and Close form CurrentDb.Execute "Update Users set Password = '" & txtNew & "' where [ID] =" & pUser Thanks for your suggestions.

Hi all, I have found some code online and trying to adapt it to suit my needs. The part its failing at is marked in red. I get error message: Run-time error '2465': Microsoft Access can't find the field '|1' referred to in your expression. Option Compare Database Option Explicit Private...

As simple as that haha... worked as I wanted. Thank you so much :)

Hi all, I have 2 forms, both pretty similar. But I use one for creating new records in a table. And one to View/Edit exiting records. When I open an existing records, and tab through the fields. Once I pass the last field it creates a new record. How do I stop this. Thanks in advance Chris

Yes once complete I will split it so each user has their own front end of it. I have added the below to my vba code, but stuck on what to do with it next. (sorry to be a pain, its nothing like excels vba :( Option Compare Database Option Explicit Dim cUser As String Private Sub...

Sorry... I mean because there maybe many users. But from what your saying, I think I know what you mean. When the user logs in, close the "Login" form but keep the username in the Textbox to refer to? Then maybe have a action that clears the Textbox the next time it runs ready for the next user?

I already have a field in my Call Log table, im just wondering how to tell that field who is logged in when the call is taken.

Hi All, I have a simple Login Form and the following code, for a user to login (obviously if they get the username and password correct). My database is to log calls, and part of the form that is completed is who took the call. The person who took the call is the person logged in, how can I...

Ok I have attached my database. And replaced all data with dummy data. Its what I have so far, just think of the "Employees" table as my ODBC (read-only) table. This table updates from our payroll system. When a new starter is put onto the payroll system. They will show up on the Employees...

Morning (here in the UK) - The time difference means by the time you see my posts I have finished work :( Privateer, I'm confused the first way you suggested first is working the way I wanted? Is this way going to cause me problems in the future. I have tested what you suggested this morning...

The odbc table is read only. But it's only used when I open an existing call log or create a new one. It just looks up the employee Id each time. So the data from the odbc table only ever shows in the form. The only new data that is saved is the call details and employee number to my other...

Oh I didnt see this post from gemma-the-husky. Thank you for your reply. I have been playing with it all morning (the database ) . I think I have managed to get my head around relationships and queries and how they work (kind of). I have two tables:- Employees (ODBC) - List of employees Call...

No employees are ever archived or deleted. Even if they leave they remain on the main/linked table.