Search results

CJ, You made that look so easy! You're awesome!THANK YOU!:cool:

Good day, I have a simple table (or so I thought) attached. It has 5 columns (Ref, Revision,Name, Description, Data). I want to create a query where the duplicate records (defined as rows with identical [Reference] AND [Description]) are compared, and the older (the record with older [Data])...

Brilliant in its simplicity!! Always learn something new with you guys! THANK YOU!:D

Thanks for the reminder on the # in column names. Changed it to Ref. Also great idea not to delete records. Unfortunately I am unfamiliar with the Max([Ref]) Last Ref function. Would you have an example of this? Again, Thanks. :cool:

Thanks for the quick turn around! This query deletes all records with duplicate Ref#s. I would like to keep the Ref# that has the most recent revision. Example: Keep 99e delete 99c

Hi, Looks pretty basic but I seem to be drawing a blank here. I havae a simple spreadsheet: Ref# Rev 97 b 98 c 99 c 99 e 100 c 100 b 101 a 102 b I need to create a simple report but remove the duplicates (ex. Ref# 99,100). I need to delete the older Rev's (Ex Ref# 99 Rev C, Ref# 100 Rev B)...

Have you tried to set the Default Value of the combo box property to blank? (Property Sheet- Data - Default Value)

Hi, I can't help but notice that you are already using Excel but apparently feel that it is missing something and not doing the job for you. Based on the brief descritpion of your needs, Access might be the logical next step.

Just your basic text boxes for the user to enter a UserName and Password and a button to execute the event.

if you post your db I can give it a shot

Try the Nz(Me.iOperatorsCode.Column(1),"") instead of " " for your me.iOperatorsName

There is a great post on "Access Naming Conventions" (of course in this Forum). When you get a chance check it out!!

I assume you have fields for UserName and Password. If that is the case, create a Password Button and on the events code insert the code attached replacing Username, Password, and Form with your dbases' names. Private Sub PasswordButton_Click() Me!UserName.SetFocus...

Appreciate the reply guys. Variables in SQL seems more involved than it looks!

Good day, I'm stupmed on this one, hope someone can help. I am attemptin to use Form entrees as Variables for my SQL FROM and WHERE clause. For some reason the SQL does not accept variables. Looks too simple but I guess it isn't. Form has:TrainingType, TableName, Date, EmpName My sql looks...

Pat, You're right! This came from a huge excel spreadsheet and my code was an attempt to convert the fields into a normalized table. It really is a basic table with names for rows, trained modules for columns, dates for data. I need to dig deeper on how to use make table and append queries to...

You said it, serious fixing! Actually the data came from an excel spreadsheet that the company just kept adding on to and now realize that they were using the wrong approach. The original spreadsheet had over 450 columns! I had to cut it in half. Not being familiar with SQL, I did not know if a...

Hi, I have visited this site a number of times and found it to be one of the more user friendly sites overall. I work with a company in Northern California and have suddenly been finding myself knee deep in Access related projects. Looking forward to a productive exchange, regards!

Good day all, just a relative beginner here with Access. Checked out a number of sites but was unable to find a definitve answer to my issue (that is my Access issue). Below is a sample of my code: SELECT [Employee Name] as TRAINED, 0 as TRNG,[Mod1].[0] AS DATA FROM [Mod1] UNION ALL SELECT...