Search results

Hey guys, It's finally working for me now! The procudure was created successfully and I have also applied the changes to the actual data by executing the procedure. :) I'm saving these for future reference if I ever need to do something like this again. Big thanks to both of you!!

Thanks guys for your input, really appriciated. Trying both here atm. Feels like it's getting closer. I started off with your input Fear Naught. And I inputed this into the procedure: CREATE PROCEDURE [AP_POT].[Update_ExpectedPaymentDate] -- Add the parameters for the stored procedure here...

Good Evening, Thanks for your input pbaldy! I did the changes you suggested. However I get stuck quite quickly. When I run my create procedure management studio barks at my use of Inner Join. I'm certain it's possible to use joins in sql because I've used them in view's before when creating...

Hi, I'm a regular user of MS Access. However I have a problem which I can't solve in MS Access and have to use SQL and I have limited knowledge of transact-sql. I do monthly imports in Access of different figures but now I have to make a correction to old values. I have a main table...

Hey GHudson, Yes and no, the thing is that trying to call "changefieldnames" doesn't work. Apparently for the function to be execute you have to call the second part in the function "readinfieldnames". I have no Idea why or how it is like this, my limited knowledge about VBA prevents me...

Hey again, I recieved a solution elsewhere just wanted to post it here in case someone else comes looking. Alas the solution was very simple but it never occurred to me as the biginner at these things I am. Anyhow to call my function properly from a button I simply use this code: Private...

I double checked and added a little Msg box to the code for the button. When I press it the my MsgBox text instantly pops up, but the function I'm calling is never run. I added Public in front of the function as you suggested as well but it made no difference. There's probably something...

Thanks for your reply GHudson. I tried what you suggested and just as a start to see if I could get it to work without any other code interfering I put it by it self in a button on one of my forms, the code looked like this: Private Sub Command33_Click() Call...

Hi everyone! I've got a function which I've found on the web wich does exactly what I need it to do. When I run it manually from the Visual Basic Editor (Alt+F11) in MS Access it works perfectly. However I need to include this function in a macro I'm creating. I've connected a Macro to a button...

I've been using my day to try to understand the Dcount thing. I think I'm starting to get a tiny tiny grasp of it but still got a long way to go. I think the problem in the last post is that Transform only works for the data in one column and not for two columns at once. So I tried to...

Update: I tried the solution you proposed right off the bat, I didnt know exactly if I needed to change anything with my original table or not. Anyhow starting with my original table: "Table1" CaseID, TimeStamp, OldTier, NewTier 156, 2010-02-16 11:37, Tier 1, Tier 2 156, 2010-02-16 11:38, Tier...

Hi Galaxiom, I'm not very expecienced with databases but I've seen normalization mentioned before. I'm using ms access right now as excel wasnt able to help me achive what I needed. I hope I can get away with not following all database best practice rules on this one. : ) Anyhow I'm looking...

Hi! I have a problem that I'm not sure how I should tackle. I'm trying to find a way to illustrate my process steps or escalations based on a table containing records for each change in escalation. My table is setup in the following way: CaseID TimeStamp OldValue NewValue 156 2010-02-16...