Recent content by yoonie_85

Hey, i'm not sure if i'm posting this in the right forum, since i'm not sure if I should be trying to solve my problem using a query or a module. I was wondering if anybody knows how to get around this...I have to find the maximum value of each month (May - September) for each person (there...

hello there, I have written a query in access '97 that compares two ID numbers from two separate tables...and if they are equal, i want to copy and paste the phone number, etc into the "originial" from "res_phone" but I keep getting an error that says : "Syntax error (missing operator) in...

Hello :) I'm trying to run my module, but half way into it a pop up comes up saying something along the lines of "MSACCESS.exe has generated errors. and error log is being created. windows will shut down access". i tried using the exact same code on another (smaller) program and it worked...

Hi Wayne, thanks so much for your response... I'm having trouble with this...I'm able to get it working perfectly with recordsets. however as you said this is really inefficient. I want to try and use SQL but I'm not exactly sure of where to start Instead of inputting a yes or no into the...

hello, i've searched through all the posts, but I can't seem to find what i'm looking for. I really need help...here's the situation i have 2 tables table1's first 2 columns are id number column3 is a phonenumber table2's fisrt 2 columns are id numbers, column3-5 are phonenumber, Yes olumn...

I"m really sorry, i'm a beginner when it comes to this stuff... :( does this look right in any way? UPDATE Original SET WH = CASE WHEN EXISTS (SELECT Original.PremCode FROM Original, Data WHERE Original.PremCode = Data.PREM_CODE AND Original.CustCode = Data.CUST_CODE)...

Hello, I have tried combining ur code and my code together to get this.... Sub Create() Dim OriginalRS As Recordset Dim DataRS As Recordset Dim CustCode As Long Dim PremCode As Long Dim Cust2Code As Long Dim Prem2Code As Long Dim I, J, a As Integer Dim TheFile As String Set DataRS =...

I would to it that way....but I dont understand how. :confused:

Hey, thanks so much for the quick reply i've been trying to write a module in VBA...and so far i've come up with this: Sub Create() Dim OriginalRS As Recordset Dim DataRS As Recordset Dim CustCode As Long Dim PremCode As Long Dim Cust2Code As Long Dim Prem2Code As Long Dim I, J, a As...

hello i'm in desperate need of some help, as it is urgent...i have taken a lot of different approaches to this problem, but nothing seems to be working. here's what i'm trying to do... I am trying to write a module in access in which I am comparing two tables. tabel1 has 2 id numbers in the...

Hey... i'm wondering if anybody could help me with this as it is kind of urgent... does anybody know how to compare a cell value in excel to a field in access? I have to compare each cell in the 2nd column of Excel to the 1st field in access. and if they are equal then copy and paste that...

hello...i'm totally new to all of this and i'm in need of some help i have a table in access that has: 1st column - customer names 2nd column - the date from may1-august31 (some days are missing for certain cutomers) column3 - column26 - data for the 24hrs in 1 day. I was requested to find the...