Search results

When I change it to [UserName] I get error 2465 saying Cant find field "|" referred to in your expression and it highlights [UserID] = Me.txtUserName.Value this part of the code.

The row source is UserInformation which is the table that contains all the details and column 1 of the table is username. (see attached screen shot)

If Me.password.Value = DLookup("Password", "UserInformation", "[UserID]='" & Me.UserName.Value & "'") Then Thanks!! :) Does this look ok? The logic where it compares the password doesnt seem to work though, because I keep getting invalid password even if I enter the correct password.

It worked when I corrected the syntax!! Thanks!! Another issue came up: whenever I try to log in, even if I put the correct password it keeps giving me the invalid password error. Here is the code. If Me.password.Value = DLookup("Password", "UserInformation", "[UserID]='& Me.UserName.Value&'")...

No, every person has a UserID (text), UserName (text) and password(text) in the table. In the text box on the form, the user selects a username from a drop down list(combo box which points back to the table for the available names to choose from)

Does anyone know why this statement is causing error 2001? If Me.password.Value = DLookup("[Password]", "UserInformation", "[UserID]=" & Me.UserName.Value) Then password and UserName are names of text boxes in a form, while Password and UserID are names of columns in the table UserInformation...

Oh and I wasn't sure where I am supposed to put the code you have written above and how to "call" it. It will be helpful to have the username automatically populated with the username of the person logged on to the computer. Thanks!!

Hey, I have this code for a button which will validate the username and password against stored values in a table. However when I run it I get error 2001 "You cancelled previous statement" The red colored text is highlighted in the code. Do you know what could be causing this? Private Sub...

Thanks insane-ai, I will try it out and let you know.

Thanks guys. The data is sensitive because it contains details about the pay of employees and the security is to prevent one from seeing the pay details of the other. Insane - ai: How do I capture the user's credentials to use in a query? I am new to this stuff - havent done this before EVER...

Hi, I have a database which contains sensitive data. The objective of the security system for the database would be: 1. None of the users should be allowed to change data 2. None of the users should be allowerd to change code/modify database 3. A user should not be able to view other users data...

Hi, I have a cross tab query and a query after the cross tab query that uses MyCrossTabQuery.* in the SQL to select all the columns, since the columns are months and every month a new month will be added and I want that new month to be automatically included. Now, I have a few of these queries...

Hi, 1. I have a summary (union query) query and other queries under it are set to look for parameter values in a form. I want to design a report off the union query. When I try to design a report in the report wizard and select this query of the source the fields of this query are not displayed...

Hi, I am getting error 3070 when I try to run a query based on criteria input by the user in a form. Here is a description of the structure of database: 1. Raw data tables from external source 2. Query aggregating the raw data 3. Query calculating performance metrics by month/Quarter/Year (each...

I have a query built on top of a crosstab query. The query that feeds data to the crosstab query contains data for various months/quarters/years- new month/quarter/year will be added each month. In order to keep up with the newly added month/quarter/year I modified the SQL of the query on top of...

In other words, if I do a CrossTabQuery.* can I specify which columns to exclude? I want to select all column except the ones I exclude.

I think I got it. I was taking the "query on top" as the query BEFORE the crosstab and not the one AFTER the crosstab :D I think it works. except there are some columns such as buyer name etc which I want only once so technically I only want the months/quarter/year from each of these 3 queries...

Namliam, could you dummy it a little more for me please? :) I did not understand what you are saying..

This is the query I have on top of the cross tab query. Incidently I am defining the period by concatenating two columns from a query that is on top of this query. It wont be possible to concatenate in the query on top of this query because other queries use the non-concatenated data. Any way...

Thanks - I am confused.This is how my crosstab query looks. PERIOD1 is the column heading - would it be PIVOT Calc_buyer_MIOH_by_period.*; ? If I put the asterisk there is no mention of the column that contains the column headings - how will access know which column to PIVOT? TRANSFORM...